Transcript Access Databases

Introduction to a Database
Defining a database
 Database window in Access
 The six items in window: Tables,
Queries Forms, Reports, Macros,
Modules

Database Window
Menu Bar
Toolbar
Database
Window
Object
Buttons
Creating a Table

Using Table Wizard
Table Wizard Screen
Table Wizard
Creating a Table

Using Table Wizard

Designing a table yourself





Field names
Data types
Primary key
Properties
Views--Datasheet or Design
Design View
Primary Key
Field Names
Data Type
Description
Field
Properties
Data Types









Number
Text
Memo
Date/Time
Currency
Yes/No
AutoNumber
OLE
Hyperlink
Properties





Validation
Field
size Rule
Format Text
Validation
Input Mask
Required
Caption
Allow
Zero Length
Default Value
Indexed
Table Design Basics
Include necessary data
 Store data in smallest parts
 Do not use calculated fields

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

Datasheet View
Triangle indicates
data has been
saved to disk
Each column is
a field
Each row is
a record
Current Record
Total Number of Records
Database Form
Label
Text Box
(bound to field)
Command
Buttons
Each page shows
one record
Go To
First Record
Go To Next Record
Go To Last Record
Creating a Form






Controls--objects
Bound control has data source
Unbound control: no data source
Calculated control: expression as data
source
Properties
Form Wizard
Form Design View
Sizing handles
Click and drag to
move Toolbox
Form View
Combo Box
(Drop Down List)
Check box
Option Group
Query Design View
Run Button
Table
Calculated
Field
Query Selection Criteria
2 or more
lines = “Or”:
find items
that satisfy
either
Same line =
“And”: find
items that
satisfy both
Parametric Query
Query Design
Window
Only entries with
fields matching
entry will show
Parameter
[in brackets]
in Criteria Row