Fully Customizable Courseware For Trainers
Access 2013: Advanced Essentials
Deliver high-impact training with professionally designed, fully editable courseware you can brand, customize, and deliver in-person or online
$795.00
Microsoft Access 2013 Advanced Essentials training materials are here!
Check out this incredible list of topics covered in this Access 2013 training course:
-
- Managing data
- Advanced table tasks
- Managing data entry in tables
- Creating subforms
- Creating navigation forms
- Advanced query tasks (including an overview of SQL statements)
- Creating modal dialog boxes
- Splitting the database
- Using Access with SharePoint server
- Creating basic macros
- Advanced macro tasks
- Using Visual Basic for Applications in Access 2013
This package includes the following customizable components:
-
- Instructor’s guide
- PowerPoint slides
- Exercise workbook
- Exercise files with pre- and post-tests
- Course outline
- Lesson plan
- Quick reference guide
Module 1: Managing Data
Types of Relationships
Viewing Relationships
Viewing Object Dependencies
What is Referential Integrity?
Enforcing Referential Integrity
Using Cascade Delete and Cascade Update
Review Questions
Module 2: Advanced Table Tasks
Inserting Application Parts
Using the Table Analyzer Wizard
Creating Validation Rules
Configuring Validation Messages
Review Questions
Module 3: Managing Data Entry in Tables
Marking Fields as Required
Marking a Field for Indexing
Creating Lookup Fields
Creating Value Lists
Creating Input Masks
Review Questions
Module 4: Creating Subforms
Creating Subforms
Using Subforms
Linking Subforms with Parent Forms
Formatting a Subform within a Main Form
Review Questions
Module 5: Creating Navigation Forms
Creating a Navigation Form
Adding Tabs to a Navigation Form
Creating a Tab Hierarchy
Displaying the Navigation Form when the Database Opens
Review Questions
Module 6: Advanced Query Tasks
Understanding SQL Statements
Basic SQL Keywords
Creating SQL Queries
Using the Expression Builder
Review Questions
Module 7: Creating Modal Dialog Boxes
Creating a Modal Dialog Box
Adding Controls
Setting Properties
Formatting a Modal Dialog Box
Review Questions
Module 8: Splitting the Database
Backing Up the Database
Splitting the Database
Configuring Access 2013 for a Multi-User Database
Setting Record Locking Options
Review Questions
Module 9: Using Access with SharePoint Server
Linking Tables and Lists
Moving a Database to SharePoint
Saving a Database to SharePoint
About Access Web Apps
Review Questions
Module 10: Creating Basic Macros
Creating a Standalone Macro
Using the Action Catalog
Adding Comments to Macros
Using If-Then Actions
Handling Macro Errors
Review Questions
Module 11: Advanced Macro Tasks
Creating Event Procedures
Creating Data Macros
Creating Submacros
Grouping Submacros
Review Questions
Module 12: Using Visual Basic for Applications
Converting a Macro to Visual Basic
Using Visual Basic for Applications
Understanding Modules
Building Visual Basic Procedures
Review Questions
 Select the format that works best for your organization or learners
Instructor-Led Training Kits
Complete training kit with everything you need to facilitate.
- Instructor Guide
- Participant Manual
- PowerPoint Slides
- Print-Ready Files
- Editable in Word/PowerPoint
- More
SCORM eLearning Courses
Ready-to-deploy eLearning for any SCORM-compliant LMS.
- SCORM 1.2 Package
- LMS Compatible
- Completion Certificates
- Progress Tracking
- Mobile Responsive
Storyline Source Files
Editable .story files for full customization in Articulate 360.
- Editable Source Files
- Articulate 360 Format
- Brand Customization
- Content Editing
- Interactive Elements
c1923c
What You Get
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.