Microsoft Office Access 2007 In Business, Core

 

 Access Core 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