Transcript PPT

Exploring Microsoft
Access 2003
Chapter 4- Proficiency:
Relational Databases,
Charts, and the Switchboard
Robert Grauer and Maryann Barber
Officethe
2003Next
Vol 1 2/e
- Grauer and of IT Experts.
Committed toExploring
Shaping
Generation
Barber
1
Multiple-Table Queries

One-to-many relationship

Primary key

Foreign key

Referential integrity
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
2
Multiple Table Query
Foreign key in
Clients table
Primary key in
Consultants table
Relationship between
tables (one to many)
Each field and
table to display
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
3
Total Queries

Summary functions

Total row

Group By

Count function

Sum function
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
4
Total Query
View Menu  Totals
Click drop down
arrow in Total row
Select Count from
drop-down menu
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
5
Chart Wizard (1 of 6)
Report Design View
Insert  Chart
Choose the Query
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
6
Chart Wizard (2 of 6)
Select the fields to be included in the chart
Inserts the
selected field
Removes only the
selected field
Inserts all fields
Removes all fields
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
7
Chart Wizard (3 of 6)
Select the chart type
Description of
The currently
Selected chart
type
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
8
Chart Wizard (4 of 6)
Preview the chart
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
9
Chart Wizard (5 of 6)
Title the chart
Legend display
option
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
10
Chart Wizard (6 of 6)
The completed chart
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
11
The User Interface

Switchboard

Switchboard Manager

Switchboard Items table
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
12
Switchboard Manager
Graphic
About
Investments form
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
13
Other Access Utilities
Tools  Database Utilities

Convert Database command


Changes the file format to an earlier version of Access
Compact and Repair Database command

Compact: Reduces file size

Repair: Automatically run if unable to open an Access
database
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
14
Compact the Database
Select the
Database to
compact
Click Compact
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
15