|
|
|
|
Title: |
Access 2003 - ML |
|
Delivery Method: |
Mentored Learning |
|
Duration: |
4 Sessions |
|
Overview: |
Relational databases are a critical component of the infrastructure that allows modern society to easily store, index and share information. In this Access 2003 course, you’ll learn basic and advanced capabilities of this popular database tool from Microsoft. Our expert instructors will soon have you building databases, querying data, designing forms and generating reports. At the conclusion of this course you’ll understand how to use Access 2003 to organize, retrieve, and share information. |
| Who
Should Attend: |
Persons with a basic understanding of Microsoft Windows who need to learn how to use Microsoft Office Access 2003. |
| Pre-requisite(s): |
Windows XP |
| CPE
Information: |
CPE Credits:
0
hours
Course Level: Basic
Instructional Method: Group-live
Additional CPE Information |
|
Outline: |
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 Create & Open A Database
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 DATABASE
Plan A Database 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
Refining The Design
Queries, Forms & Reports
BUILD A DATABASE
Database 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 FORMS
Access Forms
What Is A Form? What Is A Sub-Form?
Create A Form Automatically
Use AutoForm
Use The Form Wizard
SORT, RETRIEVE & ANALYZE DATA
Sort Data
Sorting Records
Perform An Advanced Sort
Find Data
Find A Record
Use Filters
What Is A Filter?
Apply & Remove Filters
USE QUERIES
What Is A Query? Create A Select Query
Add A Calculated Field To A Query
WORK WITH REPORTS
Access Reports
What Is A Report?
Create Reports Automatically
Use AutoReport
Use The Report Wizard
INTEGRATION WITH OTHER
Applications
Import 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
CUSTOMIZE ACCESS 2003
Advanced 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 DATABASES
Build 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 FORMS
Create 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 & QUERIES
Retrieve 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 REPORTS
Create 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 A Report
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 DATABASE
Database 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 WEB
Use 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 |
|
