Access 2010 Intermediate

Expand your Access databases with queries, advanced report and form features and much more
4.6 (11 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.
202 students enrolled
$30
Take This Course
  • Lectures 40
  • Contents Video: 5.5 hours
  • Skill Level Intermediate Level
  • 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 4/2013 English

Course Description

This course goes into more detail on how to make the database objects more interactive within Microsoft Access 2010. Starting with an explanation of the different table relationships and setting advanced properties within a Table, this course shows you how to effectively use the tools within Microsoft Access to verify data as it gets entered into the database. Additionally, this course shows you how to import an Excel spreadsheet and use the different Action Queries to create a relational database. Finally, the course shows how to create interactive forms and reports by adding calculated controls.

What are the requirements?

  • Basic Microsoft Windows and Microsoft Access 2010 training or equivalent experience

What am I going to get from this course?

  • Understand table relationships
  • Design advanced tables
  • Use action queries with imported data
  • Create and use calculated and parameter queries
  • Use advanced form features
  • Create and use advanced report functions

What is the target audience?

  • Students who are familiar with creating basic databases looking to better understand table relationships, learn advanced table design, create queries and use advanced form and report features

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: Introduction
03:07

If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.  

Section 2: Understanding Table Relationships
Understanding Table Relationships
Preview
01:40
The 1 to 1 Relationship
Preview
02:55
The 1 to Many Relationship
Preview
01:42
The Many to Many Relationship
02:35
Creating a 1 to 1 Relationship
03:16
Enforcing Referential Integrity
17:41
Creating a 1 to Many Relationship
03:48
Creating a Many to Many Relationship
07:35
Section 3: Introducing Advanced Table Design
Reviewing the Field Data Types
13:03
Setting the Format Property
15:44
Using the Input Mask Property
11:24
Setting Default Values and Validation Rules
11:01
Using the Required and Indexed Properties
10:29
Reviewing the Unicode Compression Property
04:04
Section 4: Using Action Queries with Imported Data
Importing vs. Linking External Data
10:51
Using the Delete Query
06:58
Using the Update Query
08:09
Using the Make Table Query
18:29
Using the Append Query
30:45
Section 5: Creating Calculated and Parameter Queries
Calculating Numbers
Preview
06:20
Calculating Totals and Using Group By
06:15
Concatenating Text
10:59
Creating Parameter Queries
08:11
Using Wildcards with Your Parameter Entry
08:39
Section 6: Using Advanced Form Features
Reviewing the Invisible Table
Preview
06:56
Removing a Single Control from the Table
01:46
Locking and Hiding a Control
04:02
Modifying the Layout
03:31
Adding an Unbound Control
04:39
Adding Calculated Controls
07:52
Adding a Combo Box Control
15:37
Changing a Control Type
04:17
Section 7: Advanced Report Functions
Using the Report Wizard
07:14
Reviewing the Report Bands
02:37
Manipulating Controls in a Report
08:22
Adding Parameters to a Report
01:59
Using a Parameter Query with a Report
08:50
Using the Group/Sort Panel
12:08
Section 8: Conclusion
Conclusion
03:29

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Ready to start learning?
Take This Course