Tip:
Highlight text to annotate it
X
We will learn to create Tables, Queries, and Reports
Launch Program --> Create Database
View --> Design View
Title each record accordingly
View --> Datasheet View
Input all relevant information into each cell
A query allows the user to choose and retrieve data from one or more tables
Create tab --> Query Design
Double click ID, Last Name, First Name, and Hourly Rate
Sort field --> Ascending --> Run
Right click query1 tab --> Save
Create tab --> Query Design
Add ID, Last Name, First Name, and City fields
In the criteria field, type "Grant City" --> Run
Right click query1 --> Save
Create tab --> Report Wizard
All all fields to the right column --> Click next
Click Next
Click dropdown box --> ID --> Next
Ensure Tabular is selected --> Next
Ensure Concourse is selected --> Next
Click Finish