Microsoft Access: Using a Database (Chapter 5 – small businesses activity)
Prep: Go online to www.mapquest.com and look up your address. On the map display select search nearby
categories – look through list for unique small businesses (not popular franchises). You will select 10 to enter into
the database.
__________________________________________________________________________________________________________________________
1. Create a new Access database: Local small businesses (in access you save the file first and it autosaves as you work)
2. Make a new table
a. Click on Table tab (may already be selected)
b. Click on Create table in Design view
c. Fill-in as shown below (tab between columns)
Field Name Data Type Description
Business Name Text
Street Address Text
City Text
State Text
Zip Text
Phone Text
Been There? Yes/No
3. Save your table as Your Name’s Local Businesses. Answer yes to create primary key question.
4. Use view menu to switch to datasheet.
5. Enter 10 records/businesses into the table.
6. Close the table – it saves automatically.
__________________________________________________________________________________________________________________________
7. Now you are ready to do a query
a. Click on the query tab
b. Click on Create query in Design view
d. Add the table Your Name’s Local Businesses
e. Click on Close in the Add Table window
8. For query #1
a. Double click on Business Name in field list box
b. Double click on Phone in field list box
c. Click on ! in toolbar OR from the query menu, select run
You should now see the results of your query
d. From the file menu, save query as: Your Name’s Local Business Phone List
e. Close this query.
9. Create another query (#2) by clicking on Create query in Design view, add the table again
a. Double click on Business Name in field list box
b. Double click on Street Address in field list box
c. Double click on Been There? in field list box
d. On the Been There? criteria line, type: No
e. Click on ! in toolbar OR from the query menu, select run
You should now see the results of your query
f. From the file menu, save query as: Your Name’s Local Businesses to Visit
g. Close this query.
__________________________________________________________________________________________________________________________
10. Create a report.
a. Under the report tab select Create report by using Wizard.
b. Base this report on the query Your Name’s Local Businesses
c. Select all the fields and select next in each screen of the wizard.
d. Save the report as Your Name’s Local Businesses Report and then click on finish.
e. View the report.
11. Exit access. It automatically saves. I’ll come check your work.