Microsoft Office Access 2003 Basic
|
|
MS Office |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
Access 2003 |
Portuguese /
English |
Yes |
Yes |
Yes |
Yes |
40 HRS / 5 DAYS
Lesson 1: An Overview of Microsoft Access
• Relational Databases
• The Access Environment
• The Database Environment
• Examine an Access Table
Lesson 2: Managing Data
• Examine an Access Form
• Add and Delete Records
• Sort
Records
• Display Record Sets
• Update Records
• Run a Report
Lesson 3: Establishing Table Relationships
• Identify Table Relationships
• Identify
Primary and Foreign Keys in the Relationships Window
• Working with
Subdatasheets
Lesson 4: Querying the Database
• The Select Query
• Add Criteria
to a Query
• Add a Calculated Field to a Query
• Perform a Calculation on a
Record Grouping
Lesson 5: Designing Forms
• Form Design Guidelines
• Create
AutoForms
• Create a Form Using the Form Wizard
• Modify the Design of a Form
Lesson 6: Producing Reports
• Create an AutoReport
• Create a Report by Using
the Wizard
• Examine a Report in Design View
• Add a Calculated Field to a
Report
• Modify the Format Properties of a Control
• AutoFormat a Report
•
Adjust the Width of a Report
Lesson 7: Planning a Database
• Design a Relational
Database
• Identify Database Purpose
• Review Existing Data
• Determine Fields
•
Group Fields into Tables
• Normalize the Data
• Designate Primary and Foreign
Keys
Lesson 8: Building the Structure of a Database
• Create a New Database
•
Create a Table Using a Wizard
• Create Tables in Design View
• Create
Relationships between Tables
Lesson 9: Controlling Data Entry
• Restrict Data
Entry with Field Properties
• Create an Input Mask
• Create a Lookup Field
Lesson 10: Finding and Joining Data
• Find Data with Filters
• Create Query
Joins
• Join Unrelated Tables
• Relate Data Within a Table
Lesson 11: Creating
Flexible Queries
• Set Select Query Properties
• Create Parameter Queries
•
Create Action Queries
Lesson 12: Improving Your Forms
• Enhance the Appearance
of a Form
• Restrict Data Entry in Forms
• Add Command Buttons
• Create a
Subform
Lesson 13: Customizing Your Reports
• Organize Report Information
• Set
Report Control Properties
• Control Report Pagination
• Summarize Information
•
Add a Subreport to an Existing Report
• Create Mailing Labels
Lesson 14:
Expanding the Reach of Your Data
• Publish Access Data as a Word Document
•
Analyze Access Data in Excel
• Export Data to a Text File
• Merge Access Data
with a Word Document