|
Microsoft Access™ 2002
Master Class
Learn to use this database package.
Supplied with 12 databases for instruction and practice.
1. Estate Agent
details of 130 properties
2. Food
208 records showing Calories, Vitamins, Fat etc.
3. Holidays
brochure details of 119 holidays
4. Weights
over 800 exercise details
5. Country
Capital, Life expectancy, Imports etc
6. Triathlon
Dover triathlon results - 193 entrants
7. Mountains
details of 38 mountains
8. Smaller databases
Books, Places, Rivers, Friends, Lakes
The topics below are all covered in some depth - but no previous experience is assumed
|
Records
|
Fields
|
Types of field
|
Navigation
|
Key
|
|
Sorting
|
Find
|
Selection
|
Updating
|
Print
|
|
Filter
|
Greater than
|
Less than
|
And
|
Or
|
|
Validation
|
Headers
|
Footers
|
Controls
|
Properties
|
|
Labels
|
Text boxes
|
Tab order
|
Combo boxes
|
Command buttons
|
|
Formulae
|
Pictures
|
Data Lookup
|
Import
|
Macros
|
|
Autoexec
|
Format
|
Address Labels
|
Reports
|
Grouping
|
|
Counting
|
Sum
|
Average
|
User input
|
Relationships
|
|
Build database
|
Build tables
|
Build forms
|
Write reports
|
Write queries
|
Full explanation of all topics is supplied in a Word™ document of 135 pages.
MANY worked examples
Exercises (and answers - WITH explanations) for practice.
11 pictures are supplied for use in various exercises.
Find how easy it is to get what appears to be very complicated outputs.
Designed as a self learning package
The material that is supplied, together with the topics covered,
make this an interesting package
|
