The Ultimate Microsoft Access 2010 And 2013 Training Bundle

The Most Convenient Way to Boost Your Confidence And Learn MS Access Inside And Out—Quickly, No Travel or Classes.

What you'll learn

Essential training for Microsoft Access 2010

Essential training for Microsoft Access 2013

Advanced training for Microsoft Access 2010

Advanced training for Microsoft Access 2013

Requirements

Microsoft Access 2010 and Microsoft Access 2013

Description

In today’s workplace, data management skills are absolutely crucial, and Microsoft Access is the most widely available software for the job. Whether you need to use Access 2010 or 2013, our Ultimate Microsoft Access Training Bundle has got you covered. Starting with the absolute basics, these courses will take you to the level of total data mastery in both editions of the program, as you work through both beginners and advanced courses.
If you need to manage data at all in your job, or are looking for a promotion to a role where you do, then you can’t afford to give this a miss.
This bundle includes:
35 hours of video tutorials Over 150 individual video lectures 4 quizzes with 170 test questions Certificate of completionPrintable course transcriptions to follow along and take notes
Courses included with this bundle:
Learn Microsoft Access 2013
Starting with the basics, our certified instructor will teach you to add and delete records to your database. Then, learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Build forms to capture information online. Implement pre-designed templates that track project, employee, issue, or task details. Protect databases with permissions. Run reports that provide valuable business intelligence. And walk away with a solid grasp of how tie it all together with this Microsoft Access Training. Includes exercise files.
Learn Microsoft Access 2013 - Advanced
Your professional trainer will show you how to use macros, tables, forms, queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources. Get helpful techniques that allow you to link, report, and package your data quickly, and find out how to split a database by splitting the frontend and backend.
With this informative course, you’ll learn the skills you need to make an impact with sleek, high-performing databases that help you do your job better. Includes exercise files.
Learn Microsoft Access 2010
Discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier.
Each chapter builds on the previous one, walking you through topics on tables and their attributes, structures, and field properties. Forms are presented to make information gathering and input a breeze. Learn data analysis using functions, formulas, expression builder, conditional formatting, sorting, filtering, and queries. Discover practical techniques for improving designs, adding existing fields, and grouping/sorting—as your instructor gives you easy to understand methods for working with reports.
Learn Microsoft Access 2010 - Advanced
Beyond just getting data into the database, you will be taught to create both form and function. Discover how to create switchboards, autoexec functions, macros, creative reports, custom buttons, deep custom queries for detailed data analysis, and reports that shine—in terms of how they look on paper and the data they provide. Additionally, you will learn best practices to employ during initial design and creation steps. These will help you minimize headaches as the database design evolves, and enable mass distribution as the amount of data and number of users increases.
Where else can you find so many extra tools to help you master Access?
What people are saying:
"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
- TopTenReviews
"Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!"
- Lisa R., France.
Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.
** Updated June 2017. Course transcripts now available.

Overview

Section 1: Learn Microsoft Access 2013 Beginner Course

Lecture 1 Acquiring Access 2013; Course Overview

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Access 2013 Exercise Files

Lecture 4 Downloadable Course Transcript

Lecture 5 What's New in Access 2013

Lecture 6 Using Touch

Lecture 7 Database Templates; Creating, Opening and Saving Databases

Lecture 8 Workspace and Backstage View

Lecture 9 Online, Offline, and Contextual Help

Lecture 10 Finding Keyboard Shortcuts and Key Tips

Lecture 11 Customizing the Settings and Use of Access 2013

Lecture 12 The Ribbon

Lecture 13 Quick Access Toolbar

Lecture 14 Customizing the Status Bar

Lecture 15 Overview of the Main Features of Access Database

Lecture 16 Web App Basics

Lecture 17 Creating Tables - Part 1

Lecture 18 Creating Tables - Part 2

Lecture 19 Relationship between Tables - Part 1

Lecture 20 Relationships Between Tables - Part 2

Lecture 21 Inserting and Formatting Fields; Field Validation; Navigation Buttons

