Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2010 Tutorial - Learn At Your Own Pace to your Wishlist.

Add to Wishlist

Microsoft Access 2010 Tutorial - Learn At Your Own Pace

A practical Microsoft Access 2010 tutorial that allows you to learn at your own pace using hands-on lessons.
4.5 (165 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,890 students enrolled
Published 5/2012
English
$15 $50 70% off
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description
A Verifiable Certificate of Completion is presented to all students who undertake this course.

This Microsoft Access 2010 training course offers a ground-up guide to form and database creation and management with this powerful office productivity tool. Narrated by teacher, author and technology trainer Robert Tucker, this beginner friendly course begins with the very basics and gradually builds to a level of professional proficiency every users should know. Starting with the user interface, the hands-on training takes you through the creation of a single table, then moves to field types and properties, creating input forms, generating reports, and all the associated functions you would expect to know in a business environment. As you move through the video tutorial, Robert even begins to cover some advanced features such as Crosstab Queries, importing data from multiple sources, join queries, and more. By the end of the MS Access course, you will be fully versed in the creation and use of Microsoft Access databases, and know how to get quickly get your data in and out.


What You Will Learn

- How to create professional quality user forms, databases and reports with one of the world's leading office productivity tools.
- How to manipulate and implement data and data sources across a wide range of projects.
- How to create secure, compatible databases that can be accessed by users working with Office products and common industry standards.

Who Should Take This Course

- Anyone who has used Microsoft Access in the past but wanted a better understanding of its full range of features.
- Anyone who needs an understanding of Microsoft Access software as it applies to a professional work or academic environment.
- Anyone new to MS Access wanting a user-friendly guide that introduces the program from the ground up.


What People Are Saying

"Probably the one program in the Office suite that was a little intimidating is now in reach. We're integrating our office's appointment system, and with these tutorials it's going great."
- Angela Card

"Beginners should not be afraid...I was nervous that this course might be too technical but the author is very direct and his examples are very easy to follow along with."
- Roy Metzger

Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 112 Lectures Collapse All 112 Lectures 09:43:20
+
Getting Started
9 Lectures 42:43


The New File Menu In Access 2010
09:24

Making The Most Of The Navigation Pane
07:12

Customize The Quick Access Toolbar
04:28

Enable Content Using A Trusted Location
03:32

Choose Between Tabbed Or Overlapping Windows
04:26

Using The Files Included With This Course
01:53

What Will I Be Able To Do At The End Of This Course
03:27
+
Database Theory And Design
5 Lectures 23:22
What Constitutes A Database
03:46

The Components That Make Up A Database
02:18

Why Do We Need A Relational Database Like Access
07:02

Creating A Database Using The Database Wizards
06:45

Create A Database WITHOUT The Wizard (Recommended)
03:31
+
Tables
15 Lectures 01:34:36
Designing Then Creating A Single Table Database
06:47

Using The Correct Data Types
07:07

Managing The Each Fields Properties
14:10

Adding Lookup Options To A Field
05:01

Adding An Input Mask To Safeguard Data Entry
04:09

Adding A Validation Rule To Safeguard Data Entry
04:02

The New Calculated Field In Access 2010
07:45

The Primary Key
05:53

Entering Data Into A Table
08:12

Sorting Data In A Table
04:16

Deleting Records From A Table
03:44

Editing Records In A Table
04:58

Finding Records In A Table
04:28

Find And Replace Field Values
05:46

Filtering Table Data
08:18
+
Queries
18 Lectures 01:23:07
What Is A Query
04:28

Creating Saving And Running A New Query
06:28

CAREFUL Editing Data In A Query
02:12

Changing The Design Of A Query
03:29

Add Criteria To A Text Field To Filter Records
04:24

Filtering A Query On A Number Field
04:40

Using Date Filters In A Query
05:25

Boolean Fields In Querying
03:41

Adding Wildcards To Query Criteria
07:04

Retrieving Empty Values With A Query (NULL)
04:07

Selecting Using Different Criteria On The Same Field (OR)
03:35

Selecting Using Different Criteria On Different Fields (AND)
03:54

Sorting The Results Of A Query
03:38

Hiding Filtering Columns From A Query Result
02:07

Evaluating Calculations With Queries
04:40

Working Out The Current Age Of Contacts
05:01

Produce Totals Using An Access Query
08:37

Finding Duplicate Records With A Query
05:37
+
Forms
15 Lectures 01:07:02
Creating A Form Using The Wizard
05:56

Column Or Tabular Forms - Which To Choose
02:54

Viewing And Editing Records Through A Form
03:16

Adding Records Through Forms And Associated Problems
04:11

Searching For Records In Forms
04:18

Deleting A Record In A Form
01:59

Sorting Records
02:47

Applying Filters Within Forms
05:03

Modifying The Design Of A Form
07:58

Adding Fields Not Currently Displayed
04:02

Aligning And Spacing Form Controls
04:44

Amending The Tab Order
03:43

Add Logos And Images
03:38

Adding Todays Date
03:47

Calculating Fields In Forms
08:46
+
Reports
7 Lectures 39:13
Creating A Basic Report Using The Wizard
06:30

Grouped Reports Through The Wizard
07:42

Basing A Report On A Query
05:09

The Quick Report Tool
04:03

Editing The Layout Of A Wizard Generated Report
07:39

Printing Reports
02:59

Creating A PDF From A Report
05:11
+
Multiple Table Databases
9 Lectures 43:19
How To Create A Multi Table Database
06:56

Creating Links Between Tables
06:24

What Is The Foreign Key
01:18

Removing Or Editing A Relationship
02:59

Referential Integrity
05:50

Viewing And Editing Data In A Sub Datasheet
04:21

Creating A Query That Extracts Data From More Than One Table At A Time
07:44

Create A Form Based On A Multi Table Query
02:46

Generating A Report Based On More Than One Table
05:01
+
Database Normalization
2 Lectures 09:03
What Is Normalization
03:19

Normalizing The Sample Database
05:44
+
Advanced Tables
8 Lectures 40:51
Importing Data Into Access From Excel
06:42

Importing Data Into Access From Access
02:59

Importing Data Into Access From Text Files
04:21

Converting An Access 2010 Database To A Previous Version
03:29

Making Use Of Lookups In Tables
06:59

Why Do I Need To Index Fields In Tables
08:25

Multiple Field Primary Keys
04:34

Printing The Relationship Diagram
03:22
+
Advanced Select Queries
5 Lectures 31:38
Using More Than One Table To Feed A Query
05:05

Changing The Join Type Of Links In Queries
05:57

Watch Out For The Cartesian Join
04:23

Parameter Queries
07:44

Introducing The Crosstab Query
08:29
5 More Sections
About the Instructor
4.4 Average rating
33,778 Reviews
664,935 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Report Abuse