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

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.

Joseph J. Adamski spent 12 years as a computer professional at aerospace and financial services companies and is an Associate Professor Emeritus at Grand Valley State University. He has worked as a computer professional and educator for over 40 years with a special interest in database management and personal uses of databases. Kathleen Finnegan is a co-author on New Perspectives on Microsoft Access and has edited and managed many other textbooks on Microsoft applications for Cengage Learning's Course Technology. Kathleen taught various computer courses for corporate training and high-tech companies and developed courseware as a technical writer and editor.

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.