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

The In Business system is the only series that prepares you expressly for your core business classes such as Accounting, Economics, Marketing, Finance and Business Statistics by doing the following: exposing you to real business files that meet professional standards; providing a useful reference to be used in your business classes; instructing how to use the software as a tool to accomplish business goals; coverage of the core Office skills that you will need in your business courses. In Business includes tools that will benefit any style of learning. Whether you need to reference specific skills for another course or understand how to utilize Microsoft Office to complete your business objectives, In Business will allow you to apply these skills directly to your own education and career aspirations.

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