Microsoft Office Access 2007 In Business, Core and Resource DVD Package / Edition 1 by Joseph J. Manzo | 9780137133451 | Other Format | Barnes & Noble
Microsoft Office Access 2007 In Business, Core and Resource DVD Package / Edition 1

Microsoft Office Access 2007 In Business, Core and Resource DVD Package / Edition 1

by Joseph J. Manzo
     
 

ISBN-10: 0137133456

ISBN-13: 9780137133451

Pub. Date: 09/03/2007

Publisher: Prentice Hall

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

Overview

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.

Microsoft Office Access 2007 In Business, Core, 1/e covers the following topics: introduction to Access; database tables; selecting and summarizing data from tables; applying calculations to data; reports; and applying core competencies.

Ideal for business students and professionals.

Product Details

ISBN-13:
9780137133451
Publisher:
Prentice Hall
Publication date:
09/03/2007
Edition description:
New Edition
Product dimensions:
8.80(w) x 10.90(h) x 0.80(d)

Table of Contents

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >