Microsoft Access 2010 LiveLessons, Downloadable Version
- By Alison Balter
- Published Nov 18, 2010 by Que. Part of the LiveLessons series.
Downloadable Video
- Sorry, this book is no longer in print.
- About this video
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Register your product to gain access to bonus material or receive a coupon.
Description
- Copyright 2011
- Edition: 1st
- Downloadable Video
- ISBN-10: 0-13-264040-6
- ISBN-13: 978-0-13-264040-4
OVER SIX HOURS OF VIDEO INSTRUCTION
In 100+ quick video lessons, expert Alison Balter shows how to create high-performance Microsoft Access 2010 tables, queries, forms, reports, and macros… use innovative new features… share data on the web and with other applications… and much more! Master high-powered skills at your pace, and get specific solutions whenever you need them!
Alison Balter is President of InfoTech Services Group, Inc., a computer consulting firm based in Newbury Park, CA. She has spent 25 years training and consulting on Microsoft Access and related applications with top organizations such as Cisco, Shell, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential, Transamerica, Fox Broadcasting, and the U.S. Navy. She travels throughout North America delivering seminars on Microsoft Access, and has authored 13 books, including Alison Balter’s Mastering Access 2007 Development.
TABLE OF CONTENTS:
| 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 LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home & Office Technologies, Business & Management, and more. View All LiveLessons at http://www.quepublishing.com/imprint/series_detail.aspx?st=87397 |
Sample Content
Table of Contents
| 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 |