Microsoft Office Access 2007 In Business, Comprehensive

The content associated with the traditional text has moved to Pearson Custom Library (PCL). PCL allows customers to create customized textbooks, giving students a more engaging and affordable education. If you would like to purchase the full test without customization, please use ISBN: 0558895905. For more information about customization opportunities, refer to www.pearsoncustomlibrary.com.

Table of Contents:
  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