Velsoft’s one-level courseware and training materials package on Microsoft Access 2013 Core Essentials is a resource that no trainer should be without.
This course starts at the basics. The modules progress to teach the student about tables, reports, queries, how to manage a database, ways to customize the
interface, and more.
All Velsoft training packages are fully customizable and include everything you will need to teach a comprehensive course, including an instructor guide,
exercise workbook, quick reference guide, course outline, and much more. Try a free sample today!
Module 1: The Basics
Getting Started
Signing In
Creating a Database
Database Terminology
Saving a Database
Opening a Database
Review Questions
Module 2: Your First Database
About Security Warnings
About Relationships
Searching for Objects
Opening Database Objects
Changing the Object View
Understanding the Types of Views Available
Managing Objects
Review Questions
Module 3: Working with Tables and Records
Creating a Table
Understanding Table Views
Adding and Editing Records
Searching and Browsing Records
Deleting Records
Printing Records
Review Questions
Module 4: Formatting Tables
Selecting Data
Changing Column and Row Width and Height
Applying Text Formatting
Applying Gridlines
Changing Fill Colors
Checking Your Spelling
Review Questions
Module 5: Creating Forms
Creating a Form from an Object
Creating a Form with the Wizard
Creating a Form from Scratch
Understanding Form Views
Using a Form
Review Questions
Module 6: Formatting Forms
Understanding Bound and Unbound Controls
Changing the Theme
Using the Format Painter
Adding Fields
Adding Controls
Adding Images and Logos
Review Questions
Module 7: Creating Reports
Creating a Report from an Object
Creating a Report with the Wizard
Creating a Report from Scratch
Understanding Report Views
Printing Reports
Review Questions
Module 8: Formatting Reports
Changing the Theme
Using the Format Painter
Grouping and Sorting Data
Adding Controls
Adding Images and Logos
Adding Page Numbers, Headers, and Footers
Review Questions
Module 9: Creating Basic Queries
Types of Queries
Creating a Query with the Wizard
Running a Query
Understanding Query Views
Sorting and Filtering a Query
Review Questions
Module 10: Creating Advanced Queries
Creating and Using Parameter Queries
Creating and Using Crosstab Queries
Creating and Using Make-Table Queries
Creating and Using Multiple Table Queries
Creating and Using Append Queries
Creating and Using Delete Queries
Creating and Using Update Queries
Review Questions
Module 11: Managing Your Database
Compacting and Repairing a Database
Encrypting a Database with a Password
Backing Up Your Database
Exporting a Database and Database Objects
Printing Database Objects
Review Questions
Module 12: Customizing the Interface
Collapsing and Pinning the Ribbon
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes
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 Student Manual gives each participant the ?student? version of the course you will be teaching.
Exercise Workbook
Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.
Sample Files
Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.
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.