Microsoft Office Access 2007 in Business Core Comprehensive and Student Resource DVD

Chapter 1 - Introduction What is Access? Databases Business Decisions and Databases Creating a New Access Database Navigation Pane and Access Objects File Formats and Other Access Settings Access Help Using versus Creating Databases Chapter 2 - The Database Table Creating Tables Creating a New Table Field Names, Data Types, and Field Properties Indexing and Primary Keys Entering and Formatting Data Adjusting and Hiding Columns and Rows Copying and Pasting Data Sorting and Filtering Data Editing Tables Changing Data Types and Field Properties Changing the Sequence of Field Editing Data and Field Names Inserting Fields Deleting Fields and Records Importing and Linking Data Importing Data Linking Data Printing Tables Chapter 3 - Selecting and Summarizing Data from Tables Know Your Data Getting Started Single Field Primary Key Tables Multiple Field Primary Key Tables Fundamental Query Techniques (The Select Query) Creating a New Query Adding Fields and Adjusting Columns Query Name and Properties Defining Basic Criteria (OR AND) Formatting and Sorting Data Editing Queries Exporting Queries to Excel Advanced Queries Grouping Data Mathematical Summaries (Aggregate Functions) Nested Queries Crosstab Queries Chapter 4 - Applying Calculations to Data Formulas Custom Fields Calculated Fields The Expression Builder IIF Function Basic IIF Function Nested IIF Functions Financial Functions Future Value Payment Function Help with Functions Chapter 5 - Reports Fundamental Report Techniques Creating a New Report Setting the Dimensions of a Report Report Header Page Header Detail Page Footer Report Footer Advanced Report Techniques Grouping Data Sorting Data Calculated Fields Conditional Formatting Group and Report Totals Lines Dates Chapter 6 - Applying Core Competency Skills Using Multiple Tables in Queries Joining Tables Inner Joins Outer Joins Defining Table Relationships Comprehensive Access Project Selecting Tables Adding and Joining Tables in a Select Query Creating a Parameter Query Adding Calculations Constructing the Final Report Chapter 7 - Date, Text and Error Functions Date Functions Year Month Day Text functions Concatenate Len Left, Right, and Mid String Conversion Error Functions Is Error Is Null Chapter 8 - Advanced Techniques for Managing and Using Tables Managing Tables Through Queries Delete Query Append Query Make Table Query Duplicate records query Pivot Tables Chapter 9 - Forms Basic Forms Advance Forms Chapter 10 - Macro The Macro Window Basic Macro routines Appendix A - Access Utilities ODBC Connections Compacting Databases Security