RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
Microsoft Office Access - Level 1, 2, 3 and 4
Software Version Microsoft Office Access 2003 and 2007
Course Duration 1 Day for each level and 4 Days for the Complete Course
Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
Course Overview Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access relational database application.
Intended Audience for this course This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access can also take this course. This course is also designed for Office Staff, End Users, Office Secretaries, Analysts, IT management and Staff, Business Analysts, Functional Implementers, Project Managers and also those who want to use this Software for managing and organizing their day to day business.
Course Topics
Level 1
Lesson 1: An Overview of Access 2003

    Topic 1A: Relational Databases
    Topic 1B: The Access Environment
    Topic 1C: The Database Environment
    Topic 1D: Examine an Access Table

Lesson 2: Managing Data

    Topic 2A: Examine an Access Form
    Topic 2B: Add and Delete Records
    Topic 2C: Sort Records
    Topic 2D: Display Record Sets
    Topic 2E: Update Records
    Topic 2F: Run a Report

Lesson 3: Establishing Table Relationships

    Topic 3A: Identify Table Relationships
    Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
    Topic 3C: Working with Subdatasheets

Lesson 4: Querying the Database

    Topic 4A: The Select Query
    Topic 4B: Add Criteria to a Query
    Topic 4C: Add a Calculated Field to a Query
    Topic 4D: Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

    Topic 5A: Form Design Guidelines
    Topic 5B: Create AutoForms
    Topic 5C: Create a Form Using the Form Wizard
    Topic 5D: Modify the Design of a Form

Lesson 6: Producing Reports

    Topic 6A: Create an AutoReport
    Topic 6B: Create a Report by Using the Wizard
    Topic 6C: Examine a Report in Design View
    Topic 6D: Add a Calculated Field to a Report
    Topic 6E: Modify the Format Properties of a Control
    Topic 6F: AutoFormat a Report
    Topic 6G: Adjust the Width of a Report

Level 2
Lesson 1: Planning a Database

    Topic 1A: Design a Relational Database
    Topic 1B: Identify Database Purpose
    Topic 1C: Review Existing Data
    Topic 1D: Determine Fields
    Topic 1E: Group Fields into Tables
    Topic 1F: Normalize the Data
    Topic 1G: Designate Primary and Foreign Keys

Lesson 2: Building the Structure of a Database

    Topic 2A: Create a New Database
    Topic 2B: Create a Table Using a Wizard
    Topic 2C: Create Tables in Design View
    Topic 2D: Create Relationships between Tables

Lesson 3: Controlling Data Entry

    Topic 3A: Restrict Data Entry with Field Properties
    Topic 3B: Create an Input Mask
    Topic 3C: Create a Lookup Field

Lesson 4: Finding and Joining Data

    Topic 4A: Find Data with Filters
    Topic 4B: Create Query Joins
    Topic 4C: Join Unrelated Tables
    Topic 4D: Relate Data Within a Table

Lesson 5: Creating Flexible Queries

    Topic 5A: Set Select Query Properties
    Topic 5B: Create Parameter Queries
    Topic 5C: Create Action Queries

Lesson 6: Improving Your Forms

    Topic 6A: Enhance the Appearance of a Form
    Topic 6B: Restrict Data Entry in Forms
    Topic 6C: Add Command Buttons
    Topic 6D: Create a Subform

Lesson 7: Customizing Your Reports

    Topic 7A: Organize Report Information
    Topic 7B: Set Report Control Properties
    Topic 7C: Control Report Pagination
    Topic 7D: Summarize Information
    Topic 7E: Add a Subreport to an Existing Report
    Topic 7F: Create Mailing Labels

Lesson 8: Expanding the Reach of Your Data

    Topic 8A: Publish Access Data as a Word Document
    Topic 8B: Analyze Access Data in Excel
    Topic 8C: Export Data to a Text File
    Topic 8D: Merge Access Data with a Word Document

Level 3
Lesson 1: Structuring Existing Data

    Topic 1A: Import Data
    Topic 1B: Analyze Tables
    Topic 1C: Create a Junction Table
    Topic 1D: Improve Table Structure

Lesson 2: Writing Advanced Queries

    Topic 2A: Create Unmatched and Duplicates Queries
    Topic 2B: Group and Summarize Records Using the Criteria Field
    Topic 2C: Summarize Data with a Crosstab Query
    Topic 2D: Create a PivotTable and a PivotChart
    Topic 2E: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

    Topic 3A: Create a Macro
    Topic 3B: Attach a Macro to a Command Button
    Topic 3C: Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros

    Topic 4A: Require Data Entry with a Macro
    Topic 4B: Display a Message Box with a Macro
    Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Effective

    Topic 5A: Change the Display of Data Conditionally
    Topic 5B: Display a Calendar on a Form
    Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

    Topic 6A: Cancel Printing of a Blank Report
    Topic 6B: Include a Chart in a Report
    Topic 6C: Arrange Data in Columns
    Topic 6D: Create a Report Snapshot

Lesson 7: Maintaining an Access Database

    Topic 7A: Link Tables to External Data Sources
    Topic 7B: Back Up a Database
    Topic 7C: Compact and Repair a Database
    Topic 7D: Protect a Database with a Password
    Topic 7E: Determine Object Dependency
    Topic 7F: Document a Database
    Topic 7G: Analyze the Performance of a Database

Level 4
Lesson 1: Making Your Data Available on the Web

    Topic 1A: Create a Data Access Page by Using the Wizard
    Topic 1B: Improve the Presentation of the Data Access Page
    Topic 1C: Viewing Data Access Pages with the Browser
    Topic 1D: Edit Data Using the Data Access Page
    Topic 1E: Group Records in the Data Access Page

Lesson 2: Developing a Data Access Page in Design View

    Topic 2A: Create a Data Access Page in Design View
    Topic 2B: Incorporate a ComboBox in the Data Access Page
    Topic 2C: Test the New Record Function of the Data Access Page
    Topic 2D: Develop a PivotTable with the Office PivotTable Tool
    Topic 2E: Develop a PivotChart

Lesson 3: Integrating Access into Your Business

    Topic 3A: Import XML Data into an Access Database
    Topic 3B: Export Access Data to XML Format
    Topic 3C: Share Data with Other Office Applications

Lesson 4: Automating a Business Process with VBA

    Topic 4A: Create a Standard Module
    Topic 4B: Develop Code
    Topic 4C: Call a Procedure from a Form
    Topic 4D: Run the Procedure

Lesson 5: Creating a Switchboard and Setting the Startup Options

    Topic 5A: Create a Database Switchboard
    Topic 5B: Modify a Database Switchboard
    Topic 5C: Set the Startup Options
    Topic 5D: Modify the Startup Options

Lesson 6: Distributing and Securing the Database

    Topic 6A: Split a Database
    Topic 6B: Implement Security
    Topic 6C: Set Passwords
    Topic 6D: Encode and Decode a Database
    Topic 6E: Convert an Access Database to an MDE File

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Follow us on .....
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.