Office 365
Training
Welcome!    Login | Checkout 0 Items | Checkout
ETI Performance Improvement

Software Training

Showing that application who's boss since 1984


Access

Please Select Your Version: 2010 2013 2016

Microsoft Access is all about simplicity, with ready-to-go templates to get you going and powerful tools that stay relevant as your data grows.

Access empowers you to make the most of your information—even if you’re not a database expert. And, through newly added Web databases, Access amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.



Choose Session Level

Level 1
Level 2
Level 3
Level 4
What Level Is Right For Me?
Contact Our Sales Team!
Level 1
Level 2
Level 3
What Level Is Right For Me?
Contact Our Sales Team!
Level 1
Level 2
What Level Is Right For Me?
Contact Our Sales Team!

Topics
Dates & Registration

Access 2010

Level 1

Microsoft Access 2010 is all about simplicity, with ready-to-go templates to get you going and powerful tools that stay relevant as your data grows.

Access 2010 empowers you to make the most of your information—even if you’re not a database expert. And, through newly added Web databases, Access amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.

Access

1 Day

List Price: $265


Register!

Topic 1: Getting Started

  • Starting Out
    • What is Microsoft Access?
    • What’s New in Access 2010?
    • Basic Database Terminology
    • Opening and Closing Access
  • Interface Basics
    • Understanding Backstage View (File Menu)
    • Interface Overview
    • Using the Standard Tabs
    • Using Contextual Tabs
  • Getting Help
    • Opening the Help File
    • Overview of the Help File
    • Online vs. Offline Help
    • Searching for Help
    • Section 1: Review Questions

Topic 2: Creating a Database


  • First Steps
    • Planning a Database
    • Creating a Blank Database
    • Creating a Database from a Template
    • Using Database Objects
  • Creating a Table
    • About Tables
    • Creating a Table
    • Using Design View
    • Formatting Number Fields
    • Formatting Text Fields
    • Adding Field Descriptions
    • Changing Field Data Types
    • Adding Captions
    • Adding a Primary Key
  • Controlling Table Data Entry
    • Setting a Default Value
    • Setting a Required Value
    • Creating and Using Input Masks
    • Entering Data into a Table
  • About Records
    • What is a Record?
    • Navigation Tips
    • Adding Records
    • Editing Records
    • Deleting Records
    • Printing Records
  • Formatting Text
    • Selecting Data
    • Cutting, Copying, and Pasting
    • Using Undo and Redo
    • Checking your Spelling

Topic 3: Relationships


  • Creating and Removing Table Relationships
    • Creating and Removing Table Relationships

Topic 4: Queries


  • Creating and Using Queries
    • What is a Query?
    • Creating a Query with the Wizard
    • Using Design View to Modify a Query
    • About the Query Design Tools Contextual Tab
    • Sorting a Query
    • Filtering a Query
    • Showing and Hiding Fields
  • Doing More with Queries
    • Using AND/OR Operators
    • About IIF Functions
    • Creating Multiple Table Queries
    • Creating a Calculated Field
    • About the Expression Builder
  • Creating Advanced Queries
    • Creating a Parameter Query
    • Using Parameter Queries
    • Using Queries
  • Sorting and Filtering Data
    • Using Find and Replace
    • Sorting Ascending or Descending
    • Toggling Filter
    • Using Selection Sort
    • Using Advanced Sort
  • Viewing Data
    • Using the View Menu
    • Using the View Icons
    • Using the Object Tabs
    • Closing Individual Object Tabs
  • Printing a Database Object
    • Print Commands
    • The Print Dialog Box
    • Using Print Preview
    • Printing vs. Exporting

Access 2010

Level 1

1 Day

List Price: $265

Date Time Classroom or Online Select Session
01/04/2019 8:30 AM Online Add To Cart Add To Cart
01/04/2019 8:30 AM Classroom Add To Cart Add To Cart
02/06/2019 8:30 AM Classroom Add To Cart Add To Cart
02/06/2019 8:30 AM Online Add To Cart Add To Cart

