Help with simple book catalogue assignment

[Guest]

Hi,

I'm doing an assignment for my partner creating a simple database of books
using access and I don't really know what I'm doing. I've created two tables,
one with a list of authors (each with a unique number) and a table of books
related to the author list by the author number.

Is it possible to create a form where the end user can type in an author's
name and a list of the books, ordered by publication date, will be produced?
If so, can this be done using wizards, or relatively simply, ie not via too
much programming style work?

I've got a report going that lists all Author's followed by the their books,
but want to be able to just show one author and their books at a time.

Thanks - Craig

 

[Brian]

Hi,

I'm doing an assignment for my partner creating a simple database of books
using access and I don't really know what I'm doing. I've created two tables,
one with a list of authors (each with a unique number) and a table of books
related to the author list by the author number.

Is it possible to create a form where the end user can type in an author's
name and a list of the books, ordered by publication date, will be produced?
If so, can this be done using wizards, or relatively simply, ie not via too
much programming style work?

I've got a report going that lists all Author's followed by the their books,
but want to be able to just show one author and their books at a time.

Thanks - Craig

The simplest way would probably be:

1. Create a form bound to the books table (using the wizard, if you like)
2. Add a Combo Box to the form, and have it bound to the author number
BUT displaying the author name (the Combo Box wizard will guide you through
this)
3. Then, you can use the built-in Access filtering feaures to restrict to
just one author.

 

[Guest]

Thanks Brian

The simplest way would probably be:

1. Create a form bound to the books table (using the wizard, if you like)
2. Add a Combo Box to the form, and have it bound to the author number
BUT displaying the author name (the Combo Box wizard will guide you through
this)
3. Then, you can use the built-in Access filtering feaures to restrict to
just one author.