Microsoft Access 2013
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.
5 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2013 to your Wishlist.

Add to Wishlist

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.
5 students enrolled
Last updated 9/2013
English
Price: $50
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • New and experienced Microsoft Access 2013 users
  • New and experienced Microsoft and business systems administrators
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
3 More Sections
About the Instructor
VTC Software Training
3.9 Average rating
165 Reviews
2,383 Students
48 Courses
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.