The Resource Access forms & reports for dummies, Brian Underdahl, (electronic resource)

Access forms & reports for dummies, Brian Underdahl, (electronic resource)

Label
Access forms & reports for dummies
Title
Access forms & reports for dummies
Statement of responsibility
Brian Underdahl
Creator
Subject
Genre
Language
  • eng
  • eng
Summary
Create queries that make forms and reports usefulDevelop forms to access the data you need and make reports that make sense!If you thought you had to use a spreadsheet program to produce reports and forms, guess what! Access can turn out great-looking forms and reports that actually show what's going on with your data -- if you know how to ask it nicely. This hands-on guide helps you do just that, and it works with all versions of Access.Discover how to* Ask Access the right questions* Work with sets of data* Create simple forms with a wizard* Use querie
Member of
Cataloging source
MiAaPQ
http://library.link/vocab/creatorName
Underdahl, Brian
Dewey number
005.7565
Illustrations
illustrations
Index
no index present
Language note
English
LC call number
QA76.9.D3
LC item number
U53 2006
Literary form
non fiction
Nature of contents
dictionaries
Series statement
--For dummies
http://library.link/vocab/subjectName
Database management
Label
Access forms & reports for dummies, Brian Underdahl, (electronic resource)
Instantiates
Publication
Note
Description based upon print version of record
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • Access Forms & Reports For Dummies; About the Author; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Conventions Used in This Book; What You Don't Have to Read; Icons Used in This Book; Foolish Assumptions; How This Book Is Organized; Part I: Accessing Both Ends: Getting Data In and Info Out; Chapter 1: Getting to Know Forms and Reports; Finding a Fascination with Forms; Recognizing Why Reports Rock; Seeing Why Both Forms and Reports Have a Place; Understanding the Value of Queries; Queries, Forms, and Reports Basics You Must Endure
  • Access Add-Ons and Extra Cool ToolsChapter 2: Getting Started with Queries; Understanding the Types of Queries; Creating Queries by Using a Wizard; Creating Queries in Design View; Modifying Queries for Better Results; Chapter 3: Creating Simple Forms; Creating Forms with the Help of a Wizard; Building Forms the Hard Way: Using Design View; Modifying Forms You've Created; Chapter 4: Building Basic Reports; Getting to Know the Types of Access Reports; Creating Reports by Using a Wizard; Designing Reports from Scratch; Modifying Report Layouts; Adding Data from External Linked Tables
  • Part II: Creating Effective QueriesChapter 5: Creating Multi-Table Queries; Understanding Multi-Table Queries; Adding Multiple Tables to Queries; Linking to External Databases in Your Queries; Understanding Relationships in Queries; Chapter 6: Modifying Data with Queries; Understanding What You Can Modify with a Query; Being Called to Action: Data-Modifying Queries; Creating New Tables with Queries; Updating Data by Using Queries; Deleting Data with Queries; Adding New Data with Queries; Chapter 7: Expanding Queries with SQL; Getting the Scoop on SQL; Understanding How SQL Can Help
  • Viewing the SQL You've Already Created and Didn't Know AboutGetting Your Feet Wet with Simple SQL Statements; Making Useful SQL Statements; A Nod to VBA Programmers; Chapter 8: Dealing with Quarrelsome Queries; Troubleshooting Queries That Don't Quite Work; Troubleshooting Sassy SQL; Avoiding Improper Relationships; Junking Joins That Don't Join; Steering Around Empty Query Results; Preventing Data Destruction; Part III: Building Really Useful Forms; Chapter 9: Building Better Forms by Using Controls; Getting to Know the Controls; Common Controls You Can Use; Adding Controls to Your Forms
  • Incorporating ActiveX ControlsModifying the Characteristics of Controls; Chapter 10: Using Multiple Tables in Forms; Understanding Forms and Subforms; Adding Fields from Multiple Tables to Your Forms; Choosing the Best Subform View; Adding Multiple Subforms; Navigating Records in Multi-Table Forms; Chapter 11: Fixing Form Faults; Preventing Invalid Data with Input Masks; Limiting a User to Specific Values with Validation Rules; Preventing Users from Changing Records; Looking Out for Poorly Formatted Data; Part IV: Designing Great Reports; Chapter 12: Adding Fancy Touches to Reports
  • Adding Descriptive Titles to Your Reports
