Forms to create

Make four forms - one each to enter book, author, and publisher data to the database, and one to order new copies of books already in the book table

  1. make three basic forms to create tools to enter data into your author, publisher, and book tables.
  2. then create a new orders form.

Were you to wish to do it, you could turn this form into a report to provide you a paper copy of your order form.

  1. Create an Author Form to populate the Author database
    • create a form that can be used to enter authors into the authors table
    • add a title to the Author form in its header (make the font size sufficiently large and distinctive)
    • you need to add any new authors that are associated with the new books you will add via the book form (using the data provided below, though you can add more if you wish)
    • Remember, the sole purpose for this form is to provide a method for someone to enter new author information into the Author table.
  2. Create a Publisher Form to populate the Publisher database
    • create a form that can be used to enter publisher data into the publishers table
    • add a title to the Publisher form in its header (make the font size sufficiently large and distinctive)
    • add the new publishers in the data provided below, though you can add more if you wish
    • Remember, the sole purpose for this form is to provide a method for someone to enter new publisher information into the Publisher table.
  3. Create a Book Form to populate the Book database

    this will be a bit more complex than the first two forms

    • create a form that can be used to enter books into the books table
    • be sure to include a subform that shows the authors linked to that new book (this will require you to create a record in the BookAuthor form)
    • remember, you must add books to the database before you can order them
    • add a title to the Book form in its header (make the font size sufficiently large and distinctive)
    • add the new books in the data provided below, though you can add more if you wish
    • This form has two purposes.
      1. The main form is to provide a method for someone to enter new book information into the Book table.
      2. The subform is to provide a method for someone to create a relationship between the book just entered into the Book table and an existing Author already in the Author table. The subform creates a new connection between book and author(s) in the BookAuthor table.
  4. Create an Orders Form to record any new books we will purchase to add to this database

    this will incorporate fields from several tables into this one form

    • create a form that can be used to enter orders into the Orders table
    • the form needs to include both the book name as well as the publisher name and mailing address
    • you need at least ten orders of which at least five should not yet have been delivered (no value in the received date field)
    • add a title to the orders form in its header (make the font size sufficiently large and distinctive)
    • This form is to provide a method for someone to order one or more copies of a book title that already exists in the Book table. Since it is an order form, it should have built into it all the necessary information about the book title being ordered, plus the address of the publisher to whom it will be sent.

[top]

General Appearance of Forms

Pay attention to the professional appearance of all forms. Make sure items in a column of the form are aligned.

[top]

Data to add to your database using your newly created forms

Here are some new books to add to your database by using your books form. You may add others, but you must add these.

  1. Check to see if the publishers of these books are already in the Publisher table
    • if they are not, add new publishers to the database in the Publisher form first
  2. Check to see if the authors of these books are already in the Author table
    • if they are not, add new authors to the database in the Author form first
  3. Enter the new book to the database using the Book form
    • the information in the Author subform will appear when you do the next step
  4. Finally, link the new book to the author(s), using the subform in the Book form
    • the results of this action will create a subform record in your book record in the Book form.

Books to add to your database

Critical mass : how one thing leads to another, by Philip Ball, New York : Farrar, Straus and Giroux, 2004. HM585 .B35 2004

I am a strange loop, by Douglas Hofstadter, New York : BasicBooks, 2007. BF311 .H64 2007

Imperial life in the emerald city : inside Iraq's green zone, by Rajiv Chandrasekaran, New York : Alfred A. Knopf, 2006. DS79.769 .C53 2006

Books to order

You may order any titles that exist in your Book table, but be sure to create at least ten separate orders. Five of the orders should have a delivery date included; five should not have a delivery date yet. Don't restrict yourselves in your orders. Make them for large numbers of copies in each order, so that your queries will show large variances when you run them.

[top]


why & how to create forms for input | subtask 05.03 | reports for output | subtask 05.04 | next session