TABLES
  Create a table
  Primary Keys
  Switching Views
  Entering Data
  Manipulating Data
  Advanced Examples

QUERIES
Using the Wizard

FORMS
Introduction
Creating a Form Using Wizard

Microsoft Access

Queries

Next up....Forms >>

A query requests data from the database. At its simplest, a query merely fetches all data from a single table. But as you create more complex (and more typical) queries, you can assemble exactly the data you want.

Create a Simple Query Using the Wizard

This is the fastest way to create a query based on one or more tables or queries.

Highlight Create query by using wizard and click New.

Select the Table (or query) to use....

Move fields to the Selected Fields column by clicking the arrow for ease selection.

To include all fields in the query, use the "double arrow" button.

Click Next when ready....

Name the query and click Finish......

And the result displays....

Next up....Forms >>