You are previewing Microsoft® Access® 2010 24-Hour Trainer.
O'Reilly logo
Microsoft® Access® 2010 24-Hour Trainer

Book Description

A unique book-and-video package for Microsoft® Access® 2010 24-Hour Trainer

Microsoft Access is the most popular database system in the world and this practical guide will soon have you building Access applications using the Access 2010. This book is designed for beginner-to intermediate-level Access users and covers the basics of building and working with the major features of the program. Over 60 lessons are included to discuss these features and provide step-by-step examples showing you exactly how each feature can be implemented in a real world Access database application. The accompanying video provides clear, easy-to-follow videos of the authors demonstrating each of the examples discussed in the book, as well as extra commentary, so that no reader is left behind!

  • Provides examples of building Access database applications from scratch or from existing database templates.

  • Discusses how to use Access 2010 and the major components it provides, such as the Navigation Pane, Ribbon, and the many database object designers.

  • Teaches the basics of building and working with each of the major Access database object types: tables, queries, forms, reports, macros, and VBA code modules.

  • Introduces exciting new Access 2010 features, such as the new macro designer, the new Ribbon designer, and even how to customize the Access Backstage.

  • Teaches the basics of writing VBA code and provides specific examples about how and when to use it.

  • Each lesson includes a step-by-step video showing exactly how to accomplish the tasks discussed in the lesson.

