Course Outline
 
Access 2003 Intermediate

Return to Computer Training  

 
SECTION 1:
Advanced File Tasks
Lesson 1.1
Using My Computer Within Access
Navigating With My Computer
Performing Basic Tasks With My Computer
Changing Views With My Computer
Using The My Places Toolbar
Lesson 1.2
Database Management
Repairing A Database
Compacting A Database
Backing Up Your Database
Editing Database Properties
Lesson 1.3
Saving Your Files
Using The Save As Dialog
Using Object Properties
Using Auto Recover
Lesson 1.4
Exporting Files
Exporting To Word
Exporting To Excel
Exporting To Older Versions Of Access
Exporting Vs. Save As
Lesson 1.5
Linking Files
Linking To An Excel Spreadsheet
Linking To Another Database
Creating A Hyperlink
Inserting An OLE Object
 
SECTION 2:
Working With Tables
Lesson 2.1
Customizing Tables
Understanding Field Properties
Adding A Primary Key To A Table
Indexing A Field
Inserting, Deleting And Moving Fields
Importing A Table From Another Source
Lesson 2.2
Formatting Tables
Formatting Text Fields
Adding Field Descriptions
Changing Field Data Types
Adding Captions
Lesson 2.3
Controlling Table Data Entry
Setting A Default Value
Setting A Required Value
Creating And Using Input Masks
Creating And Removing Table Relationships
Lesson 2.4
Managing Table Data Entry
How To Validate Data
Creating A Lookup Field
Modifying A Lookup Field
Creating A Value List
Modifying A Value List
 
SECTION 3:
Working With Forms
Lesson 3.1
Basic Form Controls
Adding A Control
Using The Control Wizard
Cutting, Copying, Pasting And Moving A Control
Formatting A Control
Lesson 3.2
Advanced Form Controls
Modifying A Control's Properties
Changing A Control's Data Source
Changing A Control's Default Value
Creating A Calculated Control
Using Form Properties
Lesson 3.3
Formatting A Form
Formatting Gridlines