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

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

by Joseph J. Adamski, Kathy T. Finnegan
     
 

View All Available Formats & Editions

ISBN-10: 0538745096

ISBN-13: 9780538745093

Pub. Date: 07/10/2009

Publisher: Cengage Learning


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

Overview


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.

Product Details

ISBN-13:
9780538745093
Publisher:
Cengage Learning
Publication date:
07/10/2009
Series:
New Perspectives Series
Edition description:
New Edition
Product dimensions:
4.80(w) x 7.60(h) x 0.20(d)

Table of Contents

Tutorial 1: Creating a Database. Introduction to Database Concepts. Creating a Table in Datasheet View. Entering Records. Managing a Database. Tutorial 2: 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. Tutorial 3: Maintaining and Querying a Database. Introduction to Queries. Defining Record Selection Criteria for Queries. Defining Multiple Selection Criteria for Queries. Creating a Calculated Field. Tutorial 4: 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. Tutorial 5: Creating Advanced Queries and Enhancing Table Design. Creating a Parameter Query. Creating a Crosstab Query. Creating a Lookup Field. Defining Data Validation Rules. Tutorial 6: 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. Tutorial 7: 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. Tutorial 8: Sharing, Integrating, and Analyzing Data. Exporting an Access Query to an HTML Document. Integrating Access with Other Programs. Creating and Using a PivotTable. Tutorial 9: Using Action Queries and Advanced Table Relationships. Action Queries. Relationships Between Database Tables. Joining Tables. Tutorial 10: Automating Tasks with Macros. Adding Actions to a Macro. Creating a Macro. Attaching a Macro to a Command Button. Creating a Switchboard. Tutorial 11: Using and Writing Visual Basic for Applications Code. Introduction to Visual Basic for Applications. Creating a Function. Creating an Event Procedure. Tutorial 12: 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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >