skip to content
Microsoft Office Access 2007 : forms, reports, and queries Preview this item
ClosePreview this item

Microsoft Office Access 2007 : forms, reports, and queries

Author: Paul McFedries
Publisher: Indianapolis, Ind. : Que Pub., 2007.
Series: Business solutions.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Offers guidelines for using Access 2007 queries, forms, and reports, utilizing a practical rather than a theoretical approach that is designed to give readers the ability to extract essential data, build efficient front-end forms for that data, and publish the results in an easy-to-read format.

(not yet rated) 0 with reviews - Be the first.

More like this


Find a copy online

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Genre/Form: Electronic books
Additional Physical Format: Print version:
McFedries, Paul.
Microsoft Office Access 2007 forms, reports, and queries.
Indianapolis, Ind. : Que, ©2007
(DLC) 2007010362
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Paul McFedries
ISBN: 9780789736697 0789736691 9780132714105 0132714108
OCLC Number: 123904838
Description: 1 online resource.
Contents: ContentsIntroduction 1What's in the Book 2This Bookis Special Features 2The Examples Used in the Book 3 I CREATING FORMS1 Creating and Using a Form 7Building a Basic Form 9Building a Standard Form 9Building a Split Form 11Building a Multiple Items Form 11Creating Simple Forms with the Form Wizard 12Navigating a Form 14Creating a Form in Design View 15Displaying the Design View 15Changing the Record Source 15Understanding Form Controls 16Adding Fields to the Form 17Changing the Size of the Form 18Viewing the Form 18Assigning an AutoFormat in Design View 19Working with Form Properties 20Working with the Form Header and Footer 20Adding a Logo 22Adding a Title 23Formatting the Background 23Creating a Form Interactively in Layout View 25Case Study: Protecting the Form and Data from Other Users 26From Here 272 Working with Form Controls 29Manipulating Form Controls 29Inserting Controls on a Form 30Selecting Controls 30Formatting Controls 31Adding Conditional Formatting 31Sizing Controls 33Moving Controls 34Creating a Control Layout 36Working with Control Margins 38Grouping Controls 38Ordering Overlapped Controls 39Converting an Unbound Control to a Bound Control 39Changing a Controlis Type 40Setting the Tab Order 40Adding Labels to the Form 41Inserting a Label 41Editing the Label Caption 42Using Labels to Create Keyboard Shortcuts for Controls 42Adding Text Boxes to the Form 43Inserting a Text Box 43Using Text Boxes as Calculated Controls 44Case Study: Creating a Mortgage Calculator 46From Here 483 Designing Forms for Efficient and Accurate Data Entry 49Preventing Errors by Validating Data 50Helping Users with Text Prompts 50Preventing Errors with Data Validation Expressions 51Using Input Masks for Consistent and Accurate Data Entry 52Using Controls to Limit Data Entry Choices 55Working with Yes/No Fields 56Using Option Buttons to Present a Limited Number of Choices 59Case Study: Using an Option Group to Select the Shipper 61Using Lists to Present a Large Number of Choices 62Entering Data with ActiveX Controls 67Entering Numbers Using a Spin Button 68Entering Numbers Using a Scrollbar 69Entering Dates Using a Calendar 71Collecting Form Data via Email 72Sending the Access Data Collection Email Message 72Replying to an Access Data Collection Email Message 74Managing the Access Data Collection Replies 75From Here 754 Designing Forms for Business Use 77Using Forms in a Business Context 77Why Collect the Data? 78What Is the Data? 78Who Are Your Users? 78Ten Design Guidelines for Business Forms 791. Make Forms Fast 792. Make Forms Foolproof 793. Mimic Paper Forms When Practical 794. Give Users What They Need and Then Stop 795. Donit Neglect the Keyboard 806. Watch the Field Order (and the Tab Order, Too) 807. Watch Your Screen Resolution 808. Make Form Text Readable 809. Go Easy on the Extras 8110. Organize Your Form Controls 81Organizing Controls on the Form 81Making Good Use of Lines and Rectangles 82Organizing with Option Groups 83Organizing with a Tab Control 84Enhancing Form Text 86Formatting Text 87Text Formatting Tips and Guidelines 87Applying Fancier Form Formatting 88Working with Colors 88Adding Images to Your Forms 91Creating a Shadow Effect for Text 92From Here 935 Creating Specialized Forms 95Creating a Multiple-Table Form 95Understanding Subforms 95Creating a Form and Subform with the Form Wizard 96Creating a Subform in the Form Design View 98Working with Form Command Buttons 99Case Study: Creating a Switchboard Form 102Creating a Form Pop-Up Box or Dialog Box 103Creating a Pop-Up Form 103Creating a Modal Form 104Using a Custom Form with a Parameter Query 105Creating the Custom Form 105Adjusting the Parameter Query 106Using the Custom Form and Parameter Query 107Creating a Startup Form 107Creating a PivotChart Form 108From Here 110 II DESIGNING AND CUSTOMIZING REPORTS6 Creating and Publishing a Report 113Creating a Basic Report 113Creating Simple Reports with the Report Wizard 114Creating a Report in Design View 116Displaying the Design View 116Changing the Record Source 117Understanding the Architecture of Access Reports 118Understanding Report Controls 119Adding Fields to the Report 120Adding Labels to the Report 120Adding a Logo 121Adding a Title 122Adding Page Numbers to the Report 122Adding the Date and Time to the Report 123Changing the Size of a Report Section 124Previewing the Report 124Assigning an AutoFormat in Design View 125Working with Report Properties 126Formatting the Background 126Manipulating Report Controls 128Creating a Report Interactively in Layout View 136Publishing a Report 137Publishing on Paper 137Publishing to Email 138Exporting to Word 138Exporting to PDF or XPS 139From Here 1407 Designing Effective Business Reports 141Using Reports in Business 141Whatis in the Report? 142What Is the Goal of the Report? 142Who Are Your Readers? 144Ten Design Guidelines for Business Reports 1451. Copy Legacy Reports When Practical 1452. Give Users What They Need, Then Stop: Part 1 1453. Give Users What They Need, Then Stop: Part 2 1454. Use Page Numbers 1465. Use Dates and Times 1466. Watch the Field Order 1467. Watch Your Screen Resolution 1468. Make Report Text Readable 1479. Always Sort and/or Group Data 14710. Organize the Report Layout 147Organizing Controls on the Report 147Making Good Use of Lines and Rectangles 148Creating Page Breaks 149Enhancing Report Text 150Formatting Text 150Text Formatting Tips and Guidelines 151Applying Fancier Report Formatting 152Working with Colors 152Adding Images to Your Reports 153Adding Special Effects 154Creating a Shadow Effect for Text 154From Here 1558 Designing Advanced Reports 157Sorting and Grouping a Report 157Setting Up Sorting Options 158Setting Up Grouping Options 158Sorting and Grouping Using an Expression 161Adding Calculations to a Report 161Using the Totals List 162Inserting a Text Box 162Using Text Boxes as Calculated Controls 163Case Study: Creating an Invoice Report 165Using Advanced Methods to Launching a Report 167Launching a Report with a Command Button 167Launching a Report with a Macro 169Controlling Report Output 174Adding Page Breaks After Sections 174Starting Sections at the Top of a Row or Column 174Avoiding Widowed Records 175From Here 1759 Creating Specialized Reports 177Creating a Multiple-Column Report 177Setting Up the Report 178Tweaking the Page Setup 178Troubleshooting Multiple Columns 180Case Study: Using Multiple Columns to Reduce Report Page Count 181Creating Mailing Labels 184Running the Label Wizard 185Creating a Custom Label 187Creating a Mail Merge Report 187Creating a Multiple-Table Report 189Understanding Subreports 190Creating a Report and Subreport with the Report Wizard 191Creating a Subreport in the Report Design View 192Creating a PivotChart Report 194From Here 195 III CREATING POWERFUL QUERIES10 Creating a Basic Query 199Sorting Records 199Sorting on a Single Field 200Sorting on Multiple Fields 200Filtering Table Data 201Filtering by Selection 203Filtering Excluding Selection 203Filtering in Place 204Applying Text, Numeric, and Date Filters 204Filtering by Form 206Learning About Filter Criteria 207Creating a Filter 208Working with Queries 210Creating a Query 210Creating a New Query Object 211Selecting the Fields to Include in the Query 212Entering the Query Criteria 213Excluding a Field from the Query Results 213Returning Only the Top N Values 213Setting Field Properties 214Running the Query 215Querying Notes for Business Users 216Case Study: Querying for a Mail Merge 217Querying the Customers Table 218Running the Mail Merge 219Creating Queries with the Query Wizards 220Creating Crosstab Queries 220Creating Find Duplicates Queries 222Setting Up a Find Unmatched Query 222Working with a Query Dynaset 223Understanding the Datasheet View 223Navigating Fields 224Entering Data 224Adding More Records 225Navigating Records 225Selecting a Record 226Copying a Record 226Deleting a Record 227Formatting the Datasheet 227Working with Query Properties 228From Here 22911 Building Criteria Expressions 231Using Operands in Criteria Expressions 232Literals 232Identifiers 232Functions 233Using Operators in Criteria Expressions 233Comparison Operators 233Arithmetic Operators 234The Like Operator 235The Between...And Operator 235The In Operator 235The Is Null Operator 235Compound Criteria and the Logical Operators 236Using the Logical Operators 237Understanding Operator Precedence 238Setting Up a Calculated Column 239Calculating Inventory Value 240Calculating Discounted Product Totals 241Using the Built-In Functions 241Using Text Functions 243Using Date and Time Functions 246Using Math Functions 251Using Financial Functions 253Working with the Expression Builder 256From Here 25712 Working with Multiple-Table Queries 259Relational Database Fundamentals 259The Pitfalls of a Nonrelational Design 259How a Relational Design Can Help 262Types of Relational Models 264The One-to-Many Model 264The One-to-One Model 265The Many-to-Many Model 265Enforcing Referential Integrity 266Establishing Table Relationships 267Understanding Join Lines 267Identifying Join Types 268Adding Tables to the Relationships Window 269Joining Tables 269Editing a Relationship 271Removing a Join 271Working with Multiple Tables in a Query 271Adding Multiple Tables to a Query 271Adding Fields from Multiple Tables 272Nesting Queries Within Queries 273Joining Tables Within the Query Design Window 274Creating Other Types of Joins 275Creating Outer Joins 275Creating Self-Joins 278Creating Theta Joins 279Creating a Unique Values Query 280Case Study: Drilling Down to the Order Details 282Adding a Subdatasheet to a Query 284Working with Query Subdatasheets 284From Here 28613 Creating Advanced Queries 287Creating a Totals Query 287Displaying the Total Row in the Design Grid 288Setting Up a Totals Query on a Single Field 289Setting Up a Totals Query on Multiple Fields 289Filtering the Records Before Calculating Totals 290Creating a Totals Query for Groups of Records 291Grouping on Multiple Fields 291Creating a Totals Query Using a Calculated Field 293Creating a Totals Query Using Aggregate Functions 294Combining Aggregate Functions and Totals 295Creating Queries That Make Decisions 296Making Decisions with the IIf Function 297Making Decisions with the Switch Function 299Case Study: Calculating a Customer Discount Rate 300Calculating a Simple Discount Rate 300Calculating a Complex Discount Rate 301Running Parameter Queries 302Creating a Simple Query Parameter 302Specifying the Parameter Data Type 304Running Action Queries 304Modifying Table Data with an Update Query 304Removing Records from a Table with a Delete Query 306Creating New Tables with Make-Table Queries 307Adding Records to a Table with an Append Query 309From Here 30914 Creating PivotTable Queries 311What Is a PivotTable? 311How PivotTables Work 312Some PivotTable Terms 313Creating a One-Dimensional PivotTable 314Display Data Field Details 314Displaying the Sum of the Data Field Values 316Hiding and Showing the Data Details 318Inserting an AutoCalc Data Field Summary Calculation 318Changing the AutoCalc Calculation Type 320Creating a Calculated Field 321Removing a PivotTable Field 322Creating a Multiple-Field One-Dimensional PivotTable 322Creating a Two-Dimensional PivotTable 323Analyzing Customer Orders by Product Category 324Adding a Temporal Dimension to the PivotTable 326Filtering a PivotTable 332Using the PivotTable AutoFilters 332Displaying Only the Top or Bottom Items 333Grouping Field Items 335Adding a Filter Field 335Pivoting a PivotTable 336Moving a Field to a Different Area 337Changing the Field Order 338Formatting a PivotTable 339From Here 33915 Querying with SQL Statements 341Viewing the SQL Statement 341Using SQL to Perform a Select Query 342Understanding the SELECT Statement 343Using SQL with Multiple-Table Queries 346Adding a Calculated Column to the SELECT Statement 349Using SQL to Total and Group Records 350Using SQL to Set Up a Parameter Query 350The Full SQL SELECT Syntax 351Using SQL to Perform Action Queries 351Using SQL to Perform an Update Query 352Using SQL to Perform a Delete Query 352Using SQL to Perform a Make-Table Query 353Using SQL to Perform an Append Query 353Using SQL to Create Subqueries 354Using a Subquery to Define a Field 355Determining Whether a Unit Price Is Greater Than the Average 355Using a Subquery to Define Criteria for a Field 356Using Subqueries That Return Dynasets 356In Predicate: Customers Who Have Placed Orders 357All Predicate: Products Cheaper Than All the Condiments 358Using SQL to Create Union Queries 359From Here 360 Index 361
Series Title: Business solutions.
Responsibility: by Paul McFedries.


