Microsoft Access 2010 LiveLessons (Video Training)

Office Access 2010 Introduced

1. Starting Microsoft Access 2. Opening an Existing Database 3. The Access Desktop 4. The Navigation Pane 5. A Preview of the Database Components 6. Closing an Access Database Tables Introduced 7. Viewing and Navigating Table Data 8. Editing Table Data 9. Adding Records to a Table 10. Selecting and Deleting Records 11. Finding and Replacing Records 12. Filtering Table Data Queries Introduced 13. Opening a Query in Datasheet View 14. Opening a Query in Design View 15. Selecting Fields 16. Ordering the Query Result 17. Refining Queries with Criteria 18. Modifying the Datasheet View 19. Saving and Closing a Query Forms Introduced 20. Opening a Form 21. Working with Data in a Form 22. Sorting Form Data 23. Filtering the Data Underlying a Form 24. Viewing the Design of a Form 25. Using the AutoForm Feature 26. Using a Form Wizard 27. Taking Advantage of Conditional Formatting Reports Introduced 28. Opening and Viewing a Report 29. Printing Report Data 30. AutoReports and the Report Wizard 31. Viewing the Design of a Report Creating Your Own Databases and Tables 32. Creating a New Database 33. Building a New Table 34. Selecting the Appropriate Field Type 35. Creating Indexes 36. The All-Important Primary Key Creating Relationships 37. Introduction to Relational Database Design 38. Establishing Relationships in Access 39. Establishing Referential Integrity Creating Queries 40. Advanced Criteria Techniques 41. Updating Query Results 42. Building Queries Based on Multiple Tables 43. Creating Calculated Fields with the Expression Builder 44. Creating Parameter Queries Creating Forms 45. Working with Controls 46. Form Properties 47. Working with Combo Boxes 48. The Command Button Wizard: Programming without Typing 49. Creating One-To-Many Forms Using the Form Wizard 50. Creating One-To-Many Forms Using the SubForm Wizard Creating Reports 51. Working with Report Bands 52. Working with Controls 53. Basing Reports on Multiple Tables 54. Adding Sorting and Grouping 55. Working with Report Properties 56. Working with Subreports 57. Basing Reports on Stored Queries Creating Macros 58. The Basics of Creating a Macro 59. Running an Access Macro 60. Modifying an Existing Macro 61. Creating an Embedded Macro 62. Creating Data Macros 63. Creating a Drillthrough Macro 64. Debugging a Macro 65. Converting a Macro to VBA Code 66. Creating an AutoExec Macro Power Techniques 67. Working with Field Properties 68. Working with Table Properties 69. Creating and Running Action Queries 70. Using Aggregate Functions to Summarize Numeric Data 71. Working with Outer Joins and Self Joins 72. Refining Queries with Field, Field List, and Query Properties 73. Control Properties and Why to Use Them 74. Bound, Unbound, and Calculated Controls 75. Control Properties and Why to Use Them 76. Inserting Page Breaks 77. Bound, Unbound, and Calculated Controls Sharing Data With Other Applications 78. Exporting to Another Access Database 79. Exporting to an Excel Spreadsheet 80. Exporting to Text 81. Importing from Another Access Database 82. Importing Spreadsheet Data 83. Importing Text Data 84. Linking to Tables in Another Access Database 85. Linking to Another Type of Database 86. Linking to SQL Server Databases 87. The Linked Table Manager Access and the Internet 88. Creating Web Databases 89. Using Application Parts 90. Creating Publishable Objects 91. Publishing Your Database to Access Services 92. Saving Database Objects as HTML 93. Linking to HTML Files 94. Importing HTML Files 95. Exporting Data to XML 96. Importing XML Data into Access Database Administration 97. Compacting and Repairing a Database 98. Encrypting and Decrypting a Database 99. Converting a Database to Another Version 100. Creating an MDE File 101. Using the Database Splitter