Access Database bad structure, Queries...beginer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sibo - 21 Apr 2008 15:11 GMT

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

Reply to this Message

Jerry Whittle - 21 Apr 2008 17:08 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Ello! Im beginner so need some help and answers plz. To make it short:
> Imaginary dbase..
[quoted text clipped - 25 lines]
> Regards,
> T

Reply to this Message