The Fictioning Horror Sale
 
 

Recently Viewed clear list


Original Essays | September 18, 2014

Lin Enger: IMG Knowing vs. Knowing



On a hot July evening years ago, my Toyota Tercel overheated on a flat stretch of highway north of Cedar Rapids, Iowa. A steam geyser shot up from... Continue »
  1. $17.47 Sale Hardcover add to wish list

    The High Divide

    Lin Enger 9781616203757

spacer
Qualifying orders ship free.
$53.00
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
20 Partner Warehouse General- General

This title in other editions

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

by

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?

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

Product Details

ISBN:
9780131743410
Author:
Manzo, Joseph
Publisher:
Prentice Hall
Author:
Manzo, Joseph M.
Author:
Manzo, Joseph J.
Subject:
Database management
Subject:
Desktop Applications - MS Access
Subject:
Database Management - General
Subject:
Database design
Subject:
Personal Computers-Desktop Applications-Databases
Copyright:
Edition Description:
Trade paper
Series:
Core
Publication Date:
August 2007
Binding:
SPIRAL
Grade Level:
College/higher education:
Language:
English
Illustrations:
Y
Pages:
352
Dimensions:
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:
spacer
spacer
  • back to top
Follow us on...




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.