Happy New Year SALE Special Discount - 50% off all courses! Use coupon code NEWYEAR2020 AND click Apply before you pay at checkout (Click here to apply the discount automatically at checkout now).

Access 2013 Expert
Access 2013 Expert
Access 2013 Expert

Access 2013 Expert

Regular price
€40,00
Sale price
€40,00
Tax included. Shipping calculated at checkout.

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. This course is designed for advanced users of Access 2013. This course incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

This course is meant to provide a safe learning environment where they can practice and learn Access 2013 Expert functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Module One: Getting Started

Module Two: Customizing Apps (I)

  • Creating a Custom App from Scratch
  • Adding a Template Table Adding a Blank Table
  • Importing Access 2010 Tables
  • Module Two: Review Questions

Module Three: Customizing Apps (II)

  • About Custom Actions
  • Adding a Custom Actin
  • Editing a Custom Action
  • Deleting a Custom Action
  • Module Three: Review Questions

Module Four: Customizing Apps (III)

  • About User Interface Macros
  • Creating an Embedded Macro
  • Creating a Standalone macro
  • Saving Your App as a Package
  • Module Four: Review Questions

Module Five: Working with Validation Rules and Messages

  • Creating a Field Validation Rule
  • Creating a Field Validation Message
  • Creating a Validation Rule
  • Creating a Validation Message
  • Testing Validation Rules
  • Module Five: Review Questions

Module Six: Working with Macros

  • Creating a Before Change Event
  • Working with the Macro Tools Design Tab
  • Working with the Action Catalog
  • Creating an After Event
  • Creating a Named Macro
  • Renaming or Deleting Macros
  • Module Six: Review Questions

Module Seven: Advanced Query Tasks

  • Using Query Design View
  • Creating Ad Hoc Relationships
  • Creating an Update Query
  • Creating a Parameter Query
  • Comparing Two Tables by Using a Join
  • Module Seven: Review Questions

Module Eight: Designing Forms

  • Common Formatting Tasks
  • Using Themes
  • Working with Controls
  • Adding Header and Footer Elements
  • Arranging Form Elements
  • Formatting Forms
  • Module Eight: Review Questions

Module Nine: Advanced Reporting Tasks

  • Using Report Sections
  • Using Conditional Formatting
  • Grouping and Sorting Data
  • Adding Calculated Controls
  • Creating Labels
  • Module Nine: Review questions

Module Ten: Advanced Database Tools

  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database
  • Module Ten: Review Questions

Module Eleven: Working with the Access Environment

  • Working with Database Properties
  • Encrypting a Database with a Password
  • Using Save Object As
  • Setting Access Options
  • Module Eleven: Review Questions

Customer Reviews

Based on 1 review Write a review