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

table queries

ResolvedVersion 2007

Kelly has attended:
Access Intermediate course

Table queries

How can i make a table query?

RE: table queries

Hi Kelly

Thank you for your question.

First create your query in the normal way, selecting required fields and inserting relevant parameters.

Then click on the "make table" button on the design ribbon. You will then be prompted to supply a name for your table.

Enter the name, click OK and run the query. You will then be cautioned that ou are about to create a table. Click OK and the table will be created

Regards

Stephen

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

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.