Course Objective: 

In the Microsoft Office Access Training Course, students create and modify new databases and their various objects.

​

They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access™ with other applications.

​

Also, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and also by performing database maintenance. Students will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

​

Level I Course Outline:​

• Exploring the Microsoft® Office Access™ Environment

  1. Examine Database Concepts

  2. Explore the User Interface

  3. Explore the Ribbon

  4. Customize the Access Environment

  5. Obtain Help

  6. Use an Existing Access Database

 

• Designing a Database

1. Describe the Relational Database Design Process

2. Define Database Purpose

3. Review Existing Data

4. Determine Fields

5. Group Fields into Tables

6. Normalize Data

7. Designate Primary and Foreign Keys

8. Determine Table Relationships

 

• Building a Database

  1. Create a New Database

  2. Create a Table

  3. Manage Tables

  4. Create a Table Relationship

  5. Save a Database as a Previous Version

 

• Managing Data in a Table

  1. Modify Table Data

  2. Sort Records

  3. Work with Sub datasheets

 

• Querying a Database

  1. Filter Records

  2. Create a Query

  3. Add Criteria to a Query

  4. Add a Calculated Field to a Query

  5. Perform Calculations on a Record Grouping

 

• Designing Forms

  1. View Data Using an Access Form

  2. Create a Form

  3. Modify the Design of a Form 

​

•  Generating Reports

  1. View an Access Report

  2. Create a Report

  3. Add a Custom Calculated Field to a Report

  4. Format the Controls in a Report

  5. Apply an Auto Format to a Report

  6. Prepare a Report for Print

 

• Controlling Data Entry

  1. Restrict Data Entry Using Field Properties

  2. Establish a Pattern for Entering Field Values

  3. Create a List of Values for a Field

 

• Joining Tables

  1. Create Query Joins

  2. Join Unrelated Tables

  3. Relate Data Within a Table

 

• Creating Flexible Queries

  1. Set Select Query Properties

  2. Create Parameter Queries

  3. Create Action Queries

 

• Improving Forms

  1. Design a Form Layout

  2. Enhance the Appearance of a Form

  3. Restrict Data Entry in Forms

  4. Add a Command Button to a Form

  5. Create a Sub-form

 

• Customizing Reports

  1. Organize Report Information

  2. Format the Report

  3. Set Report Control Properties

  4. Control Report Pagination

  5. Summarize Report Information

  6. Add a Sub report to an Existing Report

  7. Create a Mailing Label Report

 

• Sharing Data Across Applications

  1. Import Data into Access

  2. Export Data

  3. Analyze Access Data in Excel

  4. Export Data to a Text File

  5. Merge Access Data with a Word Document

​

Level II Course Outline:

• Structuring Existing Data

  1. Analyze Tables

  2. Create a Junction Table

  3. Improve Table Structure

 

• Writing Advanced Queries

  1. Create Sub-queries

  2. Create Unmatched and Duplicate Queries

  3. Group and Summarize Records Using Criteria

  4. Summarize Data Using a Cross tab Query

  5. Create a Pivot Table and a Pivot C

  6. Lesson 3: Simplifying Tasks with Macros

  7. Create a Macro

  8. Attach a Macro

  9. Restrict Records Using a Condition

  10. Validate Data Using a Macro

  11. Automate Data Entry Using a Macro

 

• Making Effective Use of Forms

  1. Display a Calendar on a Form

  2. Organize Information with Tab Pages

  3. Display a Summary of Data in a Form

 ​

• Making Reports More Effective

  1. Include a Chart in a Report

  2. Print Data in Columns

  3. Cancel Printing of a Blank Report

  4. Create a Report Snapshot

 

• Maintaining an Access Database

  1. Link Tables to External Data Sources

  2. Manage a Database

  3. Determine Object Dependency

  4. Document a Database

  5. Analyze the Performance of a Database

 

Level III Course Outline:

• Integrating Access into Your Business

  1. Import XML Data into an Access Database

  2. Export Access Data to XML Format

  3. Export Data to the Outlook Address Book

  4. Collect Data Through Email Messages

 

• Automating a Business Process with VBA

  1. Create a Standard Module

  2. Develop Code

  3. Call a Procedure from a Form

  4. Run a Procedure

 

• Managing Switchboards

  1. Create a Database Switchboard

  2. Modify a Database Switchboard

  3. Set the Startup Options

 

• Distributing and Securing Databases

  1. Split a Database

  2. Implement Security

  3. Set Passwords

  4. Convert an Access Database to an ACCDE File

  5. Package a Database with a Digital Signature

 

• Sharing a Database Using a SharePoint Site

  1. Export a Table to a SharePoint List

  2. Import Data from a SharePoint List

  3. Publish a Database to a SharePoint Site

  4. Move a Database to a SharePoint Site

  5. Work Offline

​

Target Audience:

• Students and Fresh Graduates

• Secretary​ and Personal Assistants

• Schools Admintsrators

• Programming Developers

• Accountants

• Administrative Assistant

• Statistics and Survey Officers

• Data Entry

​

For further information and registration, please contact us on:

E-mail:  [email protected]

Phone Number: 00-961-1-340610

WhatsApp Number: 00-961-81-657222 

​

For other related Computer and Programming Training Courses, please click on the below: