Transcript Access 97 IM Chapter 1 Slides

Exploring
Microsoft
Access 97
Chapter 1
Introduction to
Microsoft Access:
What Is A Database?
Office graphic copyright by Microsoft Corp.
Objectives
(1 of 2)
 Define field, record, table
and database
 Start Access, describe
windows and objects
 Add, edit and delete
records
 Describe record selector
Exploring
Access 97
Chapter 1
2
Objectives
(2 of 2)
 Explain importance of data
validation
 Describe a relational
database, distinguish
between one-to-many and
many-to-many
Exploring
Access 97
Chapter 1
3
Overview
 Every organization uses
data
 Introduction to database
management
 Basic operations to
maintain a database
 Introduction to Access
 Database power with
multiple tables
Exploring
Access 97
Chapter 1
4
Introduction to a
Database
 Defining a database
 The database window in
Access
 The six items in the
window: Tables, Queries
Forms, Reports, Macros,
Modules
Exploring
Access 97
Chapter 1
5
Access 97 Database
Window
Exploring
Access 97
Chapter 1
6
Tables
 Design view used to create
fields
 Datasheet view used to
add, edit or delete records
 Each column represents a
field
 Records are recorded in
rows
Exploring
Access 97
Chapter 1
7
Tables
 Record selector symbol
next to a current record
shows its status
 Triangle indicates saved to
disk
 Pencil indicates you are
working on it
 Asterisk appears next to
last the blank record in
table
Exploring
Access 97
Chapter 1
8
Tables
 Insertion point (a flashing
vertical bar appears at the
point where text is entered
 Primary key is the unique
identifier for each record
 Access automatically saves
any changes in a current
record as soon as you move
to the next record
Exploring
Access 97
Chapter 1
9
Access 97 Table
View
Exploring
Access 97
Chapter 1
10
Introduction to
Microsoft Access
Hands-On Exercise 1
 Welcome to Windows 95
 Obtain the Practice Files
 Start Microsoft Access
 Open the Books Table
 Moving within a Table
 Add a Record
 Add a Second Record
 Print the Table
 Exit Access
Exploring
Access 97
Chapter 1
11
Maintaining a
Database
 Replace command
 Find command
 GIGO (Garbage In,
Garbage Out)
 Data Validation
 Delete record
 Add record
 Undo command
 Office Assistant
Exploring
Access 97
Chapter 1
12
Maintaining the
Database
Hands-On Exercise 2
 Open the Bookstore Database
 The Find Command
 The Undo Command
 The Delete Command
 Data Validation
 Open the Books Form
Exploring
Access 97
Chapter 1
13
Maintaining the
Database
Exercise 2 continued
 The Replace Command
 Run a Query
 Print a Report
 Office Assistant
 Exit Access
Exploring
Access 97
Chapter 1
14
Relational Database
 A relational database uses
multiple tables
 A one-to-many table
example is when one
publisher owns many
books
 A many-to-many example
is when an order can
specify many books and
one book may appear in
many orders
Exploring
Access 97
Chapter 1
15
Chapter 1 Summary
(1 of 2)
 Database consists of multiple,
related tables
 Access database has 6 object
types
– Tables, Forms, Queries,
Reports, Macros, and
Modules
Exploring
Access 97
Chapter 1
16
Chapter 1 Summary
(2 of 2)
 Tables displayed in Design
view or Datasheet view
 Record Selector Symbol for
record status
 Data validation is critical
Exploring
Access 97
Chapter 1
17
Practice with Access
1. Modify Bookstore
database
2. Employee database
3. United States database
4. Filtering and Sorting
5. Using Office Assistant
Exploring
Access 97
Chapter 1
18
Case Studies
Planning for Disaster
The Common User
Interface
Garbage In, Garbage Out
The Database Consultant
Microsoft Online
Exploring
Access 97
Chapter 1
19