|
More on Single User, Multi User & Network Licences
More on Online Training
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 XP 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 XP.
|
COURSE OUTLINE
|
COURSE OUTLINE
MS ACCESS XP PROFICIENT TRAINING CDAccess XP BasicsDatabase Basics
What Is A Database?
What Is Access XP?
Access XP Capabilities
Database Objects
Planning Basics
Planning Basics
Define Tables
What Is A Table?
Defining Tables
Define Fields
What Is A Field?
Defining 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
Refine The Design
Queries, Forms & Reports
Screen Layout
The Access XP Window
The Database Window
Help In Access XP
Ask A Question
Microsoft Access Help
| Work with FormsForm Basics
What Is A Form?
What Is A Sub-Form?
Create Forms Automatically
Use AutoForm
Use The Form Wizard
Create A Form Manually
Work With Controls
Get Help With Controls
Controls & Data Entry
Types Of Controls
Create A Form Manually
Add A Calculated Control
Modify Form Controls
Control Properties
Modify Control Properties
| Sort, Retrieve and Analyse DataSort Data
Sorting Records
Sort Order
Perform An Advanced Sort
Find Data
Find A Record
Work With Filters
What Is A Filter?
Apply & Remove Filters
Use Queries To Retrieve Data
What Is A Query?
Create A Select Query
Add a Calculated Field To A Query
| Work with ReportsCreate Reports Automatically
What Is A Report?
Use AutoReport
Use The Report Wizard
Create A Report Manually
Report Controls
Work With Controls
Types Of Controls
Create A Report Manually
Add A Calculated Control
| Integrate Access with other ApplicationsImport Data To Access
Importing Data
Into A New Table
Export Data From Access
Exporting Data
Export Data
Publish A Database To The World Wide Web
Access & The World Wide Web
Data Access Pages
Create A Data Access Page
|
COURSE OUTLINE
MS ACCESS XP EXPERT TRAINING CDBuild and Modify DatabasesBuild a Relational Database
Build A Relational Database
Defining Relationships
Establish A One-To-Many Relationship
Control Data Entry In Tables
What Is A Validation Rule?
Use Validation Rules
Set Validation Text
Create An Input Mask
Lookup Fields
Create Lookup Fields
Link Tables Between Access Databases
Link to Information In Another Database
Link Tables
| Work with FormsCreate A Form
Create Form In Design View
Use Subforms
Forms & Subforms
Create A Subform
Switchboard Forms
Create A Switchboard Form
Set Startup Options
| Retrieve DataLocate Information
Locate & Display Information
Filter Data
Use Advanced Filters
Create Queries
Queries That Perform Calculations
Use Aggregate Functions
Specify Multiple Query Criteria
Create A Parameter Query
Modify Data Using Action Queries
Action Queries
Create A Delete Query
Create An Update Query
Create An Append Query
| Work with ReportsCreate Reports
Report Sections
Create A Report In Design View
Modify Reports
Modify Section Properties
Modify Control Properties
Modify Report Properties
Sort & Group Report Data
Use Subreports
Subreports
Create A Subreport
| Operate Access on the WebUse Data Access Pages
Data Access Pages
Create A Data Access Page In Design View
Modify A Data Access Page
PivotTables & PivotCharts
Create PivotTables In A Data Access Page
Create PivotCharts In A Data Access Page
Import & Export Access Data
Export Access Data To An XML Document
Import an XML Document To Access
| Manage an Access DatabaseDatabase Security
Database Permissions
Ass Permissions to A Database
Set & Modify A Password
Encryption & Decryption
Encrypt A Database
Decrypt A Database
Use Database Replication
Replicate A Database
Use Database Splitter
Database Splitter
Split An Access Database
Compact & Repair Databases
Compact A Database
Repair A Database
Create Access Modules
Visual Basic Models
Create An Access Module
Use Visual Basic To Create An Access Module
Distribute Databases As MDE Files
MDE Files
Create An MDE File
|
|