Microsoft Office Access 2007 In Business, Core

by Manzo, Joseph J.

• ISBN13: 9780131743410
• ISBN10: 0131743414
• Edition: 1st
• Format: Paperback
• Copyright: 2008-01-01
• Publisher: Prentice Hall

Summary

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/ecovers 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.

Table of Contents

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

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

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

Applying Calculations to Data Formulas

Custom Fields

Calculated Fields

The Expression Builder IIF Function

Basic IIF Function

Nested IIF Functions

Table of Contents provided by Publisher. All Rights Reserved.