Skip Main Navigation
Page Content

Save This Event

Event Saved

Access Advanced Essentials

Discover Information Technology and Training

Monday, February 13, 2017 from 8:30 AM to 4:00 PM (CST)

Access Advanced Essentials
Available Dates

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Access Advanced 8 Tickets Feb 13, 2017 $200.00 $0.00

Who's Going

Loading your connections...

Share Access Advanced Essentials

Event Details

Microsoft Access 2013 Advanced Essentials

Course Length: 1 Day

 

Overview

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.

 

Course Contents

Managing Data

This opening module will show students how to view relationships, view object dependencies, enforce referential integrity, and enforce cascade update and delete. Students also will learn about types of relationships and referential integrity.

 

Advanced Table Tasks

In this module, students are shown how to insert application parts, use the Table Analyzer Wizard, create validation rules, and configure validation messages.

 

Managing Data Entry in Tables

In this module, topics include how to mark fields as required, mark a field for indexing, create lookup fields, create value lists, and create input masks.

 

Creating Subforms

This module covers how to create and use subforms, link subforms with parent forms, and format a subform within a main form.

 

Creating Navigation Forms

Next, students are shown how to create a navigation form and add tabs to it, create a tab hierarchy in a navigation form, and automatically display a navigation form when the database opens.

 

Advanced Query Tasks

This module will give students the answers about queries. Topics covered include how to create SQL queries, use the Expression Builder, create SQL statements, and use SQL keywords.

 

Creating Modal Dialog Boxes

Modal dialog boxes get a thorough look in this module. Topics include how to create, format, and modify a modal dialog box.

 


 

Splitting the Database

When dealing with databases, it’s a good idea to have tools to manipulate them effectively. This module takes a look at how to back up a database, split a database, configure Access 2013 for a multi-user database, and set record locking options.

 

Using Access with SharePoint Server

SharePoint Server meshes well with Access 2013 and this module takes advantage of that relationship. Students will learn how to link tables to lists, move a database to SharePoint, save a database to SharePoint, and use Access web apps.

 

Creating Basic Macros

This module shows students how to create a standalone macro, use the Action Catalog, add comments to macros, use If-Then actions, and handle macro errors.

 

Advanced Macro Tasks

Next, students will learn how to create event procedures, data macros, and submacros.

 

Using Visual Basic for Applications

The final module in this course explores how to use Visual Basic for Applications. Students will learn how to convert a macro to Visual Basic, use Visual Basic for Applications, use modules, and build Visual Basic procedures.

 

Have questions about Access Advanced Essentials? Contact Discover Information Technology and Training

Save This Event

Event Saved

When & Where


Discover ITT Riverchase Training Center
3 Riverchase Office Plaza
#114
Hoover, AL 35244

Monday, February 13, 2017 from 8:30 AM to 4:00 PM (CST)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.