Home » Microsoft Access » 09 - Forms and Queries
9

Query

With the detailed inputs already on the Tables, Michael is now going to build a query form. While it is not always necessary to build a query, it helps to know that Relationships are set up correctly and that the form will work. The queries also help to r

Query

  1. Select Query > New.
  2. Select the Design View.

  1. Select all four tables.
  2. Click Add.

  1. Click Close.

  1. On the employee table box at the top, highlight all fields except (*).
  2. Drag and drop them to the grid area (where you see Field, Table, Sort, show etc).

  1. In the same fashion, drag everything except
    • Social security number from the Contact Table
    • Job position field from the Job Table
    • Social security number from the Skills Table.
  2. Save your query as qy:empApp.

  1. Verify after saving.
  2. You should see qy:empApp:Select Query.

Note: You should never save a table, query, form or report as the same name as another table, query form or report to avoid errors.

  1. To test the query, click Run.

Note: You can run your query even though you do not have data in your tables. If everything is okay it should work. It looks like an excel spreadsheet, with headers and no data.

Discuss this in the forums

< Prev
|
Next >