Access 2010

Level 2

Microsoft Access 2010 is all about simplicity, with ready-to-go templates to get you going and powerful tools that stay relevant as your data grows.

Access 2010 empowers you to make the most of your information—even if you’re not a database expert. And, through newly added Web databases, Access amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.

Access

1 Day

List Price: $265


Register!

Topic 1: Advanced File Tasks

  • Using Windows Explorer within Access
    • Navigating with Windows Explorer
    • Performing Basic Tasks with Windows Explorer
    • Changing Views in Windows Explorer
    • Using the Navigation Pane
  • Database Management
    • Compact and Repair a Database
    • Backing up your Database
    • Editing Database Properties
    • Adding or Removing Database Passwords
  • Saving your Files
    • Using the Save As Dialog 
    • An Overview of Additional Database Formats
    • Packaging a Database
    • About AutoRecover
  • Exporting Files
    • Exporting to PDF or XPS
    • Exporting to Microsoft Office Word or Excel
    • Exporting to Other Destinations
    • Using Saved Exports
    • Packaging and Signing Data
    • Exporting to Older Versions of Access
  • Linking Files
    • Linking to a Microsoft Excel Spreadsheet
    • Linking to Another Database
    • Linking to a SharePoint Site
    • Other Types of Linked Documents
    • Creating Hyperlinks

Topic 2: Working with Forms

  • Creating Forms
    • What is a Form?
    • Bound vs Unbound Controls
    • Creating a Basic Form
    • Creating a Form with the Wizard
    • Using Design View to Modify your Form
    • About the Form Design Tools Contextual Tabs
    • Using Forms
  • Basic Form Controls
    • Types of Forms
    • Types of Form Controls
    • Adding a Control
    • Using the Control Wizard
    • Cutting, Copying, Pasting, and Moving a Control
    • Formatting a Control
  • Advanced Form Controls
    • Modifying a Control's Properties
    • Changing a Control's Data Source
    • Changing a Control's Default Value
    • Creating a Calculated Control
    • Using Form Properties
  • Formatting your Form
    • Formatting Gridlines
    • Modifying the Font
    • Adding Logos
    • Changing the Layout
  • Formatting Controls
    • Changing the Color of a Control
    • Using Control Properties
    • Aligning and Sizing Controls
    • Applying Special Effects
  • Using Themes
    • Using Themes
    • Modifying Fonts
    • Modifying Colors
    • Saving Customized Themes

Topic 3: Working with Subforms

  • Using Subforms
    • Creating a Subform
    • Creating a Form and a Subform
    • Modifying a Subform
    • Working with a Subform
    • Synchronizing Subform Data with a Parent Form
    • Displaying a Subform within a Main Form

Topic 4: Working with Reports

  • Creating and Using Reports
    • What is a Report
    • Creating a Report with the Wizard
    • Using Design View to Modify a Report
    • About the Report Design Tools Contextual Tabs
    • Using Reports
  • Organizing Report Data
    • Adding and Removing Fields
    • Using Report Sections
    • Changing Section Properties
    • Grouping and Sorting in a Report
    • Doing More with Grouping and Sorting
    • Using Calculated Controls in a Report
  • Formatting Reports
    • Formatting Gridlines
    • Modifying the Font
    • Adding Logos
    • Changing the Layout
    • Using Themes
  • Common Report Tasks
    • Adding a Photo
    • Adjusting Page Properties
    • Adding Page Numbers
    • Using the Label Wizard
    • Adding Conditional Formatting

Access 2010

Level 2

1 Day

List Price: $265

Date Time Classroom or Online Select Session
01/28/2019 8:30 AM Classroom Add To Cart Add To Cart
01/28/2019 8:30 AM Online Add To Cart Add To Cart
02/25/2019 8:30 AM Online Add To Cart Add To Cart
02/25/2019 8:30 AM Classroom Add To Cart Add To Cart

