Microsoft Access 2013
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5 students enrolled

Microsoft Access 2013

Managing and Analyzing Big Data
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5 students enrolled
Last updated 9/2013
English
English [Auto-generated]
Price: $49.99
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Gain full understanding of Microsoft Access and the ability to use the software competently and productively.
  • Understand and utilize all the features and functions of Microsoft Access 2013
Requirements
  • Access to Microsoft Access 2013 recommended, but not required.
Description

Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. This title is a self-paced software training course delivered via pre-recorded video. We do not provide additional information outside of the posted content.

Who this course is for:
  • New and experienced Microsoft Access 2013 users
  • New and experienced Microsoft and business systems administrators
Course content
Expand all 89 lectures 06:55:09
+ Getting Started with Access 2013
8 lectures 37:13
Where to Start
04:39
Introducing Office 365
04:02
Access Database Objects
04:57
Installing Access 2013 pt. 1
04:29
Installing Access 2013 pt. 2
04:19
Creating a Database
05:24
Access Interface Tour
07:09
Database Backups
02:14
+ Working With Tables
15 lectures 01:14:01
Creating Our Database
05:02
Datasheet or Design
05:21
Creating Tables pt. 1
05:54
Creating Tables pt. 2
05:48
Data Types pt. 1
06:18
Data Types pt. 2
04:06
Editing Table Structures
04:30
Date/Time Formats pt. 1
04:09
Date/Time Formats pt. 2
05:04
Using Input Masks
04:54
Deleting Rows
03:00
Required Fields
04:06
Adding a Primary Key
06:26
Creating an Index
05:15
Deleting a Table
04:08
+ Access Relationships
7 lectures 34:19
Identifying Relationships
02:17
Design Meets Relationships
03:55
Creating a Relationship pt. 1
07:19
Creating a Relationship pt. 2
06:38
Creating a Relationship pt. 3
05:47
Managing Relationships
04:06
Viewing Object Dependencies
04:17
+ Data Retrieval
14 lectures 01:04:28
Understanding Queries
04:46
Access and SQL
06:30
Query Types
04:09
Creating Queries pt. 1
06:37
Creating Queries pt. 2
06:19
Make Table Queries
06:22
Understanding Join Queries
04:42
Union Queries
04:04
Top Queries
04:39
Distinct Queries
04:00
Query Filters
03:12
Append Queries
03:32
Delete Queries
03:15
Data Management Options
02:21
+ Data Forms and Reports
8 lectures 35:52
Understanding Forms
03:43
Why Use Forms
05:47
Using AutoForm
03:55
Using the Form Wizard
06:21
Forms from Scratch
05:24
Design or Layout
04:20
Working with Controls
03:10
Setting the Tab Order
03:12
+ Using External Data
5 lectures 19:26
Data Here and There
04:19
Exporting Data
04:24
Importing Data
03:20
Data Linking
04:02
Data Linking Example
03:21
+ Access Gets Friendly
3 lectures 16:34
What SharePoint Is
05:53
A Budding Relationship
06:25
Goodbye ADP
04:16