Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge
4.67 out of 50 stars, based on 80 reviews*

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Request Group Quote

Purchase

Price: $895   Duration: 2 days
- EST
Select Date:
Number of Seats:

Course 100018

Price: $895, Length: 2 days

Access 2019 Level 3 - Advanced. Versions 2013, 2016 Office 365, & Online are available.

To customize this class, call 800-453-5961 or click here to contact us

Access 2016 , Level 3 - Advanced

Versions 2013, 2016, 2019, Office 365, & Online are also available.

Course Outline

Lesson 1 - Working with Macros

  • Creating a Macro
  • Adding Additional Macro Actions
  • Running a Macro Step-By-Step
  • Assigning a Macro to a Command Button
  • Creating a Macro Group
  • Using a Macro Group
  • Using Macro Conditions
  • the Autoexec Macro
  • Creating an Autokeys Macro
  • Creating a Data Macro
  • Adding a Macro to the Quick Access Toolbar

Lesson 2 - Action Queries

  • About Action Queries
  • Creating a Make-Table Query
  • Creating an Append Query
  • Creating an Update Query
  • Creating a Delete Query
  • Creating a Sql Query

Lesson 3 - Importing and Exporting Data

  • Importing Data from a Text File
  • Importing Data from Excel
  • Importing Data from Another Access Database
  • Linking Data
  • Exporting Data to Other Formats
  • Exporting Data to a PDF File
  • Exporting Data to Another Access Database
  • Exporting Data to Excel
  • Exporting Data to Microsoft Word
  • Exporting Data to a Microsoft Word Mail Merge

Lesson 4 - Creating a Menu System

  • Creating a Switchboard
  • Adding Switchboard Items
  • Using the Switchboard
  • Editing a Switchboard
  • Setting Startup Options
  • Creating a Navigation Form

Lesson 5 - Working with Forms and Reports

  • Adding a SubForm Using the SubForm/SubReport Tool
  • Modifying a SubForm
  • Aligning Controls to Each Other
  • Creating an Option Group
  • Edit Sorting and Grouping Levels in a Report
  • Inserting Total Fields in a Report
  • Using Rectangles, Lines and Borders

Lesson 6 - Database Tools and Maintenance

  • Using Compact and Repair
  • Changing Database Properties
  • Documenting a Database
  • Analyzing a Database
  • Viewing Object Dependencies
  • Backing Up a Database
  • Splitting a Database
  • Setting a Database Password

We look forward to your success!!!

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.


100018Access 2019 Level 3 - Advanced. Versions 2013, 2016 Office 365, & Online are available.