New Perspectives on Microsoft Office Access 2007, Comprehensive - Video Companion DVD / Edition 1by Joseph J. Adamski, Kathy T. Finnegan
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
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
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.
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >