Forms to create

Make three basic forms to accomplish the task and to have a tool to enter data into your tables.

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)
  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
  3. Create a Book Form to populate the Book database
    • 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
  4. Create an Orders Form to record any new books we will purchase to add to this database
    • 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)

[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

[top]

[simple queries]

Last updated on

Image