Unleash the Power of Microsoft Access - Advance Course
Are you ready to master the world of data management? Look no further than our ‘Microsoft Access – Advance’ course. In this two-day journey, we dive deep into the realm of Microsoft Access, empowering you to harness its full potential.
Elevate Your Access Skills
Whether you’re a seasoned pro or just starting your Access adventure, our program caters to all skill levels. From customizing menus and toolbars to creating advanced macros, you’ll be amazed at how versatile Microsoft Access can be. Dive into the world of switchboards and data access pages, and explore the magic of crosstab queries, parameter queries, and advanced reporting features. By the end of the course, you’ll be a PivotTable and PivotChart pro, able to effortlessly transform your data into meaningful insights.
Take Control of Your Data
In an era where data is king, mastering Microsoft Access is your key to unlocking new possibilities. Our hands-on, interactive approach ensures that you not only learn the ropes but also become a confident navigator in the world of databases. So, whether you’re a clerk, supervisor, or manager, this course is your ticket to data mastery. Join us for two days, and emerge with the expertise to streamline your data, enhance your decision-making, and propel your career forward.
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
Module 1: Customizing Access
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
Module 2: Advanced Data Tools
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
Module 3: Advanced Queries
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
Module 4: Pivot Tables and Pivot Charts
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
