Access 2010 - Intermediate

Duration
5 Hours, 19 Minutes

 

Delivery Method
Self-Paced

Educate 360 Pro from New Horizons

This class is part of a 12‑month Educate 360 Pro Subscription

Course Overview

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.

Course Objectives

Understanding Table Relationships, Introducing Advanced Table Design, Using Action Queries with Imported Data, Creating Calculated and Parameter Queries, Using Advanced Form Features, Advanced Report Functions

Course Prerequisites

There are no prerequisites for this course.

Agenda

1 - Introduction

  • Introduction

2 - Understanding Table Relationships

  • Understanding Table Relationships
  • The 1 to 1 Relationship
  • The 1 to Many Relationship
  • The Many to Many Relationship
  • Creating a 1 to 1 Relationship
  • Enforcing Referential Integrity
  • Creating a 1 to Many Relationship
  • Creating a Many to Many Relationship

3 - Introducing Advanced Table Design

  • Reviewing the Field Data Types
  • Setting the Format Property
  • Using the Input Mask Property
  • Setting Default Values and Validation Rules
  • Using the Required and Indexed Properties
  • Reviewing the Unicode Compression

4 - Using Action Queries with Imported Data

  • Importing vs. Linking External Data
  • Using the Delete Query
  • Using the Update Query
  • Using the Make Table Query
  • Using the Append Query

5 - Creating Calculated and Parameter Queries

  • Calculating Numbers
  • Calculating Totals and Using Group By
  • Concatenating Text
  • Creating Parameter Queries
  • Using Wildcards with Your Parameter Entry

6 - Using Advanced Form Features

  • Reviewing the Invisible Table
  • Removing a Single Control from the Table
  • Locking and Hiding a Control
  • Modifying the Layout
  • Adding an Unbound Control
  • Adding Calculated Controls
  • Adding a Combo Box Control
  • Changing a Control Type

7 - Advanced Report Functions

  • Using the Report Wizard
  • Reviewing the Report Bands
  • Manipulating Controls in a Report
  • Adding Parameters to a Report
  • Using a Parameter Query with a Report
  • Using the Group/Sort Panel

8 - Conclusion

  • Course Recap

What is Educate 360 Pro?

Educate 360 Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your Educate 360 Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of an Educate 360 Pro Subscription

Our Educate 360 Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about Educate 360 Pro.