Microsoft Access Microsoft Office Access 2007 Advanced

Microsoft Office Access 2007 Advanced

99.00 99.00
$99.00
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
This Package Contains Courses - See More
  • Course Delivery: On Demand
  • Language: English
  • Difficulty: Beginner
  • Audience: Microsoft Office Users

Chat Live | Contact Us | Toll Free: (888) 360-8764

 

Description

With its Microsoft Office Fluent user interface and interactive design capabilities that do not require deep database knowledge, Microsoft Office Access 2007 helps you track and report information with ease. Get started quickly with prebuilt applications that you can modify or adapt to changing business needs. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Share information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permissions, and back up your information at regular intervals.

Certification Exam

No Microsoft Certified Professional exams are associated with this course.

Audience:

This course is for anyone who wishes to learn Microsoft Access 2007.

 

Topics Covered

Part A

Course Introduction

  • Introduction to Course

Lesson 1 - Controlling Data Entry

  • Controlling Data Entry
  • Field Properties
  • Input Masks
  • Input Mask Wizard
  • Lookup List Fields
  • Lookup Wizard
  • Demo - Field Properties
  • Demo - Input Mask
  • Demo - Lookup Fields
  • Lesson 1 Review

Lesson 2 - Joining Tables

  • Joining Tables
  • Query Joins
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • The Join Properties Dialog Box
  • Self Joins
  • The Alias Property
  • Demo - Inner and Outer join
  • Demo - Join
  • Lesson 2 Review

Lesson 3 - Creating Flexible Queries

  • Creating Flexible Queries
  • Select Query Properties
  • Parameter Queries
  • The Like Operator and Wildcards
  • Common Wildcards
  • Other wildcards
  • Append Query
  • Action Queries
  • Update Query
  • Delete Query
  • Make Table Query
  • Demo - Query Properties
  • Demo - Parameter Queries
  • Demo - Action Query
  • Lesson 3 Review

Part B

Lesson 4 - Improving Forms

  • Improving Forms
  • Design Tools
  • Layouts
  • Types of Layouts
  • Control Padding – Narrow, Medium or Wide
  • Sort Data Within Forms
  • Anchor & Form Controls
  • Control Grouping and Ungrouping
  • Conditional Formatting
  • Control Wizards
  • Combo Box Control
  • List Box Control
  • Option Group Control
  • Command Buttons
  • Subforms
  • Demo - Modify Form
  • Demo - Sorting and Filtering
  • Demo - Format Form
  • Demo - Option Buttons
  • Demo - Subforms
  • Lesson 4 Review

Lesson 5 - Customizing Reports

  • Customizing Reports
  • Report Design
  • The Group, Sort and Total Pane
  • The Totals Feature
  • The Field List Pane
  • The Rich Text Support Feature
  • Report Pagination
  • Summarize Report Information
  • Subreports
  • Demo - Create a Report
  • Demo - Group Sort
  • Demo - Format Report
  • Demo - Pagination
  • Demo - Subreports
  • Lesson 5 Review

Lesson 6 - Sharing Data Across Applications

  • Sharing Data Across Applications
  • Options for Importing Data
  • Delimiters
  • Exporting Data
  • Mail Merge Task Pane
  • Demo - Import Excel
  • Demo - Import Export CSV File
  • Lesson 6 Review
  • Course Closure
 

Prerequisites

Basic computer proficiency and a familiarity with topics covered in our “Microsoft Access 2007 - Level 1 Training” course is required.

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.