Access 2007 Intermediate

Expand your Access databases with queries, advanced report and form features and much more
4.5 (7 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.
91 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 50
  • Length 3.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 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.

What are the requirements?

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

What am I going to get from this course?

  • 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

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

Section 2: Relational Database Concept Overview
Understanding Relationships
Preview
02:35
Enforcing Referential Integrity
07:16
Modifying and Deleting Relationships
04:14
Section 3: Table Design
Field Components
Preview
02:00
Accessing Field Properties
Preview
00:54
Using Text-Based Field Types
Preview
01:02
Using Numeric Field Types
Preview
03:01
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
Section 4: Calculations
Performing Calculations with Queries
Preview
01:22
Concatenating Text
09:18
Calculating Totals in a Query
06:33
Section 5: Multi-Table Queries
Understanding Multi-Table Queries
Preview
01:27
Creating a Multi-Table Query
Preview
05:04
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
Section 6: Action Queries
Understanding Action Queries
Preview
03:24
Using Make Table and Append Queries
12:12
Using Update Queries
14:19
Using Delete Queries
04:21
Section 7: Parameter Queries
Understanding Parameter Queries
Preview
00:58
A Simple Parameter Query
Preview
04:02
Parameter Queries with Wildcards
05:38
Finding Date Ranges
04:27
Creating Multi-Parmeter Queries
01:58
Section 8: Calculations in Forms
Understanding Forms
Preview
04:51
Understanding the Hidden Table
Preview
01:28
Resizing Controls
01:36
Performing Calculations with Bound Text Boxes
03:41
Setting Control Properties
10:06
Section 9: Advanced Form Functions
Creating a Combo Box
09:33
Creating a Calculated Control
02:07
Adding Label and Formatting Contro
04:28
Section 10: Advanced Report Functions
Using the Report Wizard
Preview
02:36
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
Section 11: Conclusion
Conclusion
02:38

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