Microsoft Office Tutorials and References
In Depth Information
ACCESS LEVEL I TUTORIALS Tutorial 1 Creating a Database Creating a Database to Contain Customer, Contract, and Invoice Data
1
TUTORIAL
Creating a
Database
Creating a Database to Contain Customer,
Contract, and Invoice Data
OBJECTIVES
Session 1.1
• Learn basic database concepts
and terms
• Explore the Microsoft Access
window and Backstage view
• Create a blank database
• Create and save a table in
Datasheet view
• Enter fi eld names and records
in a table datasheet
• Open a table using the
Navigation Pane
Case | Belmont Landscapes
Soon after graduating with a degree in Landscape Architecture from
nearby Michigan State University, Oren Belmont returned to his
hometown of Holland, on the shores of Lake Michigan. There, Oren
worked for a local fi rm that provided basic landscaping services
to residential customers. After several years, Oren started his own
landscape architecture fi rm, Belmont Landscapes, which specializes
in landscape designs for residential and commercial customers and
numerous public agencies.
Session 1.2
• Open an Access database
• Copy and paste records from
another Access database
• Navigate a table datasheet
• Create and navigate a simple
query
• Create and navigate a
simple form
• Create, preview, navigate, and
print a simple report
• Learn how to compact, back
up, and restore a database
Belmont Landscapes provides a wide range of services—from
site analyses and feasibility studies, to drafting and administering
construction documents—for projects of various scales. Oren and
his staff depend on computers to help manage all aspects of the
fi rm’s operations, including fi nancial and information management.
Several months ago the company upgraded to Microsoft Windows
and Microsoft Access 2010 (or simply Access ), a computer program
used to enter, maintain, and retrieve related data in a format known
as a database. Oren and his staff want to use Access to maintain
such data as information about customers, contracts, and invoices.
He asks for your help in creating the necessary Access database.
STARTING DATA FILES
Access1
Tutorial
Review
Case1
Case2
Case3
Case4
Oren.accdb
Provider.accdb
School.accdb
Health.accdb
RRGroup.accdb
Travel.accdb
AC 1
 
Search JabSto ::




Custom Search