Access Database bad structure, Queries...beginer

  • Thread starter Thread starter Sibo
  • Start date Start date
S

Sibo

Ello! Im beginner so need some help and answers plz. To make it short:
Imaginary dbase..
I have 3 tables: Authors, Books, Cathegory (book cathegory)

Authors:
AuthorID...[Autonumber ..Primary Key]
Name [text]
Lastname [trxt]

Books:
BooksID [autonumb..PK]
AutorID [number]
CathegoryID [numb]
Title [text]
PublishingYear [number]

Cathegory:
CathegoryID [autonumb..PK]
Note [text]


So, which fields to connect.. i mean, i wanna get somethin like: you enter
AuthorID or NAme and u get all the books written by that author.
For those, i need Queries..right? Queries are made for "those common handy"
things...? Any handy query ..what do you suggest?

Ty, and once again, sry for these n00b questions..

Regards,
T
 
Create a new query in design mode.

Add the Authors and Books tables. Access should put a join line between the
AuthorID fields in both tables (although you have it spelt AutorID in your
example).

Drag and drop the Name and Title fields from their tables to the Field row.

Run the query.
 
Back
Top