| Microsoft Access 2000 Day 2 |  |
This course is an introduction to creating simple databases, Forms and Reports using Access 97.Delegates are expected to have general skills in using the computer and mouse.
Level of the course: Second
Duration: 1 day
Hours: 9.30am-4.30pm
A Certificate will be issued to each delegate and will contribute to units of the appropriate NVQ.
Topics Covered:
Creating A Simple Flat-File Database:
Table Design
Record Structure
Field Properties
Indexing
Using field properties to ensure validation
Graphics Fields
Forms:
Creating an Autoform
Creating a New Form with a Form Wizard
Creating a New Form without a Form Wizard
Form Design
Object Properties
Using Existing Data:
Linking to Data
Importing & Exporting Data
class="Bullet_Heading">Creating a Dynaset:
Advanced Filter/Sort
Querying The Data
More Complex Criteria
Reports:
Creating an AutoReport
Creating a Report using the Report Wizard
Creating A New Report without a Report Wizard
Report Design
| View Schedule of Course Dates |