Access 2010

Level 3

Microsoft Access 2010 is all about simplicity, with ready-to-go templates to get you going and powerful tools that stay relevant as your data grows.

Access 2010 empowers you to make the most of your information—even if you’re not a database expert. And, through newly added Web databases, Access amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.

Access

1 Day

List Price: $265


Register!

Topic 1: Advanced Data Management

  • Referential Integrity
    • Using Relationship View
    • Types of Relationships
    • Establishing Referential Integrity
    • Enforcing Referential Integrity
    • Testing Referential Integrity
  • Table Relationships
    • About Join Lines
    • Normalizing Tables
    • Using the Table Analyzer Wizard
    • Using Cascade Delete and Cascade Update
    • Setting Fields for Indexing
    • Using the Index
  • Modal Dialog Boxes
    • Creating a Modal Dialog Box
    • Adding Controls
    • Setting Properties
    • Formatting your Dialog Box

Topic 2: Advanced Form Tasks

  • Using Subforms
    • Creating a Subform
    • Modifying a Subform
    • Working with a Subform
    • Synchronizing Subform Data with a Parent Form
    • Displaying a Subform within a Main Form
  • Creating a Navigation Form
    • Creating a Navigation Form
    • Adding Tabs to a Navigation Form
    • Creating a Tab Hierarchy
    • Modifying a Navigation Form
    • Displaying the Navigation Form when the Database Opens
  • Advanced Form Tasks
    • Limiting User Access to a Form
    • Creating Checkboxes and Command Buttons
    • Building Command Button Events
    • Creating Event Procedures
  • More Form Tasks
    • Sending a Form as an E-mail Attachment
    • Using Hyperlinks in a Form
    • Adding Links to Other Database Locations
    • Adding a Browser Control to a Form
    • Performing Calculations in a Form

Topic 3: Pivoting Data

  • Creating a PivotTable
    • About PivotTables
    • Creating a PivotTable
    • More about PivotTables
    • Completing your PivotTable
  • Creating a PivotChart
    • About PivotCharts
    • Creating a PivotChart
    • More about PivotChart Fields
    • Completing your PivotChart
  • Using PivotTables
    • Using a PivotTable
    • Working with PivotTable Data
    • Hiding and Showing PivotTable Data
    • Grouping PivotTable Data
    • Editing and Formatting a PivotTable
    • Importing Excel Data
    • Creating a PivotTable with Excel Data
  • Using PivotCharts
    • Modifying a PivotChart
    • Creating a PivotTable and
    • PivotChart form the Same Object
    • Adding Axes Titles and a Legend
    • Changing the Chart Type

Topic 4: Access 2010 Windows Tasks

  • Recovering Access
    • Restoring a Database from a Backup Copy
    • Starting Access on Windows Boot
    • Repairing Access 2010
    • Checking for Updates
  • Splitting Your Database
    • Why Split your Database?
    • Splitting the Database
    • Configuring Access 2010 for a Multi User Database
    • Setting Record Locking Options
  • Using Outlook with Access
    • Importing Contacts from Outlook
    • Linking to an Outlook Folder
    • Collecting Data with an Email Form
    • Managing Replies

Topic 5: Macros and VBA

  • Macro Basics
    • Creating Macros
    • Macros as Event Procedures
    • Program Control with If
    • Then Else Statements
    • Using Macros in Tables
  • More about Macros
    • Embedded Macros
    • Adding Comments to Macros
    • Creating a Submacro
    • Grouping Submacros
    • Handling Macro Errors

Access 2010

Level 3

1 Day

List Price: $265

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Access 2010

Level 4

This course is designed for experienced Access 2010 users who want the learn ActiveX Data Objects, control structures and the basics of VBA programming.

1 Day

List Price: $265


Register!

Topic 1: Visual Basic Editor

  • Objects
  • Object Browser
  • Collections

Topic 2: Programming Basics

  • Working with Data
  • Scope

Topic 3: Control Structures

  • Decision Structures
  • Loop Structures

Topic 4: ActiveX Data Objects

  • Getting Started with ActiveX Data
  • Working with ActiveX Data Objects

Topic 5: VBA Debugging Tools

  • Errors in Code
  • Debugging Techniques
  • Handling Runtime Errors

Access 2010

Level 4

1 Day

List Price: $265

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Access 2013

Level 1

This Level 1 workshop covers the skills that students will need to make the most of Microsoft Access 2013. The course begins with the basics and progresses through several modules which cover databases, tables and records, forms, reports, queries, and much more.

1 Day

List Price: $265


Register!

Topic 1: The Basics

  • Getting Started
  • Signing In
  • Creating a Database
  • Database Terminology
  • Saving a Database
  • Opening a Database
  • Review Questions

Topic 2: Your First Database

  • About Security Warnings
  • About Relationships
  • Searching for Objects
  • Opening Database Objects
  • Changing the Object View
  • Understanding the Types of Views Available
  • Managing Objects
  • Review Questions

Topic 3: Working with Tables and Records

  • Creating a Table
  • Understanding Table Views
  • Adding and Editing Records
  • Searching and Browsing Records
  • Deleting Records
  • Printing Records
  • Review Questions

Topic 4: Formatting Tables

  • Selecting Data
  • Changing Column and Row Width and Height
  • Applying Text Formatting
  • Applying Gridlines
  • Changing Fill Colors
  • Checking Your Spelling
  • Review Questions

Topic 5: Creating Forms

  • Creating a Form from an Object
  • Creating a Form with the Wizard
  • Creating a Form from Scratch
  • Understanding Form Views
  • Using a Form
  • Review Questions

Topic 6: Formatting Forms

  • Understanding Bound and Unbound Controls
  • Changing the Theme
  • Using the Format Painter
  • Adding Fields
  • Adding Controls
  • Adding Images and Logos
  • Review Questions

Topic 7: Creating Reports

  • Creating a Report from an Object
  • Creating a Report with the Wizard
  • Creating a Report from Scratch
  • Understanding Report Views
  • Printing Reports
  • Review Questions

Topic 8: Formatting Reports

  • Changing the Theme
  • Using the Format Painter
  • Grouping and Sorting Data
  • Adding Controls
  • Adding Images and Logos
  • Adding Page Numbers, Headers, and Footers
  • Review Questions

Topic 9: Creating Basic Queries

  • Types of Queries
  • Creating a Query with the Wizard
  • Running a Query
  • Understanding Query Views
  • Sorting and Filtering a Query
  • Review Questions

Access 2013

Level 1

1 Day

List Price: $265

Date Time Classroom or Online Select Session
01/04/2019 8:30 AM Classroom Add To Cart Add To Cart
01/04/2019 8:30 AM Online Add To Cart Add To Cart
02/06/2019 8:30 AM Classroom Add To Cart Add To Cart
02/06/2019 8:30 AM Online Add To Cart Add To Cart

Access 2013

Level 2

This course builds upon basic Microsoft Access skills to help students become power users. In this advanced Microsoft Access 2013 course, students will delve deeper into the program by studying a dozen different topics. Modules in this course cover how to manage data and data entry; create forms, macros, and dialog boxes; create and use SQL queries; split databases; and much more.

1 Day

List Price: $265


Register!

Topic 1: Managing Data

  • Types of Relationships
  • Viewing Relationships
  • Viewing Object Dependencies
  • What is Referential Integrity?
  • Enforcing Referential Integrity
  • Using Cascade Delete and Cascade Update
  • Review Questions

Topic 2: Advanced Table Tasks

  • Inserting Application Parts
  • Using the Table Analyzer Wizard
  • Creating Validation Rules
  • Configuring Validation Messages
  • Review Questions

Topic 3: Managing Data Entry in Tables

  • Marking Fields as Required
  • Marking a Field for Indexing
  • Creating Lookup Fields
  • Creating Value Lists
  • Creating Input Masks
  • Review Questions

Topic 4: Creating Subforms

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

Topic 5: 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
  • Review Questions

Topic 6: Advanced Query Tasks

  • Understanding SQL Statements
  • Basic SQL Keywords
  • Creating SQL Queries
  • Using the Expression Builder
  • Review Questions

Topic 7: Creating Modal Dialog Boxes

  • Creating a Modal Dialog Box
  • Adding Controls
  • Setting Properties
  • Formatting a Modal Dialog Box
  • Review Questions

Topic 8: Splitting the Database

  • Backing Up the Database
  • Splitting the Database
  • Configuring Access 2013 for a Multi-User Database
  • Setting Record Locking Options
  • Review Questions

Topic 9: Using Access with SharePoint Server

  • Linking Tables and Lists
  • Moving a Database to SharePoint
  • Saving a Database to SharePoint
  • About Access Web Apps
  • Review Questions

Topic 10: Creating Basic Macros

  • Creating a Standalone Macro
  • Using the Action Catalog
  • Adding Comments to Macros
  • Using If-Then Actions
  • Handling Macro Errors
  • Review Questions

Topic 11: Advanced Macro Tasks

  • Creating Event Procedures
  • Creating Data Macros
  • Creating Submacros
  • Grouping Submacros
  • Review Questions

Topic 12: Using Visual Basic for Applications

  • Converting a Macro to Visual Basic
  • Using Visual Basic for Applications
  • Understanding Topics
  • Building Visual Basic Procedures
  • Review Questions

Access 2013

Level 2

1 Day

List Price: $265

Date Time Classroom or Online Select Session
01/28/2019 8:30 AM Classroom Add To Cart Add To Cart
01/28/2019 8:30 AM Online Add To Cart Add To Cart
02/25/2019 8:30 AM Classroom Add To Cart Add To Cart
02/25/2019 8:30 AM Online Add To Cart Add To Cart

Access 2013

Level 3

The aim of this Microsoft Access 2013 Level 3 course is to give students a grasp of the tools they need to exploit the high-level user skills of this software. Over the course of a dozen modules learners are introduced to many vital skills they can make use of including: SQL, the SELECT Statement, SQL Joins, subqueries, advanced form tasks, split forms, digital signatures, the Trust Center, COM add-ins, and techniques for customizing Access.


1 Day

List Price: $265


Register!

Topic 1: SQL and Microsoft Access

  • What is SQL?
  • What is an SQL Statement?
  • What is an SQL Naming Convention?
  • What is SQL Syntax?

Topic 2: Using the SELECT Statement

  • Selecting All Data
  • Selecting Specific Data
  • Selecting Conditional Data
  • Using the ORDER BY Statement

Topic 3: Using SQL Joins

  • Creating Simple Joins
  • Using an Alias
  • Sorting Joins
  • Creating Outer Joins

Topic 4: Using Subqueries

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

Topic 5: Advanced Form Tasks, Part One

  • Limiting User Access to a Form
  • Creating Checkboxes and Command Buttons
  • Building Command Button Events
  • Creating Event Procedures

Topic 6: Advanced Form Tasks, Part Two

  • 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
  • Performing Calculations in a Form

Topic 7: Advanced Form Tasks, Part Three

  • 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

Topic 8: Creating Split Forms

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

Topic 9: Using Digital Signatures

  • What is a Digital Signature?
  • Obtaining a Digital Signature
  • Attaching Your Signature to a Database
  • Extract and Use a Signed Database

Topic 10: Using the Trust Center

  • Opening the Trust Center
  • Trusting a Database
  • Configuring Macro Security
  • Customizing the Message Bar

Topic 11: Managing COM Add-ins

  • Viewing Add-ins
  • Opening the Add-in Manager
  • Installing Add-ins
  • Disabling All Add-ins
  • Uninstalling Add-ins

