The Ultimate Microsoft Access 2013 Training Bundle 19 Hours

The Most Convenient Way to Boost Your Confidence And Learn MS Access 2013 Inside And Out—Quickly, No Travel or Classes.
4.4 (201 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
6,090 students enrolled
$175
Take This Course
  • Lectures 97
  • Contents Video: 19.5 hours
    Other: 1 min
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2013 English

Course Description

Get An Advanced Understanding of the Many Access 2013 Features That Will Enable You to Gather and Interpret Data Faster.

  • Sorting Information and Running Queries
  • Creating Tables and Relationships
  • Designing Forms (+ Advanced Form Options)
  • Generating Reports
  • Splitting the Frontend and Backend
  • Macros
  • Visual Basic for Applications (VBA)

Learn to Capture and Synthesize Information, Becoming a Data Management Guru.

Being a data rock star is more important than ever. To stand out in the workplace, it's essential to be able to find information fast and to identify game-changing insights.

The Microsoft Access 2013 database can help you store and track a variety of information, such as inventory, contacts, or business processes. Logistically, it combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools, and is a member of the Microsoft Office suite of applications, included in the Professional and higher editions, or sold separately.

It is a tool that spans across many fields and is helpful to anyone needing to tightly organize varied data: office managers, project managers, executive assistants, scientists, and busy families to list a few.

Contents and Overview

Through 96 lectures, 19 hours of quality content, and 2 quizzes, this 19-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources.

Budding Access 2013 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence.

Practice files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application.

This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills.

Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately.

What are the requirements?

  • Microsoft Access 2013

What am I going to get from this course?

  • Sorting information and running queries
  • Practice with exercise files that are included with both courses
  • Safeguards and restrictions
  • Creating tables and relationships
  • Navigating the Access 2013 interface
  • Designing forms
  • How to use queries
  • Generating reports
  • Discover how to effectively link to other data sources
  • Learn how to split a database by splitting the frontend and backend
  • Find out about the use of macros
  • Explore the use of Visual Basic for Applications (VBA)
  • Discover advanced options for the use of forms
  • Dive into options for packaging your application for distribution

What is the target audience?

  • Anyone new to Microsoft Access

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Access 2013: Introduction
Acquiring Access 2013; Course Overview
Preview
14:32
IMPORTANT - Read this to ensure the best video quality!
Article
What's New in Access 2013
Preview
09:26
Section 2: Access 2013: Using Touch
Using Touch
05:53
Section 3: Access 2013: Getting Started
Database Templates; Creating, Opening and Saving Databases
11:26
Access 2013 Exercise Files
Article
Workspace and Backstage View
10:31
Section 4: Access 2013: Help
Online, Offline, and Contextual Help
05:49
Section 5: Access 2013: Keyboard Shortcuts and Key Tips
Finding Keyboard Shortcuts and Key Tips
05:57
Section 6: Access 2013: Access Options
Customizing the Settings and Use of Access 2013
Preview
11:23
Section 7: Access 2013: The Ribbon and Toolbars
The Ribbon
Preview
11:22
Quick Access Toolbar
04:49
Section 8: Access 2013: Status Bar
Customizing the Status Bar
03:42
Section 9: Access 2013: Database Basics
Overview of the Main Features of Access Database
16:43
Web App Basics
10:42
Section 10: Access 2013: Tables
Creating Tables - Part 1
Preview
15:29
Creating Tables - Part 2
14:46
Relationships Between Tables - Part 1
14:32
Relationships Between Tables - Part 2
08:38
Section 11: Access 2013: Datasheet View
Inserting and Formatting Fields; Field Validation; Navigation Buttons
12:19
Sorting, Filtering and Finding Data
13:21
Entering Data; Changing the Order of Columns, Field Width and Height
08:00
Section 12: Access 2013: Table Design
Design View; Field Properties
13:36
Saving Data; Data Types, Attachments and Field Size
14:06
Input Masks; More on Field Properties
15:06
Section 13: Access 2013: Forms
Creating Forms; Form Wizard
Preview
14:36
Single Forms; Insert, Delete, Modify, Sort and Filter Records
12:35
Layout View; Adding Existing Fields
15:55
Design View; Arranging Fields
16:27
Controls
14:06
Form Design
13:25
Section 14: Access 2013: Queries
Query Design
Preview
15:30
Joins and Query Wizard
15:03
Query Types
13:51
Operators and Expressions - Part 1
12:00
Operators and Expressions - Part 2
07:32
Operators and Expressions - Part 3
15:04
Subforms
12:32
Section 15: Access 2013: Reports
Report Wizard; Previewing a Report
Preview
09:41
Report Design
13:57
Grouped and Summary Reports; Modifying a Report
15:27
Adding Subreports
11:40
Section 16: Access 2013: Printing
Documenter; Print Properties and Options
09:20
Section 17: Access 2013: Importing and Exporting Data
Import and Append; Copy and Paste; Export Access Database
13:45
Section 18: Access 2013: Templates and Application Parts
Database Templates and Application Parts
14:21
Section 19: Access 2013: More on Forms
Navigation Form
Preview
10:45
Modal Dialogs - Part 1
11:52
Modal Dialogs - Part 2
13:33
Modal Dialogs - Part 3
09:39
Section 20: Access 2013: Macros and VBA
Actions; Example of VBA; Creating AutoExec Macro
15:25
Section 21: Access 2013: Additional Topics
More Access Options
08:45
Info Tab
11:49
Section 22: Access 2013: Security
Trust Center
12:58
Section 23: Access 2013: Conclusion
Updates; Closing
02:22
Access 2013 Quiz
50 questions
Section 24: Access 2013 Advanced: Introduction
Course Review
00:43
Pre-requisites and Basic Knowledge of Access 2013
09:10
Access 2013 Advanced Exercise Files
Article
Section 25: Access 2013 Advanced: Indexes
Indexes and Introduction to the Movies Database
Preview
14:36
Section 26: Access 2013 Advanced: Datasheet View
Basics in Working with Datasheet View
Preview
10:29
Controlling the Display and Advanced Sorting and Filtering in Datasheet View
15:21
Section 27: Access 2013 Advanced: Linking Access Databases
Linking to Other Access Database Tables
14:41
Section 28: Access 2013 Advanced: ODBC and SQL Server
How to Install SQL Server Express
14:49
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
16:50
Section 29: Access 2013 Advanced: Splitting an Access Database
Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
15:19
Consequences of the Split; Moving a Database; Adding a Trusted Location
16:07
Section 30: Access 2013 Advanced: Multi-user Aspects
Access Options relating to Multi-user Issues; Record Locking
14:58
Section 31: Access 2013 Advanced: Macros
Basics of Macros and Properties of Macro Editor
Preview
14:24
Examples of Macros; Autoexec
14:29

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Software training to help you succeed

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course