Microsoft Access Techniques—Intermediate

This session is available as an online webinar (90-minute webinar) or an onsite session at your organization. Please contact us to request scheduling.

Who should attend?

This workshop is for business users who are familiar and comfortable with the basics of working with Microsoft Access objects and want to expand their skills to include some of Access’ more advanced features. Microsoft Access offers a wealth of powerful tools for manipulating large amounts of data in bulk, customizing your application’s interface, automating tasks, and moving data between Access and other applications.

This workshop is offered for Access users as public instructor-led webinars. It is also offered for corporate users in the form of corporate Webinars, and onsite training sessions.

Here are some of the key topics and techniques that are covered

  • Advanced Field Types. Creating table fields that calculate their values from data in other tables, lookup data entry choices from other tables, or hold actual files of any type as attachments to the record.
  • Importing/Exporting. Moving data in and out of Access tables in a variety of formats, including Excel spreadsheets and text files.

  • Advanced Relationships. Accommodating data that doesn’t fit neatly into the “one-to-many” model, and creating forms to handle this situation easily and intuitively.

  • Customizing Forms and Reports. Modifying control properties to exact specifications. Conditional formatting, based on the data in a field.

  • Action queries. Using queries to change large amounts of data in batch.

  • Subforms and subreports. Creating forms and reports that show all the related data to a single record.

  • Macros. Learning how to automate repetitive tasks with the click of a button.

What will you be able to do as a result

  • Use advanced field types for lookups, calculations and file attachments to records

  • Move data in and out of Access tables in a variety of different formats

  • Work with table data in a variety of relationship types

  • Customize forms and reports using control and form properties and conditional formatting

  • Manipulate large amounts of data in batch using action queries

  • Create subforms and subreports to view and work with both a single record and all of its related records at the same time

  • Automate database tasks with macros