Access 2010 Intermediate
4.7 (23 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.
255 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access 2010 Intermediate to your Wishlist.

Add to Wishlist

Access 2010 Intermediate

Expand your Access databases with queries, advanced report and form features and much more
4.7 (23 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.
255 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Basic Microsoft Windows and Microsoft Access 2010 training or equivalent experience
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
40 Lectures
05:18:53
+
Introduction
1 Lecture 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.  

Preview 03:07
+
Understanding Table Relationships
8 Lectures 41:11



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
+
Introducing Advanced Table Design
6 Lectures 01:05:44
Reviewing the Field Data Types
13:02

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
+
Using Action Queries with Imported Data
5 Lectures 01:15:12
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
+
Creating Calculated and Parameter Queries
5 Lectures 40:23

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
+
Using Advanced Form Features
8 Lectures 48:39

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
+
Advanced Report Functions
6 Lectures 41:08
Using the Report Wizard
07:13

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:07
+
Conclusion
1 Lecture 03:29
Conclusion
03:29
About the Instructor
Intellezy Trainers
4.4 Average rating
3,678 Reviews
23,624 Students
135 Courses
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.