1-800-THE-TREE (1-800-843-8733)
 

Access™ 2007: A Comprehensive Hands-On Introduction

 
Course: 970     Type: Hands-On Training     Duration: 4 Days

Quick Enroll    

You Will Learn How To
  • Utilize Microsoft Access 2007 to design robust database applications
  • Apply Form, Table, Report and Query wizards to quickly build database applications
  • Create and integrate macros into your applications
  • Quickly modify forms and reports with selective filtering, sorting and grouping
  • Implement advanced Access reporting features
  • Link to SharePoint and SQL Server data systems

Course Benefits
Databases form the core of an organization's information infrastructure. Microsoft Access 2007 is a powerful visual tool with which to design and develop database applications. This hands-on course provides experience with the features and functionality of Access 2007. You learn to develop and support robust Access systems, manipulate and query data, develop forms, design sophisticated data analysis reports, and upsize Excel spreadsheets.

Who Should Attend
Anyone who needs to manipulate, analyze or report on organizational data. Familiarity with databases or macros is helpful.

Hands-On Training
Throughout this course, you gain real-world experience building components of a database inventory system. Extensive hands-on exercises include:
  • Building a Microsoft Access database
  • Establishing indexes and data relationships
  • Implementing Form and Query wizards
  • Automating tasks with macros
  • Creating preformatted and custom reports
  • Developing complex Access reports
  • Limiting Query recordset results
  • Handling the On-No-Data event in reports

Course 970 Content
Microsoft Access 2007 Overview
Discovering the interface
  • Browsing by category in Help
  • Quick data functions in reports
  • Exploring the results-based ribbon
  • Categorizing with command groups
  • Changing the view to discover contextual tabs
  • Hiding and revealing the Navigation Pane
Overview of database concepts
  • Databases and their contents
  • Flat file and relational databases
  • Conforming Access to RDBMS standards
The fundamentals of database design
  • Tables, records and fields
  • Implementing database normalization
  • Ordering schemes
  • Indexes
  • Setting compound primary keys
Building a Relational Database with Access
Defining the requirements
  • Eliciting user needs and wants
  • Consolidating a design into a system specification
  • Designing the data model
Creating an Access database system
  • Selecting the best Access design style
  • Access tables, fields, indexes
  • Assigning proper field types
  • Table relationships
  • Modifying field functionality with properties
Integrating internal and external data
  • Customizing forms with the Layout View
  • Embedding forms within other forms
  • Attaching or importing existing tables
  • Designing a friendly user interface
  • Protecting data using layered validation
  • Form controls and properties
  • Picking controls in Layout and Design Views
Querying Relational Data
Query types and elements
  • Defining queries
  • Choosing fields in the Design View
  • Select, Action and Parameter queries
Developing queries
  • Query wizards
  • Expressions in queries
  • Refining data output with sorting and filtering
  • Displaying data from multiple tables
  • Creating calculated fields
Access Reports for Data Analysis
Implementing Report wizards
  • Generating quick reports
  • Stacked and tabular report formats
  • Visually enhancing your presentation with conditional formatting
  • Exploiting formulas and expressions in reports
  • Sorting out groups and totals
Modifying the standard report formats
  • Hiding data detail in summary reports
  • Elements of effective custom reports
  • Adjusting report controls
  • Changing group order and effects
  • Formulating values in expressions
  • Publishing to PDF and XPS formats
Task Automation with Macros
Designing effective macros
  • Point-and-click
  • Embedded macros
  • Macro style guidelines
  • Running a macro from events
  • Picking macro actions and arguments
Event-driven programming
  • Linking forms and reports
  • Associating macros with controls to respond to user-triggered events
  • Managing security through the Trust Center
  • Designing a custom Navigation Pane
Access as a Multiuser Front-End
Data separation in Access
  • Creating a non-data ACCDB
  • Strategically placing your data
  • Handling multiuser conflicts
Linking to SharePoint or SQL Server
  • The ODBC connectivity standard
  • Utilizing SharePoint and SQL Server data within Access

Related Courses
Access is a trademark of Microsoft Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save an EXTRA $200 on a 10-Day Training Pass!

Access™ 2007: A Comprehensive Hands-On Introduction
Upcoming Dates
Oct 7 - 10, 2008
 Washington, DC (Rockville, MD)
Oct 28 - 31, 2008
 Chicago (Schaumburg)
Nov 18 - 21, 2008
 Ottawa
Dec 9 - 12, 2008
 New York
Dec 9 - 12, 2008
 Toronto
Dec 16 - 19, 2008
 Washington, DC (Alexandria, VA)
Feb 17 - 20, 2009
 Washington, DC (Reston, VA)
Mar 17 - 20, 2009
 Ottawa
Apr 14 - 17, 2009
 Toronto
Apr 14 - 17, 2009
 Washington, DC (Alexandria, VA)

Access™ 2007: A Comprehensive Hands-On Introduction
Bring Learning Tree On-Site

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,580 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,385 Alumni Gold Discount
$ 2,360 Government Discount
 

 

Access™ 2007: A Comprehensive Hands-On Introduction
Access™ 2007: A Comprehensive Hands-On Introduction
Course participants using Access 2007 to analyze data and create aggregate reports.


Certification Core Course CPE 23 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733