 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2000 Introduction
Course Aims
MS Access 2000 is the popular database from Microsoft designed specifically for a graphical environment. This course is designed to give readers an understanding of some of the major features and functions within Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given. |
Assumed Knowledge
A working knowledge of PCs and Windows 95/98/NT is assumed, gained from the workplace or by prior attendance on an "MS Windows 95/98/NT User Introduction" course. |
Course Audience
New, recent or intending users of MS Access 2000 who have little or no existing database knowledge. |
|
Table of Contents
|
Introduction to Access 2000
|
Designing an Access database
|
|
Extracting information from a database
|
|
|
|
Getting started with Access 2000
|
Access 2000 opening screen
|
|
|
|
Getting assistance with Access 2000
|
Using the Office Assistant
|
|
Getting help without the Office Assistant
|
|
Manipulating the help Window
|
|
Help for screen objects - ScreenTips
|
|
|
|
Creating tables and adding records
|
Creating a table using the Table Wizard
|
|
Moving around the datasheet
|
|
Modifying and deleting records
|
|
|
|
Designing table structures
|
Table design - hints and tips
|
|
Format and input mask properties
|
|
Allow zero length property
|
|
|
|
Working with data
|
|
|
Forms
|
Using AutoForm to design forms
|
|
Using Wizards to design forms
|
|
Entering data using a form
|
|
|
|
Simple select queries
|
Restricting records returned by a query
|
|
|
|
Simple reports
|
Printing from datasheet view
|
|
Designing a report Using Report Wizards
|
|
|
|
|
|
