Creating a Subform

[Bacnka]

Hello,

I've been given coursework to complete a series of questions that relate to using Access.

a lot of them relate to Queries.

I have been given two databases with information about books. One includes basic information with the other going into more detail.

The question is as follows:

A: You are required to create a form to aid the entry of new books, one which will append date to both tables. This must be a subform, otherwise data may not be appended.

B: You will then be required to add three new titles to the database. The titles will be the three volumes of your autobiography, (so you will obviously be the author) and the title should be "The Mystery of My Success" - Volume One" etc...

When I go into forms and click form wizard I get confused. I'm asking for a little guidance as to what to do as I am unfamiliar with the program and don't appear to be doing it correctly. How do I ensure data will be added to both tables, and will be appended to the tables? (appear at the bottom?).

Any help would be greatly appreciated.

 

[3dman]

Hi,

We will start with Question A.
When you are in the form wizard:
- under "Tables/Queries" select Query:XXX (books with baic info table)
- Click on the ">>"
-Next
-Option button "Datasheet"
-Finish

After these steps go into "Form View", this should show you the form with the tables info. Now place a command button onto the form.