Databases

Access 2016/2013/2010 Part 3 (2007 Upon Request)

This course covers important topics related to creating or administering an Access database. Learn to implement advanced form design, share data across applictions, use macros to imporove user interface design, and manage database switchboards.

Dates & Times

CourseDate & TimeLocationCost
Access 2016/2013/2010 Part 3 (2007 Upon Request)January 30 - 8:30 - 4:30LathamRegister
Access 2016/2013/2010 Part 3 (2007 Upon Request)March 8 - 8:30 - 4:30LathamRegister
Access 2016/2013/2010 Part 3 (2007 Upon Request)April 9 - 8:30 - 4:30LathamRegister
Access 2016/2013/2010 Part 3 (2007 Upon Request)May 14 - 8:30 - 4:30LathamRegister

Course Outline

This course is recommended for individuals who are very familiar with Access but would benefit from learning a variety of advanced features.

Includes:
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Implementing Advanced Form Design

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

Lesson 2: Sharing Data Across Applications

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

Lesson 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

Lesson 4: Using VBA

  • Getting started with VBA
  • Enhance Access using VBA

Lesson 5: Using Advanced Database Management

  • Manage a database
  • Determine object dependency
  • Document a database

Lesson 6: Distributing and Securing a Database

  • Splitting a database for multiple user Access
  • Implement security
  • Convert an Access database to an ACCDE file
  • Package a database with a digital signature

Lesson 7: Managing Switchboards

  • Create a database switchboard
  • Modify a database switchboard
  • Set startup options