How to Design a Query
Under the Microsoft Access View menu, point to Database Objects, and then select Queries. See the example below.
The ‘Show Table’ screen will appear similar to the example below with a list of tables in the database. Select the table name and click on the ‘Add’ button.
Repeat the steps above for each table to include in your query.
When all of the tables have been selected, click on the ‘Close’ button to close the ‘Show Table’ screen.
The following screen will appear. Both the Author and Book tables have been selected and will now appear in the top half of the query design window.
Go to the book’s table field list in the top half of the query design window. Double-click each field to add the following fields: BookID, BookName, AuthorID.
In the Author table field list in the top half of the query design window, double-click the *. Clicking on the * is the equivalent of selecting all the fields from a particular table.
The query design window should appear similar to the following example.
In order to save the query, click the (Save) button on the Quick Access Toolbar at the top of the screen. A ‘Save As’ pop up box will appear that will ask for the Query Name. In the example below, the query has been named qryBookAuthor (it is common to preface your query name with the words ‘qry’.)
The newly named query now appears as ‘qryBookAuthor’ under the Queries Objects.
Double-click on the Query (eg. qryBookAuthor) or click ‘Run’ from the Design Tab to view the results of the query.
By Admin at 17 Nov 2015, 16:27 PM