Dimensions
unknown
Extent
1 online resource (410 p.)
Form of item
online
Isbn
9780471776260
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000348517
  • (EBL)239383
  • (OCoLC)63792044
  • (SSID)ssj0000096430
  • (PQKBManifestationID)11121855
  • (PQKBTitleCode)TC0000096430
  • (PQKBWorkID)10077277
  • (PQKB)10108574
  • (MiAaPQ)EBC239383
  • (EXLCZ)991000000000348517
Label
Access forms & reports for dummies, Brian Underdahl, (electronic resource)
Publication
Note
Description based upon print version of record
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • Access Forms & Reports For Dummies; About the Author; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Conventions Used in This Book; What You Don't Have to Read; Icons Used in This Book; Foolish Assumptions; How This Book Is Organized; Part I: Accessing Both Ends: Getting Data In and Info Out; Chapter 1: Getting to Know Forms and Reports; Finding a Fascination with Forms; Recognizing Why Reports Rock; Seeing Why Both Forms and Reports Have a Place; Understanding the Value of Queries; Queries, Forms, and Reports Basics You Must Endure
  • Access Add-Ons and Extra Cool ToolsChapter 2: Getting Started with Queries; Understanding the Types of Queries; Creating Queries by Using a Wizard; Creating Queries in Design View; Modifying Queries for Better Results; Chapter 3: Creating Simple Forms; Creating Forms with the Help of a Wizard; Building Forms the Hard Way: Using Design View; Modifying Forms You've Created; Chapter 4: Building Basic Reports; Getting to Know the Types of Access Reports; Creating Reports by Using a Wizard; Designing Reports from Scratch; Modifying Report Layouts; Adding Data from External Linked Tables
  • Part II: Creating Effective QueriesChapter 5: Creating Multi-Table Queries; Understanding Multi-Table Queries; Adding Multiple Tables to Queries; Linking to External Databases in Your Queries; Understanding Relationships in Queries; Chapter 6: Modifying Data with Queries; Understanding What You Can Modify with a Query; Being Called to Action: Data-Modifying Queries; Creating New Tables with Queries; Updating Data by Using Queries; Deleting Data with Queries; Adding New Data with Queries; Chapter 7: Expanding Queries with SQL; Getting the Scoop on SQL; Understanding How SQL Can Help
  • Viewing the SQL You've Already Created and Didn't Know AboutGetting Your Feet Wet with Simple SQL Statements; Making Useful SQL Statements; A Nod to VBA Programmers; Chapter 8: Dealing with Quarrelsome Queries; Troubleshooting Queries That Don't Quite Work; Troubleshooting Sassy SQL; Avoiding Improper Relationships; Junking Joins That Don't Join; Steering Around Empty Query Results; Preventing Data Destruction; Part III: Building Really Useful Forms; Chapter 9: Building Better Forms by Using Controls; Getting to Know the Controls; Common Controls You Can Use; Adding Controls to Your Forms
  • Incorporating ActiveX ControlsModifying the Characteristics of Controls; Chapter 10: Using Multiple Tables in Forms; Understanding Forms and Subforms; Adding Fields from Multiple Tables to Your Forms; Choosing the Best Subform View; Adding Multiple Subforms; Navigating Records in Multi-Table Forms; Chapter 11: Fixing Form Faults; Preventing Invalid Data with Input Masks; Limiting a User to Specific Values with Validation Rules; Preventing Users from Changing Records; Looking Out for Poorly Formatted Data; Part IV: Designing Great Reports; Chapter 12: Adding Fancy Touches to Reports
  • Adding Descriptive Titles to Your Reports
