Microsoft Access 2013

Managing and Analyzing Big Data
0.0 (0 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.
4 students enrolled
$50
Take This Course
  • Lectures 89
  • Length 7 hours
  • 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 10/2013 English

Course 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.

What are the requirements?

  • Access to Microsoft Access 2013 recommended, but not required.

What am I going to get from this course?

  • 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

What is the target audience?

  • New and experienced Microsoft Access 2013 users
  • New and experienced Microsoft and business systems administrators

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: Welcome
Introduction
Preview
01:31
Course Overview
Preview
03:52
What Access Is
Preview
04:49
New in 2013
Preview
03:58
Access Grows Up
Preview
05:54
The Future of Access
Preview
05:39
Access Alternatives
Preview
05:51
Section 2: Database 101
What a Database Is
Preview
03:58
Database Types
Preview
05:10
Database Organization
Preview
04:31
Understanding Tables
Preview
04:13
Understanding Data Types pt. 1
Preview
04:31
Understanding Data Types pt. 2
Preview
06:14
Primary Key Basics
Preview
04:30
Understanding Indexes pt. 1
Preview
05:07
Understanding Indexes pt. 2
Preview
05:23
Section 3: Database Design 101
Database Design Options
Preview
04:27
Understanding Normalization
Preview
04:42
Understanding Relationships
Preview
03:53
Relationship Types pt. 1
Preview
04:32
Relationship Types pt. 2
Preview
04:44
Understanding Integrity
Preview
04:08
Section 4: Getting Started with Access 2013
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
Section 5: Working With Tables
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
Section 6: Access Relationships
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
Section 7: Data Retrieval
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
Section 8: Data Forms and Reports
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
Section 9: Using External Data
Data Here and There
04:19
Exporting Data
04:24
Importing Data
03:20
Data Linking
04:02
Data Linking Example
03:21
Section 10: Access Gets Friendly
What SharePoint Is
05:53
A Budding Relationship
06:25
Goodbye ADP
04:16
Section 11: Access and the Web
Understanding Web Apps
06:02
SharePoint Foundation 2013
04:25
SharePoint System Requirements
03:07
Getting Setup for Web Apps
05:22
Creating a Web App
04:44
Section 12: Conclusion
Course Wrap Up
05:20

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

VTC Software Training, Affordable, Comprehensive Software Training

VTC is one of the world's leading producers of online computer and software training, supplying richly diverse courses of informative and inspiring tutorials. Created on the idea that anyone should have the ability to learn to use computer software on their own time, VTC has produced tens of thousands of hours of extraordinarily valuable, insightful, and easy to follow tutorials and delivers them for a fraction of the cost of other training methods. Our training authors are some of the most accomplished in their respective fields. The tutorials that could make the difference in your new job, promotion, or school advancement are always available and only a click away.

Ready to start learning?
Take This Course