Microsoft Office Access 2007 Forms, Reports, and Queries

3.33 avg rating
( 12 ratings by Goodreads )
 
9780789736697: Microsoft Office Access 2007 Forms, Reports, and Queries
View all copies of this ISBN edition:
 
 

“Everything you need to master Access 2007 forms, reports, and queries.”

–Charles Carr, Reviews Editor, ComputorEdge Magazine

 

Create Forms for Business

Ensure Data Entry Accuracy

Build Elegant Form Interfaces

Collect Data Via Email

Design Effective Business Reports

Make an Invoice Report

Create Mailing Labels

Extract Data

Work with Multiple Tables

Calculate Discounts

Analyze Data

 

Develop your Microsoft Access expertise instantly with proven techniques

 

Let’s face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database.  Without a more sophisticated knowledge of how to extract and present that data, you’re 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 you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.

·        Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.

·        Avoids database theory in favor of practical know-how that you can put to use right away.

·        Packed full of real-world examples and techniques to help you learn and understand the importance of each section.

·        Covers what’s new and changed in Microsoft Access 2007.

 

Introduction

Part I: Creating Forms

Chapter 1         Creating and Using a Form

Chapter 2         Working with Form Controls

Chapter 3         Designing Forms for Efficient and Accurate Data Entry

Chapter 4         Designing Forms for Business Use

Chapter 5         Creating Specialized Forms

Part II: Designing and Customizing Reports

Chapter 6         Creating and Publishing a Report

Chapter 7         Designing Effective Business Reports

Chapter 8         Designing Advanced Reports

Chapter 9         Creating Specialized Reports

Part III: Creating Powerful Queries

Chapter 10       Creating a Basic Query

Chapter 11       Building Criteria Expressions

Chapter 12       Working with Multiple-Table Queries

Chapter 13       Creating Advanced Queries

Chapter 14       Creating PivotTable Queries

Chapter 15       Querying with SQL Statements

Index

"synopsis" may belong to another edition of this title.

About the Author:

Paul McFedries is the president of Logophilia Limited, a technical writing company. Now primarily a writer, Paul is well known as a teacher of Microsoft Office and Microsoft Windows, and has worked as a programmer, consultant, database developer, and website developer. He has written more than 50 books that have sold more than three million copies worldwide. These books include Tricks of the Microsoft Office 2007 Gurus (Que, 2007), Formulas and Functions with Microsoft Excel 2007 (Que, 2007), VBA for the 2007 Microsoft Office System (Que, 2007), and Windows Vista Unleashed (Sams, 2006).

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Paul McFedries
Published by Pearson Education (2007)
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Pearson Education, 2007. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9780789736697

More information about this seller | Contact this seller

Buy New
US$ 26.88
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

2.

McFedries, Paul
Published by Que 5/1/2007 (2007)
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Paperback or Softback Quantity Available: 10
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Que 5/1/2007, 2007. Paperback or Softback. Condition: New. Microsoft Office Access 2007 Forms, Reports, and Queries. Book. Seller Inventory # BBS-9780789736697

More information about this seller | Contact this seller

Buy New
US$ 33.82
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

3.

McFedries, Paul
Published by Que Publishing
ISBN 10: 0789736691 ISBN 13: 9780789736697
New PAPERBACK Quantity Available: 15
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)
Rating
[?]

Book Description Que Publishing. PAPERBACK. Condition: New. 0789736691 Brand New Direct from the Publisher! Not overstocks or marked up remainders! Ships in a sturdy cardboard container with tracking!. Seller Inventory # OTF-9780789736697

More information about this seller | Contact this seller

Buy New
US$ 29.91
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

4.

Paul McFedries
Published by Pearson Education (US), United States (2007)
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Paperback Quantity Available: 1
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2007. Paperback. Condition: New. 2nd ed.. Language: English. Brand new Book. "Everything you need to master Access 2007 forms, reports, and queries."-Charles Carr, Reviews Editor, ComputorEdge Magazine Create Forms for BusinessEnsure Data Entry AccuracyBuild Elegant Form InterfacesCollect Data Via EmailDesign Effective Business ReportsMake an Invoice ReportCreate Mailing LabelsExtract DataWork with Multiple TablesCalculate DiscountsAnalyze Data Develop your Microsoft Access expertise instantly with proven techniques Let's face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you're 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 you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.* Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.* Avoids database theory in favor of practical know-how that you can put to use right away.* Packed full of real-world examples and techniques to help you learn and understand the importance of each section.* Covers what's new and changed in Microsoft Access 2007. Introduction Part I: Creating Forms Chapter 1 Creating and Using a Form Chapter 2 Working with Form Controls Chapter 3 Designing Forms for Efficient and Accurate Data Entry Chapter 4 Designing Forms for Business Use Chapter 5 Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6 Creating and Publishing a Report Chapter 7 Designing Effective Business Reports Chapter 8 Designing Advanced Reports Chapter 9 Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10 Creating a Basic Query Chapter 11 Building Criteria Expressions Chapter 12 Working with Multiple-Table Queries Chapter 13 Creating Advanced Queries Chapter 14 Creating PivotTable Queries Chapter 15 Querying with SQL Statements Index. Seller Inventory # BZV9780789736697

More information about this seller | Contact this seller

Buy New
US$ 38.02
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

5.

