| |Microsoft Access 2003 - Level 1
| |
ID: SAMSA0 | Course Length: 2 |  |
|
| | |
Module 0: Exploring Access |
| | | - Starting Access
- Exiting Access
- Opening An Existing Database
- Using Menu Commands
- Displaying and Hiding Toolbars
- Changing Menu and Toolbar Options
- Using Database Objects
- Using the Database Window
- Opening a Database Object
- Using the Task Pane
|
 |
| | |
Module 1: Working With The Office Assistant |
| | | - Using the Office Assistant
- Finding An Answer
- Changing Office Assistant Options
- Using Ask a Question
|
|
| | |
Module 2: Creating Tables |
| | | - Creating a New Database
- Using the Table Wizard
- Designing Tables
- Creating a Table in Design View
- Using Design View
- Adding Field Names
- Assigning Data Types
- Adding a Field Description
- Setting a Primary Key
- Saving a New Table
|
|
| | |
Module 3: Working With Tables |
| | | - Using Datasheet View
- Navigating Fields in Tables
- Adding Records
- Moving Through Records
- Selecting Records
- Editing Records
- Saving Records
- Deleting Records
|
|
| | |
Module 4: Editing Tables |
| | | - Changing the Row Height
- Changing the Column Width
- Changing a Font Attribute
- Changing a Cell Effect
- Selecting a Column
- Moving a Column
- Hiding a Column
- Unhiding a Column
- Freezing a Column
|
|
| | |
Module 5: Finding And Filtering Data |
| | | - Sorting Records
- Finding Specific Records
- Finding Records Using Wildcards
- Using Replace
- Using Filter By Selection
- Applying/removing a Filter
- Using Filter Excluding Selection
- Using Filter For
- Using Filter By Form
|
|
| | |
Module 6: Printing Data |
| | | - Printing Table Data
- Changing the Page Setup
- Printing Selected Records
|
|
| | |
Module 7: Creating Relationships |
| | | - Using Related Tables
- Creating a Relationship Between Tables
- Setting Referential Integrity
- Viewing Subdatasheets
- Deleting a Join Line
|
|
| | |
Module 8: Using Simple Queries |
| | | - Using Queries and Recordsets
- Using the Simple Query Wizard
- Creating a Query in Design View
- Opening a Query
- Adding a Table To a Query
- Joining Tables in a Query
- Running a Query
|
|
| | |
Module 9: Modifying Query Results |
| | | - Sorting a Query
- Adding Criteria To a Query
- Hiding a Field in a Query
- Adding a Record Using a Query
- Printing a Query
|
|
| | |
Module 10: Analyzing Tables |
| | | - Analyzing a Table
- Using Relationships in Splits
- Using the Table Analyzer Wizard
|
|
| | |
Module 11: Creating Basic Forms |
| | | - Using Forms
- Using the Form Wizard
- Viewing Records in a Form
- Printing Records in a Form
- Basing a Form On a Query
- Using Autoform
- Adding a Record Using a Form
|
|
| | |
Module 12: Creating Basic Reports |
| | | - Using Reports
- Using the Report Wizard
- Using Print Preview - Reports
- Printing Pages of a Report
- Basing a Report On a Query
- Using Autoreport
|
|
| | |
Module 13: Using Online Help |
| | | - Working with Online Help
- Viewing Screentips
- Using Help Contents
- Using Help Window Features
- Using the Help Answer Wizard
- Using the Help Index
|
|