Office Access 2003: Core and expert

UWIN Pro Business and Technology Solutions
Scarborough, Onatrio, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Microsoft® Access® 2000 provides powerful tools for managing data. Organizations have to maintain and manage large amounts of information. Most of them use the relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course you will be introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools.

To provide the real-world knowledge and skills you need to:

* Create and Use Forms, Reports, Charts, and Pivot Tables
* Create Data Access Pages
* Customize Forms and Reports
* Perform Database Administration, Networking, and Security Functions
* Link, Import, and Export Tables
* Create Macros
* Use Customizing Tools For Switchboards, Dialog Boxes, Toolbars, and Menus

This course is designed for students who wants to learn Access 2003 program to perform their day-to-day functions, and to understand the advantages of using a relational database program.


You should be familiar with using personal computers and be comfortable with mouse and keyboard. Basic typing skills is essential as well. Some knowledge of database would be helpful.





Module 1: An Overview of Access 2003

Understand Relational Databases
Examine the Access Environment
Open the Database Environment
Examine an Access Table

Module 2: Managing Data

Examine an Access Form
Add and Delete Records
Sort Records
Display Recordsets
Update Records
Run a Report

Module 3: Establishing Table Relationships

Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Work with Subdatasheets

Module 4: Querying the Database

Create a Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping

Module 5: Designing Forms

Examine Form Design Guidelines
Create a Form Using AutoForm
Create a Form Using the Form Wizard
Modify the Design of a Form

Module 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

Module 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

Module 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

Module 9: Controlling Data Entry

Restrict Data Entry with Field Properties
Create an Input Mask
Create a Lookup Field

Module 10: Finding and Joining Data

Find Data with Filters
Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Module 11: Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Module 12: Improving Your Forms

Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add Command Buttons
Create a Subform

Module 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

Module 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

Module 15: Structuring Existing Data

Import Data
Analyze Tables
Create a Junction Table
Improve Table Structure

Module 16: Writing Advanced Queries

Create Unmatched and Duplicates Queries
Group and Summarize Records Using the Criteria Field
Summarize Data with a Crosstab Query
Create a PivotTable and a PivotChart
Display a Graphical Summary on a Form

Module 17: Simplifying Tasks with Macros

Create a Macro
Attach a Macro to a Command Button
Restrict Records Using a Where Condition

Module 18: Adding Interaction and Automation with Macros

Require Data Entry with a Macro
Display a Message Box with a Macro
Automate Data Entry

Module 19: Making Forms More Effective

Change the Display of Data Conditionally
Display a Calendar on a Form
Organize Information with Tab Pages

Module 20: Making Reports More Effective

Cancel Printing of a Blank Report
Include a Chart in a Report
Arrange Data in Columns
Create a Report Snapshot

Module 21: Maintaining an Access Database

Link Tables to External Data Sources
Back Up a Database
Compact and Repair a Database
Protect a Database with a Password
Determine Object Dependency
Document a Database
Analyze the Performance of a Database



...''

Phone:(647) 436-8579

School Address:

705 Progress Avenue, Unit 105
Scarborough, Onatrio
M1H 2X1 Canada



Jobs & Resumes: Scarborough
Houses & Roommates: Scarborough

Computerized Accounting
Simply Accounting
QuickBooks Pro 2008
ACCPAC System Manager & General Ledger
ACCPAC Accounts Payable & Accounts Receivable
ACCPAC Inventory Control, Order Entry and Purchase Order Modules
MS Word
Excel 2003: Core and expert
Office Outlook 2003: Core and expert
Office PowerPoint 2003: Core and expert
Medical Office Assistant

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.