Microsoft Office Access 2007 In Business, Comprehensive

 

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