Do the Orders table last. Enter data into the Customers table and the Products table first.

Only enter data into the two middle fields of each table.

No need to enter data into those fields (remember, one’s an AutoNumber and the other has a Default Value set).

The ID fields and DateCreated fields will be populated automatically.

You can copy the data from these tables or you can add your own. (If you already have data in your tables, skip this step). Here are the three tables that we created earlier in the tutorial, but this time they contain data. You’ll need to have some data in your tables before you create a query. Simply open it from the database and it’s ready to go. So no need to rebuild the same queries over and over again. Queries can also be saved to the database. But it’s not just any old search.Ī query allows you to specify exactly which fields you want returned, and from which tables.Ī query also lets you add criteria for filtering the data. So for example, you could specify that you only want to see orders worth more than $100, or only products of a particular brand, or only customers who have only ever purchased one item, etc. Queries allow you to “search the database”.

Create a macro (so that a multi-step task can be done automatically – at the click of a button).

Create a query (so you can “search the database”).

This article is Part 3 of the Microsoft Access tutorial.

Microsoft access 2013 tutorial 7 case 1