Mastering Microsoft Access 2010 Made Easy Training Tutorial
3.7 (3 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.
43 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering Microsoft Access 2010 Made Easy Training Tutorial to your Wishlist.

Add to Wishlist

Mastering Microsoft Access 2010 Made Easy Training Tutorial

Learn Introductory through Advanced material with this complete Access course. Video lessons & manuals included.
3.7 (3 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.
43 students enrolled
Created by TeachUcomp, Inc.
Last updated 6/2013
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Video Lessons
  • Includes Three Classroom Instruction Manuals
  • Creating Relational Database Tables
  • Advanced Queries
  • Form & Report Controls
  • Reports
  • Charting Data
  • Macros
  • Much More!
View Curriculum
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 is the target audience?
  • Anyone wanting to learn Microsoft Access.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
105 Lectures
07:55:49
+
Getting Acquainted with Access
5 Lectures 12:48



Opening and Closing Databases
01:33

Database Objects
04:55
+
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
10 More Sections
About the Instructor
TeachUcomp, Inc.
4.1 Average rating
3,007 Reviews
105,768 Students
68 Courses
Quality Software Training

Founded in 2001, TeachUcomp, Inc. began as a licensed software training center in Holt, Michigan - providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.

At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.

In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 80 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.

Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use.

You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.