Poetry Madness

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | March 26, 2015

    Kyle Boelte: IMG Selfies, Memoir, and the World Beyond the Self

    When I was a teenager in Colorado during the late '90s, I liked to climb 14ers — 14,000-foot mountains. I'd often hike with friends, and at... Continue »

Qualifying orders ship free.
List price: $78.60
Used Spiral
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Partner Warehouse General- General

This title in other editions

Microsoft Access 2007 in Business -core Text (08 Edition)


Microsoft  Access 2007 in Business -core Text (08 Edition) Cover


Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

Publisher Comments:

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.

Table of Contents

 Access Core Table of Contents



Chapter 1      Introduction

What is Access?


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


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  


Page Footer

Report Footer

Advanced Report Techniques

Grouping Data

Sorting Data

Calculated Fields

Conditional Formatting

Group and Report Totals




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

Product Details

Manzo, Joseph
Prentice Hall
Manzo, Joseph M.
Manzo, Joseph J.
Database management
Desktop Applications - MS Access
Database Management - General
Database design
Personal Computers-Desktop Applications-Databases
Edition Description:
Trade paper
Publication Date:
August 2007
Grade Level:
College/higher education:
10.9 x 8.8 x 0.8 in 830 gr

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Personal Computers » Desktop Applications » Databases
Computers and Internet » Software Engineering » Software Management
Textbooks » General

Microsoft Access 2007 in Business -core Text (08 Edition) Used Spiral
0 stars - 0 reviews
$53.00 In Stock
Product details 352 pages Prentice Hall - English 9780131743410 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.