Transcript PowerPoint

Microsoft Access
CS 110
Fall 2005
Learning to use Access



Terms describing database
Database views
Operations on the database
Terms





Field: a ‘fact’ or cell of the database
Record: a set of fields
Table: a set
of records
Database: a
set of tables
Relational DB:
relationships
between DBs
Terms

Primary key: the field (or
combination of fields) that makes
every record in a table unique
• Not required
• Only one per
table
Terms

Query: a request for specific
information contained within a
database
• Results may be a table
• Results may add/modify records
• Results may reorder records
Terms

Filter: a lightweight query
• Selectively hide parts of a table
according to preferences
Terms

Referential
Integrity
• Tables in a
database must be
consistent

If a relationship uses
a field to bind one
table to another, the
values of the fields
in the two tables
must be consistent
Name
State
Steve
New York
Sally
California
John
Massachusetts
State
Bird
California
Quail
Massachusetts
Chikadee
New York
Bluebird
Views

Multiple ways to interact with DB
Views

Form: a means to enter a record
Views

Report: the prettified results of a
query
Operations (bookstore)

View tables
• Add/delete record



Search in tables
Data input with forms
Run query
Operations (employees)




Filters
Moving fields around
Sorting
View report
Operations (lookahead)




Create relationships
Demonstrate referential integrity
View tables with relationships
Change contents of tables
Operations (test)

Create database from data files