|
Training
Materials for:
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint XP
Microsoft Access
Internet
Explorer
Outlook
Expression Web
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Access 2000 Courseware Training Materials
Foundation Level
Course
Courseware Training Manual
1. Introduction to database concepts
- What is a database?
- Tables and relationships
- The Access application window
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
- Defining relationships
- Opening the relationships window
- Adding tables to the relationships window
- Making relationships
- Referential integrity
- Editing 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
- Creating calculated fields
- Using the expression builder
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
|
