You could also use the Query Wizard button next to it to launch the Query Wizard, however, Design view gives you more control over the query.Īccess will ask you to select the tables to include in the query. Click the Query Design button to create a query in Design view.

OK, so now that we have data, we can create the query.Ĭlick the Query Design button from the Ribbon. On the Orders table, make sure the values of the CustomerId and ProductId fields match those in their respective primary key fields.This means you won’t be able to enter a value into a foreign key field that doesn’t correspond to a value in the primary key field. You need to do this because we set up the database to enforce referential integrity. Then once all the primary keys are populated, you can enter data into the Orders table. 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 pdf