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 » Delete Query

	98.1 % recommend us
	More live stats...

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

Training information:

Delete Query

Resolved · Low Priority · Version 2007

Reply Tue 24 Mar 2009, 17:20Delegate Rachel said...

Rachel has attended:
Access Intermediate course
Access Advanced course

Delete Query

How do you create a delete query using a lookup value?

For upcoming training course dates see: Pricing & availability

Reply Mon 30 Mar 2009, 13:22Trainer Carlos said...

RE: Delete Query

Hi Rachel

To delete records from a single table, or from tables with relationships, first create a new query containing the tables that you want to use (eg Products and Suppliers), Then:

1. In Query Design view, click the Delete Query button in the Query Type section. This adds a delete line to the query.

2. Drag the asterisk (*) from the tables you want to delete records from (Products) to the design grid. The word From appears in the Delete cell.

3. Drag the fields that you want to use as criteria to the design grid. For example, if you want to delete all records of Products from California from the product table you should drag the State field from the Suppliers table to the grid. The word Where appears in the Delete cell.

4. In the criteria cell type the criteria that you want to delete. In this example, you would enter "California"

However to use a lookup value in place of

Thu 9 Apr 2009: Automatically marked as resolved.

Access articles

· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Making The Transition To Access - Why You Might Need It
· How To Understand Access As A Relational Database
· Sub-reports And Sub-forms In Access 2007
· Convert a Paper Trail to a DBMS

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

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips