0
  • An empty cart

    You have no item in your shopping cart

0
  • An empty cart

    You have no item in your shopping cart

Enter your keyword

Course

Access 2013 – Part 2

National Business Training - Computer Training

Course Summary

In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Course Schedule

    • Start Date
    • End Date
  • Time
  • Price
  • Status
      • 2/27/2017
      • 2/28/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 3/22/2017
      • 3/23/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 4/13/2017
      • 4/13/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 5/15/2017
      • 5/16/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 5/22/2017
      • 5/23/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 6/8/2017
      • 6/9/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 6/28/2017
      • 6/29/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 8/17/2017
      • 8/18/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 10/26/2017
      • 10/27/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 12/21/2017
      • 12/22/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
  • S - ScheduledGTR - Guaranteed to Run

Course Outline

1 – IMPLEMENTING ADVANCED FORM DESIGN

Add Controls to Forms
Create Subforms
Organize Information with Tab Pages
Enhance Navigation of Forms
Apply Conditional Formatting

2 – USING DATA VALIDATION

Field and Record Validation
Form Validation

3 – USING MACROS TO IMPROVE USER INTERFACE DESIGN

Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA

4 – USING ADVANCED DATABASE MANAGEMENT

Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

5 – DISTRIBUTING AND SECURING A DATABASE

Splitting a Database for Multiple User Access
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature

6 – MANAGING SWITCHBOARDS

Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options

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

Course Objectives

 

Target Audience

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills. This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.

 

Price $550.00

Date

Share our course