Microsoft Access is a large, intimidating program. It presents challenges from the outset. This book aims to give you the skills required to extract the data you need (queries), build efficient  Read more...


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Microsoft Office Access 2007 : forms, reports, and queries
    a schema:MediaObject, schema:CreativeWork, schema:Book ;
   library:oclcnum "123904838" ;
   library:placeOfPublication <> ; # Indianapolis, Ind.
   library:placeOfPublication <> ;
   schema:about <> ; # Database management
   schema:about <> ; # Microsoft Access.
   schema:about <> ;
   schema:about <> ; # Microsoft Access.
   schema:bookFormat schema:EBook ;
   schema:creator <> ; # Paul McFedries
   schema:datePublished "2007" ;
   schema:description "Offers guidelines for using Access 2007 queries, forms, and reports, utilizing a practical rather than a theoretical approach that is designed to give readers the ability to extract essential data, build efficient front-end forms for that data, and publish the results in an easy-to-read format."@en ;
   schema:exampleOfWork <> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:isPartOf <> ; # Business solutions.
   schema:isSimilarTo <> ;
   schema:name "Microsoft Office Access 2007 : forms, reports, and queries"@en ;
   schema:productID "123904838" ;
   schema:publication <> ;
   schema:publisher <> ; # Que Pub.
   schema:url <> ;
   schema:url <> ;
   schema:url <> ;
   schema:url <> ;
   schema:workExample <> ;
   schema:workExample <> ;
   wdrs:describedby <> ;

Related Entities

<> # Indianapolis, Ind.
    a schema:Place ;
   schema:name "Indianapolis, Ind." ;

<> # Business solutions.
    a bgn:PublicationSeries ;
   schema:hasPart <> ; # Microsoft Office Access 2007 : forms, reports, and queries
   schema:name "Business solutions." ;
   schema:name "Business solutions" ;

<> # Microsoft Access.
    a schema:CreativeWork ;
   schema:name "Microsoft Access." ;

<> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;

<> # Paul McFedries
    a schema:Person ;
   schema:familyName "McFedries" ;
   schema:givenName "Paul" ;
   schema:name "Paul McFedries" ;

    a schema:ProductModel ;
   schema:isbn "0132714108" ;
   schema:isbn "9780132714105" ;

    a schema:ProductModel ;
   schema:isbn "0789736691" ;
   schema:isbn "9780789736697" ;

    a schema:CreativeWork ;
   rdfs:label "Microsoft Office Access 2007 forms, reports, and queries." ;
   schema:description "Print version:" ;
   schema:isSimilarTo <> ; # Microsoft Office Access 2007 : forms, reports, and queries

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.