Paul McFedries
Published by Pearson Education (US), United States (2007)
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Paperback Quantity Available: 10
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2007. Paperback. Condition: New. 2nd ed.. Language: English. Brand new Book. "Everything you need to master Access 2007 forms, reports, and queries."-Charles Carr, Reviews Editor, ComputorEdge Magazine Create Forms for BusinessEnsure Data Entry AccuracyBuild Elegant Form InterfacesCollect Data Via EmailDesign Effective Business ReportsMake an Invoice ReportCreate Mailing LabelsExtract DataWork with Multiple TablesCalculate DiscountsAnalyze Data Develop your Microsoft Access expertise instantly with proven techniques Let's face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you're 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 you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.* Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.* Avoids database theory in favor of practical know-how that you can put to use right away.* Packed full of real-world examples and techniques to help you learn and understand the importance of each section.* Covers what's new and changed in Microsoft Access 2007. Introduction Part I: Creating Forms Chapter 1 Creating and Using a Form Chapter 2 Working with Form Controls Chapter 3 Designing Forms for Efficient and Accurate Data Entry Chapter 4 Designing Forms for Business Use Chapter 5 Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6 Creating and Publishing a Report Chapter 7 Designing Effective Business Reports Chapter 8 Designing Advanced Reports Chapter 9 Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10 Creating a Basic Query Chapter 11 Building Criteria Expressions Chapter 12 Working with Multiple-Table Queries Chapter 13 Creating Advanced Queries Chapter 14 Creating PivotTable Queries Chapter 15 Querying with SQL Statements Index. Seller Inventory # APC9780789736697

More information about this seller | Contact this seller

Buy New
US$ 39.47
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

Paul McFedries
Published by Que Publishing
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description Que Publishing. Paperback. Condition: New. 408 pages. Dimensions: 8.9in. x 6.9in. x 1.1in.Everything you need to master Access 2007 forms, reports, and queries. Charles Carr, Reviews Editor, ComputorEdge Magazine Create Forms for Business Ensure Data Entry Accuracy Build Elegant Form Interfaces Collect Data Via Email Design Effective Business Reports Make an Invoice Report Create Mailing Labels Extract Data Work with Multiple Tables Calculate Discounts Analyze Data Develop your Microsoft Access expertise instantly with proven techniques Lets face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, youre 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 you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power. Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries. Avoids database theory in favor of practical know-how that you can put to use right away. Packed full of real-world examples and techniques to help you learn and understand the importance of each section. Covers whats new and changed in Microsoft Access 2007. Introduction Part I: Creating Forms Chapter 1 Creating and Using a Form Chapter 2 Working with Form Controls Chapter 3 Designing Forms for Efficient and Accurate Data Entry Chapter 4 Designing Forms for Business Use Chapter 5 Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6 Creating and Publishing a Report Chapter 7 Designing Effective Business Reports Chapter 8 Designing Advanced Reports Chapter 9 Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10 Creating a Basic Query Chapter 11 Building Criteria Expressions Chapter 12 Working with Multiple-Table Queries Chapter 13 Creating Advanced Queries Chapter 14 Creating PivotTable Queries Chapter 15 Querying with SQL Statements Index This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9780789736697

More information about this seller | Contact this seller

Buy New
US$ 39.96
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

7.

Paul McFedries
Published by Pearson Education (US), United States (2007)
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Paperback Quantity Available: 1
Seller:
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2007. Paperback. Condition: New. 2nd ed.. Language: English. Brand new Book. "Everything you need to master Access 2007 forms, reports, and queries."-Charles Carr, Reviews Editor, ComputorEdge Magazine Create Forms for BusinessEnsure Data Entry AccuracyBuild Elegant Form InterfacesCollect Data Via EmailDesign Effective Business ReportsMake an Invoice ReportCreate Mailing LabelsExtract DataWork with Multiple TablesCalculate DiscountsAnalyze Data Develop your Microsoft Access expertise instantly with proven techniques Let's face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you're 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 you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.* Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.* Avoids database theory in favor of practical know-how that you can put to use right away.* Packed full of real-world examples and techniques to help you learn and understand the importance of each section.* Covers what's new and changed in Microsoft Access 2007. Introduction Part I: Creating Forms Chapter 1 Creating and Using a Form Chapter 2 Working with Form Controls Chapter 3 Designing Forms for Efficient and Accurate Data Entry Chapter 4 Designing Forms for Business Use Chapter 5 Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6 Creating and Publishing a Report Chapter 7 Designing Effective Business Reports Chapter 8 Designing Advanced Reports Chapter 9 Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10 Creating a Basic Query Chapter 11 Building Criteria Expressions Chapter 12 Working with Multiple-Table Queries Chapter 13 Creating Advanced Queries Chapter 14 Creating PivotTable Queries Chapter 15 Querying with SQL Statements Index. Seller Inventory # BZV9780789736697

More information about this seller | Contact this seller

Buy New
US$ 41.86
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

8.

Paul McFedries
Published by Que Publishing (2007)
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Que Publishing, 2007. Paperback. Condition: New. 2nd. Seller Inventory # DADAX0789736691

More information about this seller | Contact this seller

Buy New
US$ 38.90
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

9.

McFedries, Paul
Published by Pearson Education (2007)
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Pearson Education, 2007. PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9780789736697

More information about this seller | Contact this seller

Buy New
US$ 31.22
Convert currency

Add to Basket

Shipping: US$ 11.77
From United Kingdom to U.S.A.
Destination, rates & speeds

10.

Paul McFedries
Published by Que Publishing (2007)
ISBN 10: 0789736691 ISBN 13: 9780789736697
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Que Publishing, 2007. Condition: New. book. Seller Inventory # M0789736691

More information about this seller | Contact this seller

Buy New
US$ 42.04
Convert currency

Add to Basket

Shipping: US$ 3.27
Within U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book