|
Course ID: 5355
| Course Duration: 2 Days
|
|
Course Dates:
|
| |
|
| |
Access 2003 - Level 1 Training Class
Course ID: 5355
|
|
| |
|
|
| |
|
|
| |
Access 2003 - Level 1 Training Seminar
In this course, you will be introduced to the concept of the relational database and the Microsoft Office Access 2003 relational database application, and information management tools. Also, you will learn how to design and create a new Access database.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
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
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Windows XP (New Version) - Level 1 Windows XP (New Version) - Level 2
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Access 2003 - Level 1 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5355
| Course Duration: 2 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Business Skills courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|