Lecture 22 Sorting, Filtering and Finding Data

Lecture 23 Entering Data; Changing the Order of Columns, Field Width and Height

Lecture 24 Design View; Field Properties

Lecture 25 Saving Data; Data Types, Attachments and Field Size

Lecture 26 Input Masks; More on Field Properties

Lecture 27 Creating Forms; Form Wizard

Lecture 28 Single Forms; Insert, Delete, Modify, Sort and Filter Records

Lecture 29 Layout View; Adding Existing Fields

Lecture 30 Design View; Arranging Fields

Lecture 31 Controls

Lecture 32 Form Design

Lecture 33 Query Design

Lecture 34 Joins and Query Wizard

Lecture 35 Query Types

Lecture 36 Operators and Expressions - Part 1

Lecture 37 Operators and Expressions - Part 2

Lecture 38 Operators and Expressions - Part 3

Lecture 39 Subforms

Lecture 40 Report Wizard; Previewing a Report

Lecture 41 Report Design

Lecture 42 Grouped and Summary Reports; Modifying a Report

Lecture 43 Adding Subreports

Lecture 44 Documenter; Print Properties and Options

Lecture 45 Import and Append; Copy and Paste; Export Access Database

Lecture 46 Database Templates and Application Parts

Lecture 47 Navigation Form

Lecture 48 Modal Dialogs - Part 1

Lecture 49 Modal Dialogs - Part 2

Lecture 50 Modal Dialogs - Part 3

Lecture 51 Actions; Example of VBA; Creating AutoExec Macro

Lecture 52 More Access Options

Lecture 53 Info Tab

Lecture 54 Trust Center

Lecture 55 Updates; Closing

Section 2: Learn Microsoft Access 2013 Advanced Training Course

Lecture 56 Prerequisites and Basic Knowledge of Access 2013

Lecture 57 WATCH ME: Essential Information for a Successful Training Experience

Lecture 58 Access 2013 Advanced Exercise Files

Lecture 59 Indexes and Introduction to the Movies Database

Lecture 60 Basics in Working with Datasheet View

Lecture 61 Controlling the Display and Advanced Sorting and Filtering in Datasheet View

Lecture 62 Linking to Other Access Database Tables

Lecture 63 How to Install SQL Server Express

Lecture 64 Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server

Lecture 65 Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end

Lecture 66 Consequences of the Split; Moving a Database; Adding a Trusted Location

Lecture 67 Access Options relating to Multi-user Issues; Record Locking

Lecture 68 Basics of Macros and Properties of Macro Editor

Lecture 69 Examples of Macros; Autoexec

Lecture 70 More Autoexec

Lecture 71 Macro Security

Lecture 72 Customizing the Quick Access Toolbar and the Ribbon

Lecture 73 Convert Macro to VBA; VBA Editor

Lecture 74 Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes

Lecture 75 Modules, Subs, Options Explicit, and Variables

Lecture 76 Scope of Variables

Lecture 77 Branch and Loop

Lecture 78 Customizing Events

Lecture 79 Responding to Events and Developing Error Handles

Lecture 80 More on Events

Lecture 81 Getting Help with Events

Lecture 82 Basics of Forms: Review and Tips and Tricks

Lecture 83 Advanced Features of Forms - Part 1

Lecture 84 Advanced Features of Forms - Part 2

Lecture 85 Advanced Features of Forms - Part 3

Lecture 86 Advanced Features of Forms - Part 4

Lecture 87 Basics of Queries: Review

Lecture 88 Main Features and Syntax of SQL Statements

Lecture 89 Use of Multiple Criteria of a Where Clause

Lecture 90 How Joins Look in SQL Statements and using Query Grids

Lecture 91 Update Query

Lecture 92 Delete and Make Table Queries

Lecture 93 Append Query

Lecture 94 Protecting your Database and Codes

Lecture 95 Making your Database More User-Friendly

Lecture 96 Setting up an Access Web App

Lecture 97 Building Basic Web Apps

