Microsoft Office Tutorials and References
In Depth Information
Review Assignments
Review Assignments
Practice the skills
you learned in
the tutorial using
the same case
scenario.
Data File needed for the Review Assignments: Provider.accdb
In the Review Assignments, you’ll create a new database to contain information about
the suppliers that Belmont Landscapes works with on its landscape design projects.
Complete the following steps:
1. Create a new, blank database named Supplier , and save it in the Access1\Review
folder provided with your Data Files.
2. In Datasheet view for the Table1 table, rename the default ID primary key fi eld to
CompanyID . Change the data type of the CompanyID fi eld to Text.
3. Add the following 10 fi elds to the new table in the order shown; all of them are Text
fi elds except InitialContact, which is a Date/Time fi eld: Company , Product , Address ,
City , State , Zip , Phone , ContactFirst , ContactLast , and InitialContact . Resize the
columns as necessary so that the complete fi eld names are displayed. Save the table
as Company .
4. Enter the records shown in Figure 1-30 in the Company table. For the fi rst record,
be sure to enter your fi rst name in the ContactFirst fi eld and your last name in the
ContactLast fi eld.
Figure 1-30
Company table records
CompanyID
AND225
Company
Anderson
OnSite
Holland
Nursery
Best Paving
Product
Site
furnishings
Plants
Address
200 Lincoln Dr
City
Kalamazoo
State
Zip
49007
Phone
269-337-9266
ContactFirst
Student First
ContactLast
Student Last
InitialContact
6/3/2012
MI
HOL292
380 W 20th St
Holland
MI
49424
616-396-9330
Brenda
Ehlert
9/2/2013
BES327
Pavers
780 N Main St
Rockford
MI
49341
616-866-6364
Shirley
Hauser
2/14/2013
MID312
Midwest
Lighting
Backyard
Structures
Outdoor
lighting
Play
equipment
435 Central Dr
Battle Creek
MI
49014
269-979-3970
Weston
Caldwell
5/15/2012
BAC200
105 E 8th St
Holland
MI
49423
616-396-3989
Alan
Bastian
4/15/2012
5. Oren created a database named Provider that contains a Business table with supplier
data. The Company table you created has the same design as the Business table.
Copy all the records from the Business table in the Provider database (located in the
Access1\Review folder provided with your Data Files) and paste them at the end of
the Company table in the Supplier database.
6. Resize columns in the datasheet, as necessary, so that all the fi eld values are
completely displayed, and then save the Company table.
7. Close the Company table, and then use the Navigation Pane to reopen it. Note that
the records are displayed in primary key order.
8. Use the Simple Query Wizard to create a query that includes the Company, Product,
ContactFirst, ContactLast, and Phone fi elds (in that order) from the Company table.
Name the query CompanyList , and then close the query.
9. Use the Form tool to create a form for the Company table. Save the form as
CompanyInfo , and then close it.
10. Use the Report tool to create a report based on the Company table. In Layout
view, resize the CompanyID, City, State, Zip, Phone, ContactFirst, ContactLast, and
InitialContact fi elds so they are slightly wider than the longest entry (either the fi eld
name itself or an entry in the fi eld). Also, resize the box containing the total amount
that appears below the CompanyID column so that the amount is completely
displayed. Display the report in Print Preview and verify that all the fi elds fi t across two
pages in the report. Save the report as CompanyDetails , and then close it.
 
Search JabSto ::




Custom Search