Dimensions
unknown
Extent
1 online resource (410 p.)
Form of item
online
Isbn
9780471776260
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000348517
  • (EBL)239383
  • (OCoLC)63792044
  • (SSID)ssj0000096430
  • (PQKBManifestationID)11121855
  • (PQKBTitleCode)TC0000096430
  • (PQKBWorkID)10077277
  • (PQKB)10108574
  • (MiAaPQ)EBC239383
  • (EXLCZ)991000000000348517

Library Locations

  • Albert D. Cohen Management LibraryBorrow it
    181 Freedman Crescent, Winnipeg, MB, R3T 5V4, CA
    49.807878 -97.129961
  • Architecture/Fine Arts LibraryBorrow it
    84 Curry Place, Winnipeg, MB, CA
    49.807716 -97.136226
  • Archives and Special CollectionsBorrow it
    25 Chancellors Circle (Elizabeth Dafoe Library), Room 330, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Bibliothèque Alfred-Monnin (Université de Saint-Boniface)Borrow it
    200, avenue de la Cathédrale, Local 2110, Winnipeg, MB, R2H 0H7, CA
    49.888861 -97.119735
  • Bill Larson Library (Grace Hospital)Borrow it
    300 Booth Drive, G-227, Winnipeg, MB, R3J 3M7, CA
    49.882400 -97.276436
  • Carolyn Sifton - Helene Fuld Library (St. Boniface General Hospital)Borrow it
    409 Tache Avenue, Winnipeg, MB, R2H 2A6, CA
    49.883388 -97.126050
  • Concordia Hospital LibraryBorrow it
    1095 Concordia Avenue, Winnipeg, MB, R2K 3S8, CA
    49.913252 -97.064683
  • Donald W. Craik Engineering LibraryBorrow it
    75B Chancellors Circle (Engineering Building E3), Room 361, Winnipeg, MB, R3T 2N2, CA
    49.809053 -97.133292
  • E.K. Williams Law LibraryBorrow it
    224 Dysart Road, Winnipeg, MB, R3T 5V4, CA
    49.811829 -97.131017
  • Eckhardt-Gramatté Music LibraryBorrow it
    136 Dafoe Road (Taché Arts Complex), Room 257, Winnipeg, MB, R3T 2N2, CA
    49.807964 -97.132222
  • Elizabeth Dafoe LibraryBorrow it
    25 Chancellors Circle, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Fr. H. Drake Library (St. Paul's College)Borrow it
    70 Dysart Road, Winnipeg, MB, R3T 2M6, CA
    49.810605 -97.138184
  • J.W. Crane Memorial Library (Deer Lodge Centre)Borrow it
    2109 Portage Avenue, Winnipeg, MB, R3J 0L3, CA
    49.878000 -97.235520
  • Libraries Annex (not open to the public; please see web page for details)Borrow it
    25 Chancellors Circle (in the Elizabeth Dafoe Library), Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Neil John Maclean Health Sciences LibraryBorrow it
    727 McDermot Avenue (Brodie Centre), 200 Level, Winnipeg, MB, R3E 3P5, CA
    49.903563 -97.160554
  • Sciences and Technology LibraryBorrow it
    186 Dysart Road, Winnipeg, MB, R3T 2M8, CA
    49.811526 -97.133257
  • Seven Oaks General Hospital LibraryBorrow it
    2300 McPhillips Street, Winnipeg, MB, R2V 3M3, CA
    49.955177 -97.148865
  • Sister St. Odilon Library (Misericordia Health Centre)Borrow it
    99 Cornish Avenue, Winnipeg, MB, R3C 1A2, CA
    49.879592 -97.160425
  • St. John's College LibraryBorrow it
    92 Dysart Road, Winnipeg, MB, R3T 2M5, CA
    49.811242 -97.137156
  • Victoria General Hospital LibraryBorrow it
    2340 Pembina Highway, Winnipeg, MB, R3T 2E8, CA
    49.806755 -97.152739
  • William R Newman Library (Agriculture)Borrow it
    66 Dafoe Road, Winnipeg, MB, R3T 2R3, CA
    49.806936 -97.135525
Processing Feedback ...