Lecture 98 Closing

Section 3: Learn Microsoft Access 2010 Beginner Course

Lecture 99 Intro to Backstage View, Ribbon, Quick Access Toolbar & Options

Lecture 100 READ ME: Essential Information for a Successful Training Experience

Lecture 101 Downloadable Course Transcripts

Lecture 102 Start/Exit, Help Features, Shortcuts, Views, Templates

Lecture 103 Course Review

Lecture 104 Understanding Database Components

Lecture 105 Introduction to Design of a Database

Lecture 106 Introduction to Building a Database

Lecture 107 Creating Tables & Basic Setup of Relationships

Lecture 108 Using Quick Parts to Setup New Table, Importing Spreadsheet

Lecture 109 Entering Data Types into Tables

Lecture 110 Changing Table Attributes, Copy, Rename, Delete Records

Lecture 111 Table Structures

Lecture 112 Table and Field Properties

Lecture 113 Auto-Create Forms, Filtering & Searching

Lecture 114 Types of Different Forms & Creating New

Lecture 115 Improve Look, Style, & Feel of Forms

Lecture 116 Adding Fields to Existing Form

Lecture 117 Understanding and Setting Up the Expression Builder

Lecture 118 Format Control on Forms/Reports

Lecture 119 Sorting Single & Multiple Columns; Filter One Field Data Records

Lecture 120 Sorting & Filtering Data in Form View; Find & Replace in Forms

Lecture 121 Understanding Reports & Structure

Lecture 122 Creating Reports; Using Print Preview to Check Report Outcome

Lecture 123 Advanced Reporting; Formatting Reports

Lecture 124 How to Improve Report Design, Add Existing Fields; Group/Sort

Lecture 125 Select Queries; Sorting; Defined Criteria

Lecture 126 Change Fields wthin Query; Specifying Criteria for Numbers/Text

Lecture 127 Update Queries; Append Queries; Delete Queries

Lecture 128 Inner/Outer Joins; Make Table Queries; Mail Merge

Lecture 129 Securing Database and Views; New Features

Section 4: Learn Microsoft Access 2010 Advanced Course

Lecture 130 Introduction to Advanced Access 2010

Lecture 131 READ ME: Essential Information for a Successful Training Experience

Lecture 132 Downloadable Course Transcripts

Lecture 133 Working with Macros

Lecture 134 AutoExec Macro

Lecture 135 Database Options

Lecture 136 More Database Options

Lecture 137 Renaming Database Objects

Lecture 138 Basics & Understanding Data Types

Lecture 139 Table and Field Properties

Lecture 140 Validation Rules & Text

Lecture 141 Understanding & Using Keys and Indexes

Lecture 142 Data Normalization

Lecture 143 Types of Relationships

Lecture 144 Maintaining Relationships

Lecture 145 Using & Understanding Queries

Lecture 146 Complex Queries

Lecture 147 Creating Queries and Using Join & Sub-Queries

Lecture 148 Datasheet View

Lecture 149 Creating & Working with Forms

Lecture 150 Using Forms to Maintain Data

Lecture 151 Command Buttons

Lecture 152 Command Buttons Part 2

Lecture 153 Form Features that Need VBA Code

Lecture 154 Understanding When & How to Use VBA

Lecture 155 More about VBA and Using It to Improve Database

Lecture 156 VBA Language Structure & Making a Switchboard

Lecture 157 Error Handling

Lecture 158 Cleaning Up Before Distribution

Lecture 159 Security Techniques

Lecture 160 External Data & Importng/Exporting Data

Lecture 161 Linking to Excel & Linking to Another Database

Lecture 162 Separating/Splitting Up Forms, Reports, etc from Database

Lecture 163 Options for Making Changes When Database is Multi-User

Lecture 164 Advanced Features for Reports

Lecture 165 Advanced Features for Reports Part 2

Lecture 166 Distributing Application

Anyone new to Microsoft Access 2010 or Access 2013, or upgrading from previous versions of Microsoft Access