Even if you have no experience with Access 2010, this guide will have you building robust Access applications with the best of them! If you want to get quickly up to speed on Access 2010, Access 2010 24-Hour Trainer is the perfect place to start.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright
  4. Dedication
  5. CREDITS
  6. ABOUT THE AUTHORS
  7. ABOUT THE CONTRIBUTING AUTHORS
  8. ABOUT THE TECHNICAL EDITOR
  9. ACKNOWLEDGMENTS
  10. MICROSOFT® ACCESS® 2010 24-HOUR TRAINER
  11. Contents
  12. INTRODUCTION
    1. WHO THIS BOOK IS FOR
    2. HOW TO USE THIS BOOK
    3. THE BOOK'S WEBSITE
    4. P2P.WROX.COM
  13. LESSON 1: Installing Access 2010
    1. LESSON SETUP
    2. HOW TO GET ACCESS 2010
    3. INSTALLING ACCESS 2010
    4. TRY IT
    5. SUMMARY
  14. LESSON 2: Getting Started in Access 2010
    1. LESSON SETUP
    2. STARTING ACCESS 2010
    3. TRY IT
    4. SUMMARY
  15. LESSON 3: Creating a New Database Application
    1. LESSON SETUP
    2. OPTIONS FOR CREATING DATABASES IN ACCESS 2010
    3. TRY IT
    4. SUMMARY
  16. LESSON 4: Access Database Objects
    1. LESSON SETUP
    2. ACCESS DATABASE OBJECTS
    3. TRY IT
    4. SUMMARY
  17. LESSON 5: The Access 2010 Ribbon
    1. LESSON SETUP
    2. RIBBON OVERVIEW
    3. TRY IT
    4. SUMMARY
  18. LESSON 6: The Access 2010 Backstage
    1. LESSON SETUP
    2. THE BACKSTAGE VIEW
    3. TOURING THE BACKSTAGE FEATURES
    4. TRY IT
    5. SUMMARY
  19. LESSON 7: The Access 2010 Navigation Pane
    1. LESSON SETUP
    2. THE NAVIGATION PANE OVERVIEW
    3. TRY IT
    4. SUMMARY
  20. LESSON 8: Creating a Table in Datasheet View
    1. LESSON SETUP
    2. CREATING TABLES IN ACCESS 2010
    3. CREATING A TABLE IN DATASHEET VIEW
    4. APPLICATION PARTS IN ACCESS 2010
    5. SHAREPOINT LINKED TABLES IN ACCESS 2010
    6. TRY IT
    7. SUMMARY
  21. LESSON 9: Creating a Table in Design View
    1. LESSON SETUP
    2. CREATING A TABLE IN DESIGN VIEW
    3. TRY IT
    4. SUMMARY
  22. LESSON 10: Access 2010 Data Types
    1. LESSON SETUP
    2. ACCESS 2010 FIELD DATA TYPES
    3. TRY IT
    4. SUMMARY
  23. LESSON 11: Table and Field Properties
    1. LESSON SETUP
    2. THE TABLE PROPERTY SHEET
    3. SETTING TABLE PROPERTIES
    4. FIELD PROPERTIES
    5. SETTING FIELD PROPERTIES
    6. TRY IT
    7. SUMMARY
  24. LESSON 12: Data Validation and Limiting User Input
    1. LESSON SETUP
    2. DATA VALIDATION FIELD PROPERTIES
    3. TRY IT
    4. SUMMARY
  25. LESSON 13: Creating Value List Fields
    1. LESSON SETUP
    2. LIST FIELDS IN ACCESS
    3. TRY IT
    4. SUMMARY
  26. LESSON 14: Creating Lookup Tables
    1. LESSON SETUP
    2. LOOKUP TABLE THEORY
    3. TRY IT
    4. SUMMARY
  27. LESSON 15: Table Modifications
    1. LESSON SETUP
    2. RENAMING A TABLE
    3. TABLE LOCKING CONSIDERATIONS
    4. MODIFYING FIELDS
    5. DATA INTEGRITY CONSIDERATIONS
    6. TRY IT
    7. SUMMARY
  28. LESSON 16: Creating Table Relationships
    1. LESSON SETUP
    2. RELATIONAL DATABASE THEORY PRIMER
    3. THE ACCESS RELATIONSHIP TOOLS
    4. TRY IT
    5. SUMMARY
  29. LESSON 17: Creating Table Field Indexes
    1. LESSON SETUP
    2. THE ROLE OF FIELD INDEXES
    3. WHEN TO USE INDEXES
    4. CREATING AN INDEX USING ACCESS 2010
    5. TRY IT
    6. SUMMARY
  30. LESSON 18: Creating Tables from External Data
    1. EXTERNAL DATA SOURCES
    2. TRY IT
    3. SUMMARY
  31. LESSON 19: Creating Linked Tables
    1. LESSON SETUP
    2. LINKED TABLES IN ACCESS
    3. TRY IT
    4. SUMMARY
  32. LESSON 20: Collecting Data via E-mail
    1. LESSON SETUP
    2. PREREQUISITES FOR E-MAIL DATA COLLECTION
    3. USING THE DATA COLLECTION WIZARD
    4. TRY IT
    5. SUMMARY
  33. LESSON 21: Creating Queries with the Wizard
    1. LESSON SETUP
    2. DATABASE QUERY THEORY
    3. CREATING A QUERY WITH THE WIZARD
    4. TRY IT
    5. SUMMARY
  34. LESSON 22: Creating Queries in Design View
    1. CREATING A NEW QUERY IN DESIGN VIEW
    2. TRY IT
    3. SUMMARY
  35. LESSON 23: Creating Select Queries
    1. LESSON SETUP
    2. CREATING A SELECT QUERY
    3. TRY IT
    4. SUMMARY
  36. LESSON 24: Data Aggregation and Grouping
    1. LESSON SETUP
    2. GROUPING DATA IN QUERIES
    3. AGGREGATE DATA QUERIES
    4. SORTING MULTIPLE COLUMNS
    5. USES FOR CROSSTAB QUERIES
    6. TRY IT
    7. SUMMARY
  37. LESSON 25: Creating Parameter Queries
    1. LESSON SETUP
    2. PARAMETER QUERIES IN ACCESS
    3. CREATING PARAMETER QUERIES IN DESIGN VIEW
    4. DEFINING PARAMETER DATA TYPES
    5. CREATING A PARAMETER QUERY IN SQL VIEW
    6. TRY IT
    7. SUMMARY
  38. LESSON 26: Creating Append Queries
    1. LESSON SETUP
    2. APPEND QUERIES IN ACCESS
    3. TRY IT
    4. SUMMARY
  39. LESSON 27: Creating Update Queries
    1. LESSON SETUP
    2. UPDATE QUERIES IN ACCESS
    3. TRY IT
    4. SUMMARY
  40. LESSON 28: Creating Delete Queries
    1. LESSON SETUP
    2. DELETE QUERIES IN ACCESS
    3. TRY IT
    4. SUMMARY
  41. LESSON 29: Creating Make Table Queries
    1. LESSON SETUP
    2. MAKE TABLE QUERIES IN ACCESS
    3. TRY IT
    4. SUMMARY
  42. LESSON 30: Creating Crosstab Queries
    1. LESSON SETUP
    2. CROSSTAB QUERIES IN ACCESS
    3. TRY IT
    4. SUMMARY
  43. LESSON 31: Creating Forms in Layout View
    1. LESSON SETUP
    2. QUICK FORMS IN ACCESS 2010
    3. SWITCHING TO LAYOUT VIEW
    4. THE FORM LAYOUT TOOLS RIBBONS
    5. THE FIELD LIST PANE
    6. THE PROPERTY SHEET PANE
    7. THE RECORD SOURCE PROPERTY
    8. ACCESS FORM TYPES
    9. TRY IT
    10. SUMMARY
  44. LESSON 32: Creating Forms in Design View
    1. LESSON SETUP
    2. BOUND VERSUS UNBOUND
    3. CREATING A FORM IN DESIGN VIEW
    4. DESIGN VIEW MODE
    5. THE FORM DESIGN RIBBON
    6. THE FIELD LIST PANE
    7. THE PROPERTY SHEET PANE
    8. THE NAVIGATION PANE
    9. TRY IT
    10. SUMMARY
  45. LESSON 33: Access Form Properties
    1. LESSON SETUP
    2. THE PROPERTY SHEET
    3. THE PROPERTY SHEET TABS
    4. ACCESS FORM PROPERTIES
    5. SETTING FORM PROPERTIES
    6. TRY IT
    7. SUMMARY
  46. LESSON 34: Access 2010 Form Controls
    1. LESSON SETUP
    2. THE BUILT-IN ACCESS CONTROLS
    3. THE DESIGN RIBBON FOR FORMS
    4. ADDING CONTROLS TO FORMS
    5. SETTING CONTROL PROPERTIES
    6. TRY IT
    7. SUMMARY
  47. LESSON 35: Working with Subforms and Subreports
    1. LESSON SETUP
    2. SUBFORMS/SUBREPORTS IN ACCESS
    3. DESIGNING SUBFORMS AND SUBREPORTS
    4. TRY IT
    5. SUMMARY
  48. LESSON 36: Embedded Macros in Forms
    1. LESSON SETUP
    2. MACROS IN ACCESS
    3. ENABLING MACROS IN ACCESS
    4. TRY IT
    5. SUMMARY
  49. LESSON 37: Adding Code to Forms
    1. LESSON SETUP
    2. VBA CODE IN ACCESS 2010
    3. EMBEDDING CODE IN A FORM
    4. WRITING VBA CODE
    5. ENABLING CODE IN ACCESS
    6. TRY IT
    7. SUMMARY
  50. LESSON 38: Access 2010 Form Types
    1. LESSON SETUP
    2. SINGLE ITEM FORMS
    3. MULTIPLE ITEM FORMS
    4. DATASHEET FORMS
    5. SPLIT FORMS
    6. POP-UP FORMS
    7. MODAL FORMS
    8. PIVOTCHART AND PIVOTTABLE FORMS
    9. TRY IT
    10. SUMMARY
  51. LESSON 39: Creating PivotCharts
    1. LESSON SETUP
    2. CREATING PIVOTCHARTS
    3. DESIGNING PIVOTCHARTS
    4. DISPLAYING PIVOTCHARTS
    5. TRY IT
    6. SUMMARY
  52. LESSON 40: Access Application Navigation
    1. LESSON SETUP
    2. APPLICATION NAVIGATION CONSIDERATIONS
    3. CREATING FORMS TO NAVIGATE
    4. TRY IT
    5. SUMMARY
  53. LESSON 41: Creating Reports in Layout View
    1. LESSON SETUP
    2. QUICK REPORTS IN ACCESS 2010
    3. SWITCHING TO LAYOUT VIEW
    4. THE REPORT LAYOUT RIBBON
    5. THE FIELD LIST PANE
    6. THE PROPERTY SHEET PANE
    7. SETTING REPORT DESIGN PROPERTIES
    8. TRY IT
    9. SUMMARY
  54. LESSON 42: Creating Reports in Design View
    1. LESSON SETUP
    2. CREATING A NEW REPORT IN DESIGN
    3. BOUND VERSUS UNBOUND REPORTS
    4. THE REPORT DESIGN RIBBON
    5. THE FIELD LIST
    6. THE PROPERTY SHEET
    7. THE GROUP, SORT, AND TOTAL PANE
    8. THE NAVIGATION PANE
    9. TRY IT
    10. SUMMARY
  55. LESSON 43: Access Report Properties
    1. LESSON SETUP
    2. THE PROPERTY SHEET PANE
    3. ACCESS REPORT PROPERTIES
    4. TRY IT
    5. SUMMARY
  56. LESSON 44: Report Sorting, Grouping, and Totals
    1. LESSON SETUP
    2. SHOWING DATA IN ACCESS REPORTS
    3. THE GROUP, SORT, AND TOTAL PANE
    4. TRY IT
    5. SUMMARY
  57. LESSON 45: Using Macros in Reports
    1. LESSON SETUP
    2. MACROS IN ACCESS
    3. ENABLING MACROS IN ACCESS
    4. TRY IT
    5. SUMMARY
  58. LESSON 46: Creating Macros in Access 2010
    1. LESSON SETUP
    2. THE THEORY OF MACROS
    3. THE ACCESS 2010 MACRO DESIGNER
    4. EXECUTING MACROS
    5. TRY IT
    6. SUMMARY
  59. LESSON 47: Macro Types and Security
    1. LESSON SETUP
    2. MACRO TYPES
    3. MACRO SECURITY
    4. TRY IT
    5. SUMMARY
  60. LESSON 48: Macro Parts
    1. LESSON SETUP
    2. MACRO CHANGES IN ACCESS 2010
    3. MACRO NAMES
    4. MACRO ACTIONS
    5. MACRO PARAMETERS
    6. MACRO CONDITIONS
    7. MACRO GROUPS
    8. MACRO XML
    9. MACRO COMMENTS
    10. MACRO TEMPVARS
    11. TRY IT
    12. SUMMARY
  61. LESSON 49: Building Macros
    1. LESSON SETUP
    2. CREATING MULTI-STEP MACROS
    3. HANDLING ERRORS IN MACROS
    4. LOGIC BRANCHING IN MACROS
    5. LOOPING IN MACROS
    6. DEBUGGING MACROS
    7. TRY IT
    8. SUMMARY
  62. LESSON 50: Data Macros in Access 2010
    1. LESSON SETUP
    2. THE THEORY OF DATA MACROS
    3. EVENTS FOR DATA MACROS
    4. CREATING DATA MACROS
    5. RUNNING DATA MACROS
    6. TRY IT
    7. SUMMARY
  63. LESSON 51: The Visual Basic Editor
    1. LESSON SETUP
    2. STARTING VBE
    3. DEBUGGING CODE
    4. TRY IT
    5. SUMMARY
  64. LESSON 52: Introduction to VBA
    1. LESSON SETUP
    2. WRITING VBA CODE
    3. TRY IT
    4. SUMMARY
  65. LESSON 53: Using Operators in VBA
    1. LESSON SETUP
    2. VBA OPERATORS
    3. TRY IT
    4. SUMMARY
  66. LESSON 54: Using Variables in VBA
    1. LESSON SETUP
    2. VARIABLES IN VBA
    3. TRY IT
    4. SUMMARY
  67. LESSON 55: Creating Class Modules
    1. LESSON SETUP
    2. CREATING A NEW CLASS MODULE
    3. USING A CLASS MODULE
    4. TRY IT
    5. SUMMARY
  68. LESSON 56: The Access Object Model
    1. LESSON SETUP
    2. THE ACCESS APPLICATION OBJECT
    3. TRY IT
    4. SUMMARY
  69. LESSON 57: Working with DAO
    1. LESSON SETUP
    2. THE DAO OBJECT MODEL
    3. TRY IT
    4. SUMMARY
  70. LESSON 58: Access Application Settings
    1. LESSON SETUP
    2. THE ACCESS OPTIONS DIALOG
    3. TRY IT
    4. SUMMARY
  71. LESSON 59: Customizing the Navigation Pane
    1. LESSON SETUP
    2. THE NAVIGATION OPTIONS DIALOG
    3. TRY IT
    4. SUMMARY
  72. LESSON 60: Customizing the Ribbon
    1. LESSON SETUP
    2. THE CUSTOMIZE RIBBON OPTIONS
    3. CUSTOM RIBBON COMMANDS
    4. TRY IT
    5. SUMMARY
  73. LESSON 61: Customizing the Backstage
    1. LESSON SETUP
    2. THE ACCESS 2010 BACKSTAGE
    3. TRY IT
    4. SUMMARY
  74. LESSON 62: The Access Runtime
    1. LESSON SETUP
    2. THE ACCESS RUNTIME OVERVIEW
    3. BUILDING RUNTIME APPLICATIONS
    4. DEPLOYING RUNTIME APPLICATIONS
    5. TRY IT
    6. SUMMARY
  75. APPENDIX: What's on the DVD?
    1. SYSTEM REQUIREMENTS
    2. USING THE DVD
    3. WHAT'S ON THE DVD?
    4. TROUBLESHOOTING
    5. CUSTOMER CARE
  76. INDEX