New Perspectives on Microsoft Office Access 2007, Comprehensive - Video Companion DVD

by Adamski, Joseph J.; Finnegan, Kathy T.

• ISBN13: 9780538745093
• ISBN10: 0538745096
• Edition: DVD
• Format: Digital
• Copyright: 2009-07-10
• Publisher: Cengage Learning

Summary

Learn and retain the most challenging and important topics of Microsoft Office Access 2007 using a medium that you probably use daily: video! NEW PERSPECTIVES ON MICROSOFT OFFICE ACCESS 2007, COMPREHENSIVE, VIDEO COMPANION contains 45 illustrative videos between 5-7 minutes in length that go beyond simply showing how to complete tasks. Each video begins with a conceptual explanation and then is followed by a practical demonstration of that skill within the application. This video companion maps directly to the New Perspectives on Microsoft Office Access 2007, Comprehensive textbook.

Table of Contents

Creating a Database

Introduction to Database Concepts

Creating a Table in Datasheet View

Entering Records

Managing a Database

Building a Database and Defining Table Relationships

Guidelines for Setting Field Properties

Creating a Table in Design View

Specifying the Primary Key

Defining Table Relationships

Maintaining and Querying a Database

Introduction to Queries

Defining Record Selection Criteria for Queries

Defining Multiple Selection Criteria for Queries

Creating a Calculated Field

Creating Forms and Reports

Creating a Form Using the Form Wizard

Creating a Form with a Main Form and a Subform

Creating a Report Using the Report Wizard

Using Conditional Formatting in a Report

Creating Advanced Queries and Enhancing Table Design

Creating a Parameter Query

Creating a Crosstab Query

Creating a Lookup Field

Defining Data Validation Rules

Using Form Tools and Creating Custom Forms

Creating a Custom Form in Design View

Selecting, Moving, and Aligning Controls

Adding a Combo Box to a Form

Using Form Headers and Form Footers

Creating Custom Reports

Designing a Custom Report

Working with Controls in Design View

Adding the Date, Page Numbers, and a Title to a Report

Creating Mailing Labels

Sharing, Integrating, and Analyzing Data

Exporting an Access Query to an HTML Document

Integrating Access with Other Programs

Creating and Using a PivotTable

Using Action Queries and Advanced Table Relationships

Action Queries

Relationships Between Database Tables

Joining Tables

Automating Tasks with Macros

Adding Actions to a Macro

Creating a Macro.

Attaching a Macro to a Command Button

Creating a Switchboard

Using and Writing Visual Basic for Applications Code

Introduction to Visual Basic for Applications

Creating a Function

Creating an Event Procedure

Managing and Securing a Database

Analyzing Database Performance with the Performance Analyzer

Linking Tables and Using the Linked Table Manager

Using the Database Splitter

Securing an Access Database

Table of Contents provided by Publisher. All Rights Reserved.