MICROSOFT ACCESS – ADVANCE

MICROSOFT ACCESS – ADVANCE

Summary

Location

Location

Malaysia

Duration

Duration

2 Days
Format

Format

Public Class

Public Class

Course Details

Course: ACA-2; Duration: 2 Days; Instructor-led

Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know, understand, and want to further enhance their knowledge and practical uses of Microsoft Access

Prerequisites

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to compact a Database
  • Able to repair a Database
  • Able to link to an Excel Spreadsheet
  • Able to use Input Masks to control Table data entry
  • Able to create a Query
  • Able to create a Multiple Table Query

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

Upon completion of this program, participants should be able to:

  • Maintain Referential Integrity
  • Create Table Relationships
  • Creating a Switchboard
  • Understanding Crosstab Queries
  • Using Parameter Queries
  • Creating a PivotTable

Outlines

Lesson 1.1: Customizing Menus and Toolbars

  • Customizing Menus
  • Creating Menus
  • Showing and Hiding Toolbars
  • Customizing Toolbars
  • Creating Toolbars

Lesson 1.2: Setting Access Options, Part 1

  • Setting General and View Options
  • Setting Editing and Keyboard Options
  • Setting Datasheet, Form and Report Options
  • Setting Page and Tables / Queries Options
  • Setting Error Checking Options
  • Setting Advanced Options

Lesson 1.3: Setting Access Options, Part 2

  • Setting International Options
  • Setting Spelling Options
  • Setting Autocorrect Options
  • Setting Start-Up Options
  • Setting Macro Security Options

Lesson 1.4: Creating Macros

  • Using the Macro Design Toolbar
  • Creating a Macro
  • Running a Macro
  • About Macro Groups

Lesson 1.5: Advanced Macro Uses  

  • Editing a Macro with the Visual Basic Editor
  • Assigning a Macro to a Keystroke
  • Assigning a Macro to a Toolbar
  • Viewing and Printing Macro Definitions

Lesson 2.1: Switchboards    

  • Using A Switchboard
  • Using the Switchboard Manager
  • Creating a Switchboard
  • Editing a Switchboard
  • Deleting a Switchboard

Lesson 2.2: Creating Data Access Pages

  • Using the Data Access Page Wizard
  • Using Design View to create a Data Access Page
  • Using an existing Html Page

Lesson 2.3: Modifying Data Access Pages

  • Adding a Theme
  • Adding Text and Controls
  • Formatting Text and Controls
  • Aligning and Sizing Content
  • Adding Images

Lesson 2.4: Using Data Access Pages         

  • Basics of Using Data Access Pages
  • Viewing Data Entered via a Data Access Page
  • Protecting Data

Lesson 3.1: Table Relationships      

  • Normalizing your Data
  • Establishing Referential Integrity
  • Using Cascade Update and Cascade Delete
  • Setting Fields for Indexing
  • Using Indexing

 Lesson 3.2: Using Crosstab Queries

  • Understanding Crosstab Queries
  • Creating a Crosstab Query using the Wizard
  • Creating a Crosstab Query manually

Lesson 3.3: Using Parameter Queries

  • Setting up Parameter Queries
  • Using a Parameter Query

Lesson 3.4: Advanced Reporting Features 

  • Using Autoformat
  • Aligning and Formatting Controls
  • Adding Pictures and Lines

Lesson 4.1: Creating A Pivottable   

  • Creating a Pivottable using the Wizard
  • Continuing where The Wizard left off
  • More about Fields
  • Completing your Pivottab

Lesson 4.2: Using Autoform And Creating Pivotcharts

  • Creating a Pivottable using Autoform
  • Creating a Pivotchart using Autoform
  • About Pivotchart Fields
  • Completing a Pivotchart

Lesson 4.3: Using Pivottable And Pivotcharts

  • Using A Pivottable
  • Using A Pivotchart
  • Editing A Pivottable or Pivotchart
  • Common Pivotchart Editing Features

Turning a Pivottable into a Pivotchart and vice-versa

Trainers

Reviews

Interested In

MICROSOFT ACCESS – ADVANCE

Starting From
RM900
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: MICROSOFT ACCESS - ADVANCE
Duration: 2 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *