Mastering Microsoft Access 2010 Made Easy Training Tutorial
3.2 (4 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.
47 students enrolled

Mastering Microsoft Access 2010 Made Easy Training Tutorial

Learn Introductory through Advanced material with this complete Access course. Video lessons & manuals included.
3.2 (4 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.
47 students enrolled
Created by TeachUcomp, Inc.
Last updated 6/2013
English
English [Auto]
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 3 downloadable resources
  • 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
  • Video Lessons
  • Includes Three Classroom Instruction Manuals
  • Creating Relational Database Tables
  • Advanced Queries
  • Form & Report Controls
  • Reports
  • Charting Data
  • Macros
  • Much More!
Requirements
  • Access software recommended for practice.
Description

Learn Microsoft Access 2010 with this comprehensive course from TeachUcomp, Inc. Mastering Access Made Easy features 102 video lessons with over 8 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  You will learn all about relational databases, advanced queries, creating forms, reporting, macros and much more.

Whether you are completely new to Access or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch a video lesson or open one of the manuals and you’re on your way to mastering Access.

Who this course is for:
  • Anyone wanting to learn Microsoft Access.
Course content
Expand all 105 lectures 07:55:49
+ Creating Relational Database Tables
7 lectures 36:15
The "Flat-File" Model of Data Storage
06:18
The Relational Model of Data Storage
14:21
Tips for Creating a Relational Database
04:07
Creating Relational Database Tables
06:52
Assigning a Primary Key to a Table
02:09
+ Using Tables
7 lectures 10:15
Editing and Deleting Records in Datasheet View
01:34
Inserting New Fields
01:57
Renaming Fields
01:19
Deleting Fields
01:10
+ Field Properties
9 lectures 12:30
The 'Format' Property for Date/Time Fields
01:11
The 'Format' Property for Logical Fields
00:48
Setting Default Values for Fields
01:31
Setting Input Masks
01:55
Setting Up Validation Rules and Responses
02:48
Requiring Field Input
00:28
Allowing Zero Length Entries
00:35
+ Joining Tables
3 lectures 14:00
The Relationships Window
04:15
Enforcing Referential Integrity
05:18
Creating Lookup Fields
04:27
+ Indexing Tables
3 lectures 06:33
Indexes
03:02
Creating Indexes
02:34
Deleting Indexes
00:57
+ Queries
10 lectures 26:46
Using the Simple Query Wizard
04:15
Designing Queries
08:15
Joining Tables in a Query
02:03
Adding Criteria to the QBE Grid
01:00
Running A Query
01:02
How is Using the QBE Grid Writing SQL Code?
00:59
Sorting Query Results
01:56
Hiding Fields in a Query
00:59
Using Comparison Operators
02:31
Using 'AND' and 'OR' Conditions
03:46
+ Advanced Queries
6 lectures 14:05
Using the 'BETWEEN...AND' Condition
01:36
Using Wildcard Characters in Criteria
01:32
Creating a Calculated Field
02:40
Creating 'Top Value' Queries
02:05
Function Queries
02:24
Parameter Queries
03:48
+ Advanced Query Types
7 lectures 26:55
Make-Table Queries
03:18
Update Queries
05:02
Append Queries
04:14
Delete Queries
02:04
Crosstab Queries
03:30
The 'Find Duplicates' Query
05:36
The 'Find Unmatched' Query
03:11
+ Creating Forms
9 lectures 16:46
Forms Overview
01:08
The Form Wizard
02:17
Creating Forms
02:30
Using Forms
01:08
Form and Report Layout View
01:52
Form and Report Design View
01:59
Viewing the Ruler and Grid
01:20
The "Snap to Grid" Feature
01:18
Creating a Form in Design View
03:14