Completely New to Access 2010 With a Question

[bobsap]

I just started using access yesterday, and I have to do an assignment for a class where I need to create a basic database. So I decided to create a "book collection" database where you can record the data of author names, title names, publication dates, etc.



So far I have two tables: the Authors table and the Books table.

the two tables are as follows:

http://img217.imageshack.us/img217/8899/tablesj.png



The primary key for the authors tables is Author ID. The primary key for the Books tables is IBN. And author ID is found in the second table. I don't even know if I did that part right..

Here's the thing. I want to do things like query the database for a list of author names and the books that they've written. And I want to create a form that updates both the authors and books tables at once. A form that asks for book title, author name, etc.

First of all, is this possible... and second of all, can one of you please help me? Thank you very much!

[June7]

Yes, is possible.

The data scheme you have allows each book to have one author and each author can have many books.

The form would be a form/subform arrangement. Main form bound to the author table and subform bound to books table.

This is basic Access functionality and Help reference has guidelines on building forms and queries.