Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

querying

ResolvedVersion 2003

Stephen has attended:
Access Introduction course
Access Intermediate course
Access Introduction course
Access Intermediate course

Querying

If you left out a junction table but kept two other tables, could you still get results?

RE: Querying

Hi Stephen,

Thank you for your question and welcome to the forum.

If you remove a junction table, the two tables will not be linked. When you run a query based on the two tables, as there are no links, Access will return all the records of the database.

I hope this answers your question.

Regards

Simom

Wed 29 Apr 2009: Automatically marked as resolved.

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.