Queries

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

Resolved · Low Priority · Version 2003

1 post

ReplyMon 27 Oct 2008, 15:42Delegate Kara said...

Kara has attended:
Access Introduction course

Queries

How can you create queries to split up tables and create new tables?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

635 posts

ReplyFri 21 Nov 2008, 16:21Trainer Carlos said...

RE: Queries

Hi Kara

A Make table query allows you to take data from an existing table in query form and then create a new table. To do this:

1. Create a query from the table you want to split holding the fields you want to go in the first table.

2. Click the Query Types button on the toolbar and select Make-Table Query...

3. Enter the new table's name in the Table Name text box

4. Click OK and then save the query

5. When you run the query it will create the new table you require.

6. Repeat for the rest of the data in the original table

Hope this helps

Carlos

Fri 28 Nov 2008: Automatically marked as resolved.

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· User-Proofing Your Access Database: Part 2
· Take an Access Course to Learn About Relational Databases
· Bring Access Up To Speed
· Access VBA Training Adds Power to your Databases

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

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips