Microsoft Access† O365/2019 - Level 2 & 3 / Adv Course Details:

In this Microsoft Access course, students will delve deeper into the program by studying different topics such as how to manage data and data entry; create forms, and dialog boxes; split databases; and much more.

    No classes are currenty scheduled for this course.

    Call (919) 283-1674 to get a class scheduled online or in your area!

Advanced Table Tasks

  • Inserting Application Parts
  • Using the Table Analyzer Wizard
  • Creating Validation Rules
  • Configuring Validation Messages
  • Creating Lookup Fields
  • Creating Value Lists
  • Marking Fields as Required
  • Marking a Field for Indexing
  • Creating Input Masks

Advanced Form Tasks

  • Limiting User Access to a Form
  • Adding Calculated fields in a Form
  • Using the expression Builder
  • Creating Checkboxes and Command Buttons
  • Building Command Button Events
  • Creating Event Procedures
  • Using Hyperlinks in a Form
  • Adding Links to Other Database Objects
  • Inserting a Mailto Link in a Form
  • Adding a Browser Control to a Form
  • Exporting Your Form to XML
  • Exporting a Form as a Word Document
  • Exporting a Form as HTML
  • Sending a Form as an E-mail Attachment
  • Exporting a Form to Other Formats

Creating Subforms

  • Creating Subforms
  • Using Subforms
  • Linking Subforms with Parent Forms
  • Formatting a Subform within a Main Form

Creating Split Forms

  • Creating a Split Form
  • Splitting an Existing Form
  • Using a Split Form
  • Fixing the Form Separator

Creating Navigation Forms

  • Creating a Navigation Form
  • Adding Tabs to a Navigation Form
  • Creating a Tab Hierarchy
  • Displaying the Navigation Form when the Database Opens

Creating Advanced Queries

  • Creating and Using Parameter Queries
  • Creating and Using Crosstab Queries
  • Creating and Using Make-Table Queries
  • Creating and Using Multiple Table Queries
  • Creating and Using Append Queries
  • Creating and Using Delete Queries
  • Creating and Using Update Queries

Using Subqueries

  • What is a Subquery?
  • Creating a Subquery
  • Subqueries with Aggregate Functions and Nested Subqueries
  • Using the IN Keyword with Subqueries

Pivoting Data

  • Creating a PivotTable
  • Creating a PivotChart
  • Using PivotTables and PivotCharts

Creating Advanced Report

  • Adding Calculated Fields
  • Adding Concatenated Fields
  • Inserting Sub Reports
  • Exporting Reports in Different Formats

Splitting the Database

  • Backing Up the Database
  • Splitting the Database

Add-Ons to Access

  • COM Add-ins
  • Digital Signatures
  • Smart Tags
  • Managing Your Database
  • Customizing Access

SQL and Microsoft Access

  • An Introduction to SQL
  • Understanding SQL
  • Using the Select Statement
  • Using Subqueries
  • Using SQL Joins

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.

Students will learn,

  • Advanced Table Tasks
  • Advanced Form Tasks
  • Creating Subforms
  • Creating Split Forms
  • Creating Navigation Forms
  • Creating Advanced Queries
  • Using Subqueries
  • Pivoting Data
  • Creating Advanced Report
  • Splitting the Database
  • Add-Ons to Access
  • SQL and Microsoft Access

The prerequisites for this course are Access Level 1 or a solid working knowledge of Access or other database applications.

The prerequisites for this course are Access Level 1 or a solid working knowledge of Access or other database applications.

Ready to Jumpstart Your IT Career?

CONTACT US NOW!