Microsoft Office Tutorials and References
In Depth Information
Tutorial 2 Building a Database and Defining Table Relationships Creating the Invoice and Customer Tables
2
TUTORIAL
Building a
Database and
Dei ning Table
Relationships
Creating the Invoice and Customer Tables
OBJECTIVES
Session 2.1
• Learn the guidelines for
designing databases and setting
fi eld properties
• Modify the format of a fi eld in
Datasheet view
• Create a table in Design view
• Defi ne fi elds and specify a
table’s primary key
• Modify the structure of a table
Session 2.2
• Import data from an Excel
worksheet
• Create a table by importing an
existing table structure
• Add fi elds to a table with the
Data Type gallery
• Delete, rename, and
move fi elds
• Add data to a table by
importing a text fi le
• Defi ne a relationship between
two tables
Case | Belmont Landscapes
The Belmont database currently contains one table, the Contract
table. Oren also wants to track information about the fi rm’s
customers, both residential and commercial, and the invoices sent to
customers for services provided by Belmont Landscapes. This
information includes such items as each customer’s name and address
and the invoice amount and invoice date.
In this tutorial, you’ll create two new tables in the Belmont
database—named Invoice and Customer—to contain the additional
data Oren wants to track. You will use two different methods for
creating the tables, and learn how to modify the fi elds. After adding
records to the tables, you will defi ne the necessary relationships
between the tables in the Belmont database to relate the tables,
enabling Oren and his staff to work with the data more effi ciently.
STARTING DATA FILES
Access1
Tutorial
Review
Case1
Belmont.accdb (cont.)
Customer.txt
Invoices.xlsx
Sarah.accdb
Goods.xlsx
Supplier.accdb (cont.)
Lessons.xlsx
Music.accdb
Pinehill.accdb (cont.)
Student.txt
Case2
Case3
Case4
Center.xlsx
Fitness.accdb (cont.)
Agency.txt
Gifts.xlsx
Recycle.accdb
Rossi.accdb (cont.)
Bookings.txt
GEM.accdb (cont.)
Overseas.accdb
AC 49
 
Search JabSto ::




Custom Search