|
SEO
training seminars, Perth, WA
|
Microsoft Access 2000 Courseware Training Materials
Foundation Level
Course
Courseware Training Manual
 1. Introduction to database concepts
2. Database design and table creation
-
Design and document your database
-
Define your needs
-
Basic design rules
-
Determine relationships
-
Creating a database
-
Using the table wizard
-
Adding fields using the table wizard
-
Creating a table without a wizard
-
Adding fields to a new table
-
Field properties
-
The input mask property
-
Setting a primary key
-
Adding records to a table datasheet
3. Formatting a table
-
Editing records
-
Selecting records, fields and columns
-
Deleting records and fields
-
Viewing or setting datasheet default values
-
Re-ordering columns and fields
-
Changing column width and row height
-
Hiding and un-hiding columns
-
Freezing columns
-
Formatting datasheet cells
-
Changing datasheet fonts
-
Copying and moving fields and records
-
Printing
4. Relationships
5. Locating and replacing information
-
A simple search
-
Wildcards
-
Finding specific values
-
Find and replace
-
Sorting records
-
What is a filter?
-
Filtering records
6. Creating simple queries
-
Opening an existing query
-
Creating queries
-
The query grid
-
Logical operators in criteria
-
Text in criteria - wildcards
-
Multiple criteria and alternative criteria
-
Calculated fields
-
Summary queries
-
Update queries
-
Append queries
-
Make-table queries
7. Creating calculated fields
8. Introducing forms
-
Basic form layout types
-
Creating a form using autoform
-
Creating a form using the form wizard
-
Different ways of viewing forms
9. More about creating forms
-
Creating forms without using the form wizard
-
The form design view window
-
Manipulating form design
-
Types of control
-
The toolbox
-
Creating a combo box control
-
Changing form properties
-
Using forms with subforms
-
Creating a form with a subform
-
Controlling data input
-
Changing tab order
-
Adding command buttons
-
Adding page breaks
-
Switchboards
10. Reports
-
Opening and viewing existing reports
-
Printing reports
-
Creating a report using autoreports
-
Creating reports using the report wizard
-
Using the label wizard
-
Using the chart wizard
-
Grouping levels in reports
-
Creating a report without a wizard
-
Creating controls
-
Setting properties
Other Microsoft Office 2000 Courseware materials
|
|
Customisable
Courseware