Microsoft® Access® 2010 24-Hour Trainer

Microsoft® Access® 2010 24-Hour Trainer

Released June 2011
Publisher(s): Wrox
ISBN: 978047059167

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Welcome to the video portion of Microsoft® Access® 2010 24-Hour Trainer

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 Traineris the perfect place to start.

    Table of contents

    1. Lesson 1: Installing Access 2010 00:05:53
    2. Lesson 2: Getting Started in Access 2010 00:04:34
    3. Lesson 3: Creating a New Database Application 00:05:06
    4. Lesson 4: Access 2010 Database Objects 00:06:20
    5. Lesson 5: The Access 2010 Ribbon 00:11:34
    6. Lesson 6: The Office 2010 Backstage 00:07:00
    7. Lesson 7: The Access 2010 Navigation Pane 00:09:30
    8. Lesson 8: Creating Tables in Datasheet View 00:07:40
    9. Lesson 9: Creating Tables in Design View 00:12:40
    10. Lesson 10: Access 2010 Data Types 00:09:33
    11. Lesson 11: Table and Field Properties 00:11:05
    12. Lesson 12: Data Validation and Limiting User Input 00:10:18
    13. Lesson 13: Creating Value List Fields 00:08:20
    14. Lesson 14: Creating Lookup Tables 00:08:51
    15. Lesson 15: Table Modification 00:10:09
    16. Lesson 16: Creating Table Relationships 00:08:56
    17. Lesson 17: Creating Table Field Indexes 00:06:03
    18. Lesson 18: Creating Tables from External Data 00:11:24
    19. Lesson 19: Creating Linked Tables 00:08:13
    20. Lesson 20: Collecting Data via E-mail 00:10:40
    21. Lesson 21: Creating Queries with the Wizard 00:04:50
    22. Lesson 22: Creating Queries in Design View 00:06:23
    23. Lesson 23: Creating Select Queries 00:07:03
    24. Lesson 24: Data Aggregation and Grouping 00:05:33
    25. Lesson 25: Creating Parameter Queries 00:06:06
    26. Lesson 26: Creating Append Queries 00:07:23
    27. Lesson 27: Creating Update Queries 00:09:45
    28. Lesson 28: Creating Delete Queries 00:07:50
    29. Lesson 29: Creating Make Table Queries 00:06:09
    30. Lesson 30: Creating Crosstab Queries 00:05:52
    31. Lesson 31: Creating Forms in Layout View 00:07:01
    32. Lesson 32: Creating Forms in Design View 00:14:33
    33. Lesson 33: Access Form Properties 00:10:21
    34. Lesson 34: Access 2010 Form Controls 00:09:04
    35. Lesson 35: Creating Subforms and Subreports 00:10:14
    36. Lesson 36: Embedded Macros in Forms 00:07:06
    37. Lesson 37: Adding Code to Forms 00:07:43
    38. Lesson 38: Access 2010 Form Types 00:05:44
    39. Lesson 39: Creating PivotCharts 00:07:53
    40. Lesson 40: Access Application Navigation 00:12:52
    41. Lesson 41: Creating Reports in Layout View 00:06:05
    42. Lesson 42: Creating Reports in Design View 00:12:12
    43. Lesson 43: Access Report Properties 00:06:16
    44. Lesson 44: Report Sorting, Grouping, and Totals 00:06:32
    45. Lesson 45: Using Macros in Reports 00:05:28
    46. Lesson 46: Creating Macros in Access 2010 00:06:03
    47. Lesson 47: Macro Types and Security 00:09:01
    48. Lesson 48: Macro Parts 00:05:33
    49. Lesson 49: Building Macros 00:11:13
    50. Lesson 50: Data Macros in Access 2010 00:06:18
    51. Lesson 51: The Visual Basic Editor 00:11:42
    52. Lesson 52: Introduction to VBA 00:09:01
    53. Lesson 53: Using Operators in VBA 00:07:29
    54. Lesson 54: Using Variables in VBA 00:08:12
    55. Lesson 55: Creating Class Modules 00:09:41
    56. Lesson 56: The Access Object Model 00:06:31
    57. Lesson 57: Working with DAO 00:17:02
    58. Lesson 58: Access Application Settings 00:05:38
    59. Lesson 59: Customizing the Navigation Pane 00:06:39
    60. Lesson 60: Customizing the Ribbon 00:13:38
    61. Lesson 61: Customizing the Backstage 00:08:09
    62. Lesson 62: The Access Runtime 00:07:42

    Product information

    • Title: Microsoft® Access® 2010 24-Hour Trainer
    • Author(s):
    • Release date: June 2011
    • Publisher(s): Wrox
    • ISBN: 978047059167