Topic 12: Customizing Access

  • Changing User Information
  • Changing the Office Background and Theme
  • Setting the Default Database Type and Location

Access 2013

Level 3

1 Day

List Price: $265

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Access 2016

Level 1

This Level 1 workshop covers the skills that students will need to make the most of Microsoft Access 2013. The course begins with the basics and progresses through several modules which cover databases, tables and records, forms, reports, queries, and much more.

1 Day

List Price: $265


Register!

Topic 1: The Basics

  • Getting Started
  • Signing In
  • Creating a Database
  • Database Terminology
  • Saving a Database
  • Opening a Database
  • Review Questions

Topic 2: Your First Database

  • About Security Warnings
  • About Relationships
  • Searching for Objects
  • Opening Database Objects
  • Changing the Object View
  • Understanding the Types of Views Available
  • Managing Objects
  • Review Questions

Topic 3: Working with Tables and Records

  • Creating a Table
  • Understanding Table Views
  • Adding and Editing Records
  • Searching and Browsing Records
  • Deleting Records
  • Printing Records
  • Review Questions

Topic 4: Formatting Tables

  • Selecting Data
  • Changing Column and Row Width and Height
  • Applying Text Formatting
  • Applying Gridlines
  • Changing Fill Colors
  • Checking Your Spelling
  • Review Questions

Topic 5: Creating Forms

  • Creating a Form from an Object
  • Creating a Form with the Wizard
  • Creating a Form from Scratch
  • Understanding Form Views
  • Using a Form
  • Review Questions

Topic 6: Formatting Forms

  • Understanding Bound and Unbound Controls
  • Changing the Theme
  • Using the Format Painter
  • Adding Fields
  • Adding Controls
  • Adding Images and Logos
  • Review Questions

Topic 7: Creating Reports

  • Creating a Report from an Object
  • Creating a Report with the Wizard
  • Creating a Report from Scratch
  • Understanding Report Views
  • Printing Reports
  • Review Questions

Topic 8: Formatting Reports

  • Changing the Theme
  • Using the Format Painter
  • Grouping and Sorting Data
  • Adding Controls
  • Adding Images and Logos
  • Adding Page Numbers, Headers, and Footers
  • Review Questions

Topic 9: Creating Basic Queries

  • Types of Queries
  • Creating a Query with the Wizard
  • Running a Query
  • Understanding Query Views
  • Sorting and Filtering a Query
  • Review Questions

Access 2016

Level 1

1 Day

List Price: $265

Date Time Classroom or Online Select Session
01/04/2019 8:30 AM Online Add To Cart Add To Cart
01/04/2019 8:30 AM Classroom Add To Cart Add To Cart
02/06/2019 8:30 AM Classroom Add To Cart Add To Cart
02/06/2019 8:30 AM Online Add To Cart Add To Cart

Access 2016

Level 2

Welcome to the second part of our Microsoft Office Access 2016 courseware. Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user. 

1/2 Day

List Price: $265


Register!

Lesson 1: Implementing Advanced Form Design

TOPIC A: Add Controls to Forms

  • Types of Controls
  • Command Buttons
  • Quick Start Fields
  • Calendar/Datepicker Control
  • Form Layouts
  • Quick Styles
  • Tab Order
  • The Anchoring Tool

TOPIC B: Set Form Controls

  • Move Form Controls
  • Add Form Controls
  • Remove Form Controls
  • Modify Data Sources
  • Set Form Control Properties
  • Manage Labels
  • Subforms

TOPIC D: Organize Information with Tab Pages

  • Tab Pages

TOPIC E: Enhance Navigation with Forms

  • Navigation Control and Navigation Forms
  • Setting Navigation Options
  • Creating a Navigation Form
  • Using a Navigation Form

TOPIC F: Format a Form

  • Insert Headers And Footers
  • Insert Images
  • Auto-Order Forms
  • Sort Records
  • Apply Themes
  • Insert Backgrounds
  • Change Margins

TOPIC G: Apply Conditional Formatting

  • Conditional Formatting

Lesson 2: Using Data Validation

TOPIC A: Field Validation

  • Field Properties
  • Input Masks
  • The Input Mask Wizard
  • Input Mask Characters
  • Lookup Lists
  • Expression Builder

TOPIC B: Form and Record Validation

  • Form Validation
  • Control Wizards
  • The Combo Box Control
  • The List Box Control
  • The Option Group Control
  • Record Validation

Lesson 3: Using Macros to Improve User Interface Design

TOPIC A: Create a Macro

  • Macros
  • The Macro Builder Window
  • Macro Actions
  • Types of Macro Actions
  • Action Arguments
  • Object Events
  • Macros in Access Web Apps

TOPIC B: Restrict Records Using a Condition

  • Macro Conditions
  • The Where Condition

TOPIC C: Validate Data Using a Macro

  • Event Properties for Data Validation
  • Macro Actions for Data Validation
  • Embedded Macros

TOPIC D: Automate Data Entry Using a Macro

  • Event Properties for Automating Data Entry
  • Macro Actions for Automating Data Entry

TOPIC E: Convert a Macro to VBA

  • Macros and VBA

Lesson 4: Using Advanced Database Management

TOPIC A: Link Tables to External Data Sources

  • External Data Sources
  • The Linked Table Manager

TOPIC B: Manage a Database

  • Exclusive Mode
  • Database Access Modes
  • Database Backup
  • The Compact and Repair Database Option

TOPIC C: Determine Object Dependency

  • Object Dependency

TOPIC D: Document a Database

  • The Database Documenter

TOPIC E: Analyze the Performance of a Database

  • Performance Analyzer

Lesson 5: Distributing and Securing a Database

TOPIC A: Split a Database for Multiple User Access

  • Splitting a Database
  • Merging a Database

TOPIC B: Implement Security

  • Security Strategies in Access 2016
  • The Message Bar
  • The Trust Center Dialog Box
  • Trusted Locations

TOPIC C: Set Passwords

  • Password Protection Guidelines

TOPIC D: Convert an Access Database to an ACCDE File

  • The ACCDE File Format
  • User Templates
  • Saving Databases as Templates

TOPIC E: Package a Database with a Digital Signature

  • Digital Signatures
  • Digital Certificates
  • The Package and Sign Feature

Lesson 6: Managing Switchboards

TOPIC A: Create a Database Switchboard

  • Switchboards
  • Switchboard Manager

TOPIC B: Modify a Database Switchboard

  • Switchboard Modification

TOPIC C: Set Startup Options

  • Database Startup Options


Access 2016

Level 2

Half Day

List Price: $265

Date Time Classroom or Online Select Session
01/28/2019 8:30 AM Classroom Add To Cart Add To Cart
01/28/2019 8:30 AM Online Add To Cart Add To Cart
02/25/2019 8:30 AM Online Add To Cart Add To Cart
02/25/2019 8:30 AM Classroom Add To Cart Add To Cart

back to top

Customize Sessions

Need a customized session?


Did you know that all of our sessions can be customized?
Let us help create a private session your team will love!

Selected Sessions

No Sessions Selected

Add a session to begin registration.
  • Personalize This Session

    All of our sessions can be customized to meet your team's specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team's valuable time!

    Let us help customize your next:

    Lunch-n-Learn

    30-90 Minute Webinar

    Half or Full Day Training

    On-Demand Learning

    Team Learning Paths



    Contact us today!



Contact

ETI Performance Improvement
8500 Keystone Crossing Suite 550
Indianapolis, Indiana 46240

p. 317.475.6555
e. [email protected]

Hours:
8:00 am - 5:00 pm M-F EST

Educate. Equip. Empower.
ETI Performance Improvement

© 2018 ETI Performance Improvement        Illustrations ©2012 Nathaniel Charles