eLearning Bundle - Access 2019 Online Course

Microsoft Access TrainingeLearning Bundle - Access 2019

by Certstaffix® Training

Length: 2 Course(s)      Price: $350/person (US Dollars)      Bulk Pricing: 6+ Contact Us      Access Length: 6 Months      Category: Microsoft Access


This eLearning bundle includes two Microsoft Access 2019 courses:

Introduction to Microsoft Access 2019

This Introduction to Microsoft Access 2019 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports in Access 2019 or Access 365.

Advanced Microsoft Access 2019

This Advanced Access 2019 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online Microsoft Access Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Any software needed for training is provided in an online lab environment.

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
Microsoft Access Training

Introduction to Microsoft Access 2019 - 20:07 hours

This Introduction to Microsoft Access 2019 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports in Access 2019 or Access 365.

Quick Overview of the Access User Interface
Access Ribbon
File
Home
Create
External Data
Database Tools
Contextual Tabs
Quick Access Toolbar
Object Navigation Pane
Access Work Surface
Object Overview
Tables
Queries
Forms
Reports
Macros and Modules
Process Overview
Exercise: Getting Around the Access Environment
Create a Database Using a Wizard
Fundamentals
Questions to Ask Before You Start
What is the purpose of the database?
Who will use the database?
What kind of output is needed from the database?
What process is the database replacing or improving?
Exercise: Asking Questions
Approaches to Database Design
Top-Down Database Design
Bottom-Up Database Design
Reality
Gather Information
Data Mapping
Sample Data Map
A Few Words about Naming Conventions
Exercise: Gathering Information
Normalization
First Normal Form
Second Normal Form
Third Normal Form
Table Relationships
Relationship Types
Exercise: Normalizing Data
Tables and Their Views
Definition and Purpose
Datasheet View
Selection Tools
Table Layout Tools
Sorting and Filtering Tools
Print Records
Record Navigation
Working in Datasheet View
Exercise:Working with Tables in Datasheet View
Design View
Open a Table in Design View
Design View Layout
Tables
Creating an Access Database
Exercise: Creating a New Database
Data Types
Exercise: Determining Data Types
Create a Table in Design View
Delete a Field
Rename a Table
Exercise: Creating a Table in Design View
Queries
Queries
Definition and Purpose
Types
Views
Select Queries
Select Queries with Criteria
Logical Operators
Group and Total with Queries
Totals Row with Group By
Exercise: Creating Select Queries
Forms
Forms
Definition and Purpose
Views
Alter a Form
Delete Forms
Remove Form Controls
Format a Form
Exercise: Adding Data Records in Form View
Form Record Navigation
Layout View and Design View
One-Click Forms
Basic Data Entry Form
Basic Multi-Record Form
Datasheet Form
Split Form
Form Wizard
Create a Form with the Form Wizard
Exercise: Creating a Form with the Form Wizard
Reports
Reports
Definition and Purpose
Views
One-Click Report
Report Wizard
Create a Report Using the Report Wizard
Exercise: Creating a Report with the Report Wizard

Advanced Microsoft Access 2019 - 21:07 hours

This Advanced Access 2019 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

Relationships
Review
Referential Integrity
Relationships
Data Types and Relationships
Formalize the Relationship between Tables
A Few Words about Naming Conventions
Exercise: Creating Relationships
Queries
Query Design View
Review of Select Queries
Review of Select Queries with Criteria
Logical Operators
Parameter Queries
Action Queries
Make Table Queries
Append Queries
Update Queries
Delete Queries
Creating Crosstab Queries
Delete a Query
Rename a Query
Exercise: Creating Select and Action Queries
Exercise: Creating a Parameter Query
Table Functions
Importing Data
Linking Tables from External Sources
Import Tables from other Databases
Tables from Templates and Application Parts
Exercise: Importing Data from Excel
Exercise: Exporting Data to Excel
Forms
Design View
Form Sections
Adding a Header and Footer
Adding a Logo to the Header
Adding a Title to the Header
Adding Fields to a Form
Arranging Fields on a Form
Spacing Objects on a Form
Formatting
Tab Order
Setting Properties on a Form
Controls
Create Forms with Application Parts
Creating a Subform
Exercise: Creating Forms
Alter a Form
Delete Forms
Remove Form Controls
Format a Form
Reports
Design View
Report Sections
Report Header
Page Header
Group Header
Detail
Group Footer
Page Footer
Report Footer
Adding a Report Header/Footer
Adding a Logo to the Report Header
Adding a Title to the Report Header
Adding Fields to a Report
Add Calculated Fields
Arranging Fields on a Report
Resizing the Detail Section
Eliminating Repeating Headings
Set Margins
Grouping and Sorting
Setting Properties on a Report
Report Property Sheet
Section Property Sheet
Object Property Sheet
Adding Record Counts
Special Report Fields
Dates
Page Numbering
Controls
Printing a Report
Subreports
Application Parts
Deleting a Report
Formatting a Report
Adding a Background and Images and Applying a Theme
Exercise: Creating Reports
Macros
Macro Basics
Open a Table, Form, and Report
Run a Query
Print a Report
Running a Macro
Exercise: Creating Simple Macros
Completing the Desktop Application
The Navigation Form
Running Macros from a Navigation Form
Setting the Navigation Form as the Default Form
Exercise: Creating a Navigation Form
Splitting the Database
Encrypt with a Password
Distributing the Front-End Database
Database Maintenance
Compact and Repair
Backup/Recover a Database
Maintain Backward Compatibility
Course Description: Print It | Download PDF | Email It