Microsoft Access 2003 : forms, reports, and queries

Format:

Book

Author/Creator:

McFedries, Paul, Author.

Contributor:

Safari Tech Books Online.

Series:

Business solutions.

Business solutions Microsoft Access 2003

Language:

English

Subjects (All):

Database management.

Microsoft Access.

Physical Description:

1 online resource (385 pages)

Other Title:

Microsoft Access 2003

Place of Publication:

[Place of publication not identified] Que 2005

Language Note:

English

Summary:

Microsoft Access is a large, intimidating program. Unlike Word or Excel where users can perform basic tasks without much in the way of training, Access presents challenges from the outset. Most users never progress beyond creating simple tables and using Wizards to create basic forms and reports. At the same time, all users - from managers to researchers to administrative assistants - need to know that what they seek is embedded somewhere in their Access tables. Without a more sophisticated knowledge of how to extract and present that data, they are forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.This book changes all that by giving readers the skills required to etract the data they need (queries), build efficient front-ends for that data (forms), and publish the results in an attractive and easy-to-read format (reports). To that end, this book shuns the big Access picture and instead focuses intently on queries, forms, and reports. This in-depth approach will give the reader the skills and understanding he or she needs to get at the data and prove the old adage that knowledge is indeed power.

Contents:

Intro

Table of Contents

PART I Crea ting Powerful Queries

Creating a Basic Query

Building Criteria Expressions

Working with Multiple- Table Queries

Creating Advanced Queries

Creating PivotTable Queries

Querying with SQL Statements

PART II Creating Forms

Creating and Using a Form

Working with Form Controls

Designing Forms for Efficient and Accurate Data Entry

Designing Forms for Business Use

Creating Specialized Forms

PART III Designing and Customizing

Creating and Publishing a Report

Designing Effective Business Reports

Designing Advanced Reports

Creating Specialized Reports

INDEX.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on publisher supplied metadata and other sources.

ISBN:

9786610862603

9781280862601

1280862602

9780768663020

0768663024

OCLC:

1027148857

Publisher Number:

9786610862603