Course Objectives:
The aim of this course is to provide participants with an overview of what
can be achieved with Microsoft Access. The course will provide participants with
a basic understanding of Database Design. Participants will be provided with the
skills required to build a simple database, including tables, relationships,
basic forms, basic select
queries, filter a database and basic reporting.
All Access courses are based
on the Microsoft Certified Application Specialist exams, if you complete Stage One, Two and
Three you should consider sitting the Microsoft Certified Application
Specialist exam.
If you require training in a
version of Access other than Access 2002, 2003 or 2007 please
contact Catherine.
Who Should Attend: Participants should either be newcomers, those making the transition from an
older version, or those who are self taught in Access, and wanting to "fill
in the gaps" and learn faster and smarter ways of working with Access. A knowledge of Windows is required, and attendees must be
competent with the keyboard and mouse.
Course Outline/Table
of Contents:
MODULE 1. INTRODUCING ACCESS
WHAT IS A DATABASE?
WHAT IS ACCESS?
STARTING MICROSOFT ACCESS
CREATE A DATABASE USING A TEMPLATE
MOVING AROUND A DATABASE
OPENING TABLES
FORMS
OPENING REPORTS
MODULE 2. CREATING A BLANK DATABASE
PLANNING YOUR DATABASE
Planning Questions
Designing the Database
CREATING A CUSTOM TABLE IN DESIGN VIEW
ADDING FIELD NAMES
DATA TYPES
FIELD DESCRIPTIONS
OPEN AN EXISTING TABLE IN DESIGN VIEW
FIELD PROPERTIES
VIEW THE TABLE IN DATASHEET VIEW
VIEW THE TABLE IN DESIGN VIEW
THE FIELD SIZE PROPERTY
THE FORMAT PROPERTY
THE CAPTION PROPERTY
THE DEFAULT VALUE PROPERTY
THE VALIDATION RULE AND VALIDATION TEXT PROPERTIES
THE INPUT MASK PROPERTY
THE REQUIRED PROPERTY
THE INDEXED PROPERTY
SETTING A PRIMARY KEY
MODULE 3. TABLE DATA ENTRY
MOVING AROUND A TABLE
INSERTING, DELETING AND MODIFYING DATA IN A TABLE
THE LOOKUP WIZARD
DATA ENTRY
CHANGING THE LOOK OF THE TABLE IN DATASHEET VIEW
Change the width of a column in a datasheet
Hide and Unhide a column
Move a column
Changing the Font
Gridlines
Alternate Fill/Back Colour
Total Row
Saving the Layout
MODULE 4. ESTABLISHING TABLE RELATIONSHIPS
UNDERSTANDING RELATIONSHIPS, TYPES OF RELATIONSHIPS AND PREREQUISITE TO
DEFINING RELATIONSHIPS
ENFORCED REFERENTIAL INTEGRITY
USING CASCADE UPDATE AND CASCADE DELETE
PRINT RELATIONSHIPS
MODULE 5. SELECT QUERIES
CREATING A QUERY IN DESIGN VIEW
SAVING, CLOSING AND RUNNING QUERIES
ADJUSTING QUERIES
Adding, Modifying, Deleting and Changing the Order of Fields
SORTING FIELDS
SHOWING AND HIDING FIELDS
APPLYING CRITERIA
Using Comparison Operators
USING WILDCARD CHARACTERS
Using the AND Operator
USING THE OR OPERATOR
USING AND AND OR OPERATORS IN THE SAME FIELD
QUERYING MORE THAN ONE TABLE
MODULE 6. FINDING AND REPLACING DATA
MODULE 7. SORTING DATA
MODULE 8. FILTERING DATA
MODULE 9. CREATING FORMS
WHAT IS A FORM?
CREATING A FORM
Creating a Form using the Form Tool
Creating a Form using the Form Wizard
MODULE 10. USING FORMS
MOVING WITHIN AND BETWEEN RECORDS
ENTERING, MODIFYING, OVERWRITING AND DELETING DATA
SORTING DATA
FILTERING DATA
PRINTING FORMS
MODULE 11. CREATING REPORTS
WHAT IS A REPORT?
CREATING A REPORT USING THE REPORT TOOL
CREATING A REPORT USING THE REPORT WIZARD
CREATING MAILING LABELS
CONCLUSION: DESIGNING A DATABASE
Duration: Three or more
people a full 6 hour course. One or two people will need 2 or 3 two hour
sessions.
Upon completion of Stage One,
Two
and Three, the participant should consider sitting the Microsoft Certified
Application Specialist Access Exam.
