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