Basic table/query/form 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 for fields:

(Author table)
Author ID, Author Name.

(Book table)
IBN, Book Title, Author ID.

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!

 

[Alansidman]

This should help you in understanding how to put the two tables together in a form. Sub forms.

http://www.datapigtechnologies.com/flashfiles/subforms1.html

Here is a basic tutorial on Queries.

http://www.online.tusc.k12.al.us/tutorials/access/accquery.htm

Alan

 

[bobsap]

Thank you for the links, Alan. I'll see if I can figure this out.

 

[jDa]

I've needed a refresher so often on this, I made myself a one-page cheat sheet. Maybe it will be useful to you. Good luck...