In this course, students will learn to work through troubleshooting scenarios using Access database tools, learn to improve performance and enhance security, use VBA to interact with forms.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upon successful completion a student will be able to organize and manage data stored within Access tables, use queries to join, sort and filter data from different tables and create and format custom reports.

1
  • Using Macros on Forms

  • Using a macro to open a form
    Using a macro to validate data
    Using a macro to automate data entry

2
  • Using Macros on Tables and Reports

  • Table macros 28
    Report macros 30

3
  • Finalizing the Databse Interface

  • Create a navigfinaation form 33
    Create a switchboard 37
    Setting startup options 42

4
  • Enhancing Security on a Database

  • Advanced startup options
    Splitting a database
    Password-protecting a database

5
  • Troubleshooting Tables

  • Fixing data in fields
    Checking object dependencies
    Updating database objects based on table changes Creating many-to-many relationships

6
  • Interacting Through Dialog Forms

  • Interacting Through Dialog Forms

7
  • Using VBA

  • Designing and coding interaction on a form
    Testing vba code
    Adjusting and enhancing vba code
    Protecting vba code
    Bonus- using vba on exports

8
  • Performing Databse Maintenance

  • Analyzing database performance
    Backing up a database
    Compacting a database

9
  • XML in Access

  • Importing XML into Access
    Exporting XML from Access

Audience

This course is designed for the student who has taken Access 2 or the equivelant experience.

Language

English

Prerequisites

There are no stated prerequisites for this course. Please check with your representative for details.

$450

Length: 1.0 day (8 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...