Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Table queries

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Table queries

Resolved · Low Priority · Version 2007

Reply Tue 24 Jun 2008, 16:12Delegate Kelly said...

Kelly has attended:
Access Intermediate course

Table queries

How can i make a table query?

For upcoming training course dates see: Pricing & availability

Reply Wed 25 Jun 2008, 11:27Trainer Stephen said...

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 articles

· Why Do I Need To Use Access?
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Cheating With Access Templates
· Sub-reports And Sub-forms In Access 2007
· How To Make Access 2010 Databases Compatible With Access 2007

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips