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
     
 

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…  See more details below

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.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >