Table queries

The UK's most regular instructor-led training courses.
Training information: access courses in london · Microsoft access courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

Table queries

Kelly has attended:
Access Intermediate course

by - delegate Kelly [2 posts] (2008 Jun 24 Tue, 16:12) Reply

How can i make a table query?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: table queries

by - trainer Stephen gold contributer [369 posts] (2008 Jun 25 Wed, 11:27) Reply

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

· Microsoft Access Training Unleashes the Power of the Pivot Table
· Take an Access Course to Learn About Relational Databases
· Access VBA Training Adds Power to your Databases
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!

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

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips