Access Lesson #5

1. Start>programs>Access>open an existing database>OK>file name: dbSurvey.mdb>open
2. Queries>new>design view
3. Show table>add tblCustomers>add tblRestaurants
4. Select the following fields to include in the query (last name, first name, age, gender, area of residence, email, company name, city)>drag field names from upper pane to the lower pane
5. (Optional Step) Criteria>write in comparison operators (i.e. in the last name field >M)
6. (Optional Step) Comparison Operators: = equal to, > greater than, < less than, >= greater than or equal to, <= less than or equal to, <> not equal to, NOT not equal to, Between...and... greater than or equal to the first value and less than or equal to the second value
7. Save>qrySurvey
8. Run>click the ! button on the toolbar>it is blank because we have not inputted the data yet.

Copyright@2000(K. Kim). All Rights Reserved