Über dieses Produkt

Product Identifiers

PublisherPearson Education

ISBN-100789731525

ISBN-139780789731524

eBay Product ID (ePID)30775317

Product Key Features

Number of Pages384 Pages

Publication NameMicrosoft Access 2003 Forms, Reports, and Queries

LanguageEnglish

SubjectDesktop Applications / Databases, Databases / General

Publication Year2004

TypeTextbook

Subject AreaComputers

AuthorPaul Mcfedries

FormatTrade Paperback

Dimensions

Item Height0.7 in

Item Weight19 Oz

Item Length9.1 in

Item Width7.4 in

Additional Product Features

Intended AudienceScholarly & Professional

LCCN2004-095059

Dewey Edition22

IllustratedYes

Dewey Decimal005.74

Table Of ContentIntroduction. What''s in the Book. This Book''s Special Features. I. CREATING POWERFUL QUERIES 1. Creating a Basic Query. Sorting Records. Sorting on a Single Field. Sorting on Multiple Fields. Filtering Table Data. Filtering by Selection. Filter Excluding Selection. Filtering By Form. Learning About Filter Criteria. Creating a Filter. Working with Queries. Creating a Query. Creating a New Query Object. Selecting the Fields to Include in the Query. Entering the Query Criteria. Excluding a Field from the Query Results. Selecting Only the Top N Values. Setting Field Properties. Running the Query. Querying Notes for Business Users. Querying for a Mail Merge. Creating Queries with the Query Wizards. Creating Crosstab Queries Creating Find Duplicates Queries. Creating Find Unmatched Queries. Working with a Query Dynaset. Understanding the Datasheet View. Navigating Fields. Entering Data. Adding More Records. Navigating Records. Selecting a Record. Copying a Record. Deleting a Record. Formatting the Datasheet. Working with Query Properties. From Here. 2. Building Criteria Expressions. Using Operands in Criteria Expressions. Literals. Identifiers. Functions. Using Operators in Criteria Expressions. Comparison Operators. Arithmetic Operators. The Like Operator. The Between...And Operator. The In Operator. The Is Null Operator. Compound Criteria and the Logical Operators. Using the Logical Operators. Understanding Operator Precedence. Setting Up a Calculated Column. Calculating Inventory Value. Calculating Discounted Invoice Totals. Using the Built-In Functions. Using Text Functions. Using Date and Time Functions. Using Math Functions. Using Financial Functions. Working with the Expression Builder. From Here. 3. Working with Multiple-Table Queries. Relational Database Fundamentals. The Pitfalls of a Nonrelational Design. How a Relational Design Can Help. Step 1: Separate the Data. Step 2: Add Foreign Keys to the Tables. Step 3: Establish a Link Between the Related Tables. Types of Relational Models. The One-To-Many Model. The One-to-One Model. The Many-to-Many Model. Enforcing Referential Integrity. Establishing Table Relationships. Understanding Join Lines. Types of Joins. <p style="MARGIN: 0in 0in 0pt; LINE-HEIGHT

SynopsisWhen it comes to job-productivity, we all want to be able to perform well, especially when it comes to challenging assignments. Anyone who works with Microsoft Access on a regular basis knows that this program can prove to be one of the most challenging. If you are looking for a way to get the most you can out of the primary Access tasks, Microsoft Access 2003 Forms, Reports and Queries is the learning tool that you need. Focusing only on the forms, reports and queries functions, this book provides you with practical know-how, real-world examples and techniques that you can put to use immediately. Learn to condense mountains of information into manageable molehills of useful knowledge, so that you can perform at your best!, When it comes to job-productivity, we all want to be able to perform well, especially when it comes to challenging assignments. Anyone who works with Microsoft Access on a regular basis knows that this program can prove to be one of the most challenging. If you are looking for a way to get the most you can out of the primary Access tasks, Microsoft Access 2003 Forms, Reports and Queries is the learning tool that you need. Focusing only on the forms, reports and queries functions, this book provides you with practical know-how, real-world examples and techniques that you can put to use immediately. Learn to condense mountains of information into manageable molehills of useful knowledge, so that you can perform at your best, 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.

LC Classification NumberQA76.9.D3