Fully Customizable Courseware For Trainers
Access 2013: Advanced Essentials
DOWNLOAD A FREE SAMPLE
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
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
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable manual gives each participant the student version of the course you will be teaching.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
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.
