Access 2007 Intermediate
4.5 (10 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.
128 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Access 2007 Intermediate

Expand your Access databases with queries, advanced report and form features and much more
4.5 (10 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.
128 students enrolled
Last updated 10/2016
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand relational database concepts
  • Effectively design and create tables
  • Perform calculations
  • Create multi-table, action and parameter queries
  • Work with advanced form functions and advanced report functions
View Curriculum
Requirements
  • Basic Microsoft Windows and Microsoft Access 2007 training or equivalent experience
Description

This course builds on the skills and concepts taught in Access 2007: Introduction. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

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
50 Lectures
03:25:30
+
Introduction
1 Lecture 01:30

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 01:30
+
Relational Database Concept Overview
3 Lectures 14:05

Enforcing Referential Integrity
07:16

Modifying and Deleting Relationships
04:14
+
Table Design
13 Lectures 27:28




Using Other Field Types
00:44

Setting Formats
03:11

Setting Input Masks
05:35

Adding Captions
01:35

Setting Default Values
02:04

Setting Validation Rules
02:40

Required Property
00:43

Indexed Property
02:17

Unicode Compression Property
01:42
+
Calculations
3 Lectures 17:13

Concatenating Text
09:18

Calculating Totals in a Query
06:33
+
Multi-Table Queries
6 Lectures 24:28


Grouping and Counting Totals
08:05

Referencing Calculated Fields in Another Query
04:43

Fixing WHERE Clause Errors
03:59

Calculating the Top Five Customers
01:10
+
Action Queries
4 Lectures 34:16

Using Make Table and Append Queries
12:12

Using Update Queries
14:19

Using Delete Queries
04:21
+
Parameter Queries
5 Lectures 17:03


Parameter Queries with Wildcards
05:38

Finding Date Ranges
04:27

Creating Multi-Parmeter Queries
01:58
+
Calculations in Forms
5 Lectures 21:42


Resizing Controls
01:36

Performing Calculations with Bound Text Boxes
03:41

Setting Control Properties
10:06
+
Advanced Form Functions
3 Lectures 16:08
Creating a Combo Box
09:33

Creating a Calculated Control
02:07

Adding Label and Formatting Contro
04:28
+
Advanced Report Functions
6 Lectures 28:59

Using a Calculated Control to Concatenate Text
06:28

Creating Other Calculated Controls
03:25

Making the Control Source a Parameter Query
09:29

Using Report Bands
02:28

Using the Group/Sort Panel
04:33
1 More Section
About the Instructor
Intellezy Trainers
4.4 Average rating
4,573 Reviews
26,743 Students
137 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.