Mastering Microsoft Access 2010 Made Easy Training Tutorial

Learn Introductory through Advanced material with this complete Access course. Video lessons & manuals included.
3.0 (2 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.
36 students enrolled
$40
Take This Course
  • Lectures 105
  • Contents Video: 5 hours
    Other: 3 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 1/2013 English

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

What are the requirements?

  • Access software recommended for practice.

What am I going to get from this course?

  • Video Lessons
  • Includes Three Classroom Instruction Manuals
  • Creating Relational Database Tables
  • Advanced Queries
  • Form & Report Controls
  • Reports
  • Charting Data
  • Macros
  • Much More!

What is the target audience?

  • Anyone wanting to learn Microsoft Access.

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: Getting Acquainted with Access
The Access Interface
Preview
02:35
Overview of a Database
Preview
01:50
Working with Database Objects
Preview
01:55
Opening and Closing Databases
01:33
Database Objects
04:55
Section 2: Creating Relational Database Tables
Creating New Databases
Preview
01:27
Flow Overview of a Database
Preview
01:01
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
Section 3: Using Tables
Using Datasheet View
Preview
01:14
Navigating in Datasheet View
Preview
01:51
Adding Records in Database View
Preview
01:10
Editing and Deleting Records in Datasheet View
01:34
Inserting New Fields
01:57
Renaming Fields
01:19
Deleting Fields
01:10
Section 4: Field Properties
Setting Field Properties
Preview
01:34
The 'Field Size' Property
Preview
01:40
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
Section 5: Joining Tables
The Relationships Window
04:15
Enforcing Referential Integrity
05:18
Creating Lookup Fields
04:27
Section 6: Indexing Tables
Indexes
03:02
Creating Indexes
02:34
Deleting Indexes
00:57
Section 7: Queries
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
Section 8: Advanced Queries
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
Section 9: Advanced Query Types
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
Section 10: Creating Forms
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
Section 11: Form and Report Controls
Selecting Controls
02:31
Deleting Controls
00:43
Moving and Resizing Controls
04:30
Sizing Controls 'To Fit'
01:08
'Nudging' Controls
00:33
Aligning, Spacing and Sizing Controls
02:58
Formatting Controls
02:38
Viewing Control Properties
01:21
Section 12: Using Controls
The Controls Group
01:49
Adding Label Controls
01:49
Adding Logos and Image Controls
02:21
Adding Line and Rectangle Controls
01:11
Adding Combo Box Controls
02:46
Adding List Box Controls
02:31
Setting Tab Order
02:03
Section 13: Subforms
Creating Subforms
03:44
Using the Subform/Subreport Control
01:50
Section 14: Reports
Using the Report Wizards
01:50
Using Basic Reports
00:56
Creating a Report in Design View
06:41

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

TeachUcomp, Inc., 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.

Ready to start learning?
Take This Course