No New Notifications

Access Advanced: Training Class

Select Option

Highlights

Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

The class identified is made available through CourseHorse, a 3rd party marketplace for Access classes and more. Groupon is not affiliated with or sponsored by the merchant, Computer Training Source, Inc., in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.

About This Deal

Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques.

Class Outline

Unit 1: Implementing Advanced Form Design

  • Topic A: Add Controls to Forms
  • Topic B: Enhance navigation and organization of forms
  • Topic C: Apply conditional formatting

Unit 2: Sharing data across applications

  • Topic A: Import data into access
  • Topic B: Export Access data
  • Topic C: Link Tables to external data sources
  • Topic D: Create a mail merge

Unit 3: Using macros to improve user interface design

  • Topic A: Create a macro
  • Topic B: Restrict records by using a condition
  • Topic C: Validate data by using a macro
  • Topic D: Automate data entry by using a macro
  • Topic E: Converting a macro to VBA

Unit 4: Using Advanced database management

  • Topic A: Manage a database
  • Topic B: Determine object dependency
  • Topic C: Document a database

Unit 5: Distributing and Securing a database

  • Topic A: Splitting a database for multiple-user access
  • Topic B: Implement security
  • Topic C: Convert an Access database to an ACCDE file
  • Topic D: Package a database with a digital signature

Unit 6: Creating a Start-up Display Form

  • Topic A: Create a display form
  • Topic B: Set start-up options

Note:

Effective July 1, 2020, all customers are required to wear a mask or face covering at all times while in our building, to prevent the spread of COVID-19. Temperature checks may be conducted at the door, and people with a fever will be required to reschedule their visit.

The class identified is made available through CourseHorse, a 3rd party marketplace for Access classes and more. Groupon is not affiliated with or sponsored by the merchant, Computer Training Source, Inc., in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.

Fine Print

Expiration varies.
  • ALL SALES FINAL.
  • Must be 18 or older to attend
  • Voucher valid only for date and time listed; may not be exchanged, altered, or redeemed for other dates, but may send a friend in place.
  • Must present CourseHorse confirmation email upon arrival.
  • Purchaser name must be provided at checkout; this information will be shared with CourseHorse and course provider for purposes of order fulfillment.
  • Groupon voucher Terms of Sale and Extraordinary Event Policy do not apply.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services.
  • Offer is not eligible for our promo codes or other discounts.
  • Note, additional equipment or materials may be required or included in purchase price, see course description for details.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services. Offer is not eligible for our promo codes or other discounts.

About Computer Training Source, Inc.