|
PACKAGE INCLUDES2 Interactive Training CD-ROMs featuring MOS Proficient and Expert Training with audio animation and software simulations. Step by Step Demonstrations . Hands-on Lab Simulations with detailed instructions. Designed to help users learn at their own pace, allowing them to repeat topics or jump to anywhere in the course. Testing Modules to insure that you fully understand the subject matter.
COURSE INTRODUCTIONAccess 2003 builds on the database capabilities of previous versions of the program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. Topics cover basic database concepts such as planning, forms, and data management, to more advanced concepts including sorting, filtering, reporting, and operating Access on the Web.
Whether you are new to Access, upgrading from a previous release or need to obtain your MOS certification, this course takes you step-by-step through your mastery of Access 2003.
|
COURSE OUTLINE
|
COURSE OUTLINE
MS ACCESS 2003 PROFICIENT TRAINING CDAccess 2003 BasicsIntroducing Access 2003
Office 2003 Overview
Access 2003 Basics
Introducing Access 2003
Office 2003 Overview
Access 2003 Overview
Screen Layout
Title Bar, Menus & Toolbars
The Task Pane
The Database Window
Display Objects & Views
Set Custom Options
What Is A Database?
Creating A New Database
Open An Existing Database
Help in Access 2003
Microsoft Office Online
Type A Question For Help
Access Help Task Pane
Detect And Repair
| Design a DatabasePlan A Database
Relationships
Referential Integrity & Cascade Options
Create A One-To-Many Relationship
Create A Many-To-Many Relationship
Control Data Entry In Tables
Planning Basics
What Is A Table?
Define A Table
Define Fields
Identify Primary Keys
Define Relationships
What Is A Relationship?
One-To-Many Relationships
Many-To-Many Relationships
One-To-One Relationships
Review The Design
Importing Data
Import Data Into A New Table
Exporting Data
Export Data
| Build a DatabaseDatabase Wizards
What Is A Database Wizard?
Use A Database Wizard
Create A Table
Create A Blank Database
Work With Table Data
Enter Data
Edit Data s
Modify A Table
Modify Table Structure
Modify Table Format
Work With Field Properties
Use The Lookup Wizard
Build A Relational Database
Use Table Wizard To Create
Relationships
Create Relationships Manually
| Work with FormsAccess Forms
What is a Form?
What Is A Sub-Form?
Create A Form Automatically
Use AutoForm
Use The Form Wizard
| Sort, Retrieve & Analyze DataSort Data
Sorting Records
Perform An Advanced Sort
Find Data
Find A Record
Use Filters
What Is A Filter?
Apply & Remove Filters
| Use QueriesWhat Is A Query?
Create A Select Query
Add A Calculated Field To A Query
| Work with ReportsAccess Reports
What Is A Report?
Create Reports Automatically
Use AutoReport
Use The Report Wizard
| Integration with Other ApplicationsImport Data Into Access
Importing Data
Import Data Into A New Table
Link To External Data
Linking To External Data
Link To Another Access Database
Table
Work With Linked Tables
Export Data From Access
Exporting Access Data
Export Data
|
COURSE OUTLINE
MS ACCESS 2003 EXPERT TRAINING CDCustomise Access 2003Advanced Features & Customization
Advanced Features In Access 2003
Customizing Access 2003
Customize Menus
The Menu Bar
Creating Custom Menus
Customize Toolbars
Toolbars
Customize A Toolbar
Create A New Toolbar
Set Custom Options
The Options Dialog Box
| Build & Work with DatabasesBuild A Relational Database
Relationships
Referential Integrity & Cascade Options
Create A One-To-Many Relationship
Create A Many-To-Many Relationship
Control Data Entry In Tables
Validation Rules
Create A Validation Rule
Create A Validation Rule Error
Message
Input Masks
Create An Input Mask
Create Lookup Fields
Lookup Fields
Create A Lookup Field
Import & Export Access Data
Importing Data
Import Data Into A New Table
Exporting Data
Export Data
Link To External Data
Linking To External Data
Link To Another Access Database
Table
Work With Linked Tables
Import & Export XML Files
XML Format
Export Access Data As An XML File
Import An XML File Into Access
| Work with FormsCreate Forms In Design View
Creating Forms
Form Controls
Bound & Unbound Controls
Error-Checking In Forms
Create A Form In Design View
Create A Calculated Control
Modify Control Properties
Control Properties
Modify The Format Of A Control
Add Data Validation To A Control
Use Subforms
Subforms
Create A Subform
| Work with Filters and QueriesRetrieve Database Data
Using Filters & Queries
Creating & Saving Queries
Filter Data
Use Advanced Filters
Use Select Queries
Summarizing Data
Create A Select Query
Use Multi-Table Queries
Multi-Table Queries
Create A Multi-Table Query
Use Complex-Criteria Queries
Complex-Criteria Queries
Create A Complex-Criteria Query
Use Parameter Queries
Parameter Queries
Create A Parameter Query
Use Action Queries
Action Queries
Create A Delete Query
Create An Update Query
Create An Append Query
| Work with ReportsCreate Reports in Design View
Creating Reports
Report Controls
Error-Checking In Reports
Report Sections
Create A Report In Design View
Add A Calculated Control To AReport
Modify Reports
Report Element Properties
Modify Control Properties
Modify Section Properties
Modify Report Properties
Sort & Group Report Data
Set Sorting & Grouping Options
Use Subreports
Subreports
Create A Subreport
| Manage an Access DatabaseDatabase Security
Database Security
Create A Database Password
Encoding Databases
Encode A Database
Decode A Database
User-Level Security
Set User Permissions
Database Replication
Replicate A Database
Database Splitter
Splitting Databases
Split A Database
Visual Basic Modules
Using Visual Basic Modules
Create A Visual Basic Module
MDE Files
Optimize A Database
Use Performance Analyzer
Compact A Database
Switchboards & Startup Options
Switchboards
Create A Switchboard
Set Startup Options
| Operate Access on the WebUse Data Access Pages
Data Access Pages
Create A Data Access Page
Modifying A Data Access Page
Use PivotTables & PivotCharts
PivotTables & PivotCharts
Create A Pivot Table In A Data
Access Page
Create A Pivot Chart In A Data
Access Page
|
|