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

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!!!

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

Register


Price: $895   Duration: 2 days

- EST

Select Date: