|
|
| |
|
One Day
Course
This course is suitable
for delegates with
experience of using
Microsoft Access
who wish to extend
their knowledge
and acquire additional
skills and techniques.
Completion of an
Access Level 1 course
or a sound working
knowledge of Level
1 tools and techniques
is recommended.
Delegates will learn
the intermediate
skills necessary
to apply the principles
of effective table
design, work with
calculations, learn
sub form design
and
customise reports.
|
| |
|
Contents: |
|
Database
Design |
|
Relational
databases
Primary
and
foreign
keys
|
|
Using
field
properties
for
protection |
|
|
Input
masks
Validation
rule
and
validation
text
Lookups |
|
|
Table
relationships |
|
|
Relationship
types
Creating
and
editing
relationships
Using
lookups
for
referential
integrity |
|
Queries |
|
Multi-table
queries
Calculated
fields
The
Expression
Builder
Calculating
summary
information
Cross
tab
queries
|
|
Register your interest |
|
Back
to course
list |
|
|
|
|
|
Forms
|
|
Form
sections
Using
form
controls
Control
properties
Multiple
table
forms
|
|
Reports
|
|
Using
Report
Wizards
Report
sections
Report
controls
Report
control
layout
|
|
Access
Tools |
|
Backing
up and
restoring
a database
Compacting
and
repairing
a database
|
|
|
|
|
|
|
|
|
|
(BCT),
bct.gb, birmingham commercial
training, birmingham commercial,
BCT, BET, birmingham electrical
training |
