Home » Microsoft Access
9

Forms and Queries

Part of retrieving information from your database is setting up forms and queries.

In This Chapter:

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
Forms
Forms are the primary interface between users and MS Access applications.
Building a Query
Michael is now ready to build another query for the First Report - Skills by Job information.
A Simple Search on a Single Field
Now that you know how forms can be used to display and edit data, find out how forms can be used to search for data or sort data in datasheets.
Adding a Filter to a Form
A filter can restrict or sort the information displayed in the form without creating a new query.