Microsoft Access Access 2016 Ultimate

Access 2016 Ultimate

30.00 30.00
$30.00
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
This Package Contains Courses - See More
  • Course Delivery: On Demand
  • Duration: 20 
  • Language: English
  • Difficulty: Advanced
  • Audience: Microsoft Access 2016 users

Chat Live | Contact Us | Toll Free: (888) 360-8764

e-learning Tutorials: designed as a learning experience, not just "watch someone do it".

In a (good) live class, teachers talk about why you would want to do something, real-world applications, and hidden power-tips. Good teachers also review to tell you what the important points to remember are. So why are these things almost always missing in video learning? We don't just show. We teach!

Our videos are designed for you to follow along in real life.

When you take a class, the teacher explains concepts, shows you how, reviews the important points, and asks you to try it yourself, right?  That's how our videos work. They even pause themselves while you give your new skills a whirl.

We teach more than just button pushing; Also learn skills, theories, and ideas!

Have you ever watched a video tutorial online? They just showed you something and left you to figure out the practical application, right? Not us! We want you to really learn.

Practice assignments to help with retention

When you learn something new, you have to practice, right? Sometimes new students are at a loss for what they should do to build retention. That's why we have practice assignments, to advise you what to try by yourself. It's like homework that you'll like! Plus, you don't have to turn it in.
 

Description

Access is a database creation and management program. It helps you design, build, and interface with a robust database to help your organization run smoothly. Many small to medium-sized businesses use Access for this exact purpose.

This course starts with database basics, terms, and information you’ll need to confidently build your database later on. Then, you’ll learn how to build tables, determine relationships, query data, and create simple-to-use interfaces that other people at your company can use to interact with your data.

Audience

Access is designed for people who are comfortable with spreadsheet programs like Excel. These users need more power and analyzation, as well as a stronger forward-facing interface.

The Following Courses Are Included In This Package:

Course Name Industry Course Delivery
Access 2016 Advanced II - Part 2 IT and Software Skills SCORM
Access 2016 Beginner - Part 1 IT and Software Skills SCORM
Access 2016 Advanced - Part 2 IT and Software Skills SCORM
Access 2016 Intermediate - Part 1 IT and Software Skills SCORM
Access 2016 Beginner - Part 2 IT and Software Skills SCORM
Access 2016 Advanced II - Part 1 IT and Software Skills SCORM
Access 2016 Advanced - Part 1 IT and Software Skills SCORM
Access 2016 Intermediate - Part 2 IT and Software Skills SCORM
 

Topics Covered

Beginner

  • Opening a Sample Database
  • The Database Objects
  • The Interface
  • Introducing Tables
  • Simple Data Entry
  • Introducing Queries
  • Practicing Data Entry in Queries
  • Introducing Forms
  • Data Entry into Forms
  • Introducing Reports
  • Sorting to Create Groups
  • Finding Data in Tables
  • Filtering
  • Adding Total Rows
  • Creating Tables in Design View
  • Entering Your First Record
  • Starting a New Database
  • Using Quick Starts to Create Tables
  • Entering Data into Your Second Table
  • Introduction
  • Looking at the First Draft of a Database
  • Creating Relationships with Lookup Lists
  • The Relationships Window
  • Relating by Dragging Field Names
  • Dragging to Create 1-to-1 Relationships
  • Changing Dragged Relationships to Lookup Relationships
  • Limit-To-List Properties
  • Enforced Referential Integrity
  • Seeing the Referential Integrity Being Enforced
  • Cascade Edits and Deletions
  • More Field Properties

Intermediate

  • Introduction
  • Showing File Name Extensions
  • Opening Query.mdb
  • Updating File Formats and Showing Document Tabs
  • Hiding Table Fields
  • Unhiding Table Fields
  • Creating and Running Queries
  • Sorting the Query
  • More Ways to Select Views
  • Filtering Using OR
  • Filtering Using AND
  • Combining AND with OR
  • Filtering Using NOT and NULL
  • Multi-Table Queries
  • Wild Card Symbols
  • Calculations
  • Concatenating Words
  • Parameter Queries
  • Introduction
  • Multiplying and Aggregating
  • Subtotals via a Totals-Query
  • Crosstab-Query
  • Make-Table Query
  • Delete-Query
  • Update-Query
  • Append-Query
  • Exporting to PDF
  • Exporting to Word-RTF
  • Exporting to Excel
  • Importing from Excel
  • Linking to Excel
  • Linking from Access to Access
  • Lookup List in a Query

Advanced

  • Introduction
  • Turning Your Database Folder into a Trusted Location
  • Filtering by Form
  • Columnar Form Views - Part 1
  • Columnar Form Views - Part 2
  • Tabular Forms
  • Split Forms
  • Justified Forms - Part 1
  • Justified Forms - Part 2
  • Form Sections
  • Adding Graphic Elements
  • Hand-Built Forms
  • Creating Forms from the Query
  • Building Forms from the Query
  • Tracing Dependencies from Form to Query to Table
  • Multi-Page Tabbed Forms
  • Parent and Child Forms - Method 1
  • Parent and Child Forms - Method 2
  • Parent and Child Forms - Method 3
  • Form Wizard's Datasheet Layout
  • Wrapping Up
  • Introduction
  • Viewing Reports - Part 1
  • Viewing Reports - Part 2
  • Views Available for Reports
  • Modifying Your First Report
  • The Form Wizard
  • Sorting in Your Report
  • Grouping in Your Report - Part 1
  • Grouping in Your Report - Part 2
  • Creating Summary Reports via the Wizard
  • Modifying Summary Reports
  • Special Case of CAN GROW
  • Adding a ROLODEX Effect
  • Mailing Labels

Advanced II

  • Introduction
  • Free-Floating Parent and Child Forms
  • Starting Your First Macro
  • Adding Actions to Your First Macro
  • Three Ways to Trigger Macros
  • Creating Command Buttons Without the Wizard
  • Joining Forms by a Shared Field
  • Parent Form Size and Position
  • Child Form Size and Position
  • If-THEN and IN-List
  • Creating Combo-Boxes by Typing Entries
  • Combo-Boxes from Imported Tables
  • SETVALUE and GOTOCONTROL
  • Introduction to VBA
  • SELECT CASE Example in VBA
  • Debugging Simple Macros
  • Radio Buttons in VBA
  • Wrapping Up
  • Introduction
  • Compacting and Repairing Databases
  • Hyperlinks in Tables
  • Hyperlinks from Pictures in Forms
  • Switchboard Using Command Buttons
  • Read-Only Form Buttons
  • Switchboard Manager Method
  • Navigation Forms as Switchboards
  • Record Locking
  • Startup Options
  • Special Keys
  • Wrapping Up
  • Summary

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.