Skip To Content
Image of a desktop computer with keyboard and mouse Access: Advanced, Part 1 is a Course

Access: Advanced, Part 1

May 12 - May 12, 2020
0.5 credits

Spots remaining: 10

Enroll

Full course description

Term: Spring 2020
Date: Tuesday, May 12, 2020
Time: 1 pm - 4:30 pm
Location: North End Center, Room 2460
Instructor: Linda Lester
Presented By: New River Community College Partnership

Description:

This course will help experienced users take advantage of even more benefits with Access 2016, a database management program. Access is used mainly for analyzing large amounts of information and managing related data. This course covers advanced form design and navigation, importing and exporting data into Access, and creating macros and validating data using macros so that you will have access to organized information in your database with minimal effort using this ideal product from Microsoft.  

Workshop Objectives:

Implement Advanced Form Design

  • Add controls to a form
  • Enhance navigation and organization of forms
  • Apply conditional formatting

Share Data Across Applications

  • Import and export data into Access
  • Link tables to external data sources
  • Create a mail merge

Use Macros to Improve User Interface Design

  • Create a macro
  • Restrict records by using a condition
  • Validate data by using a macro
  • Automate data entry by using a macro

Cancellation and No-Show Policy

Cancellations must be received by Human Resources at hr@vt.edu at least three business days prior to the workshop. A $35.00 fee will be assessed to all no-shows and cancellations received less than three business days prior to the workshop.

Sign up for this course today!

Enroll