Access 2010 24-Hour Trainer
Access 2010 24-Hour Trainer
ISBN: 978-0-470-59167-3 June 2011 552 Pages
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 DVD 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 written example and DVD 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.
Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.
Table of contents
Lesson 1: Installing Access 2010.
Lesson 2: Getting Started in Access 2010.
Lesson 3: Creating a New Database Application.
Lesson 4: Access Database Objects.
Lesson 5: The Access 2010 Ribbon.
Lesson 6: The Access 2010 Backstage.
Lesson 7: The Access 2010 Navigation Pane.
Lesson 8: Creating a Table in Datasheet View.
Lesson 9: Creating a Table in Design View.
Lesson 10: Access 2010 Data Types.
Lesson 11: Table and Field Properties.
Lesson 12: Data Validation and Limiting User Input.
Lesson 13: Creating Value List Fields.
Lesson 14: Creating Lookup Tables.
Lesson 15: Table Modifications.
Lesson 16: Creating Table Relationships.
Lesson 17: Creating Table Field Indexes.
Lesson 18: Creating Tables from External Data.
Lesson 19: Creating Linked Tables.
Lesson 20: Collecting Data via E-mail.
Lesson 21: Creating Queries with the Wizard.
Lesson 22: Creating Queries in Design View.
Lesson 23: Creating Select Queries.
Lesson 24: Data Aggregation and Grouping.
Lesson 25: Creating Parameter Queries.
Lesson 26: Creating Append Queries.
Lesson 27:Creating Update Queries.
Lesson 28: Creating Delete Queries.
Lesson 29: Creating Make Table Queries.
Lesson 30: Creating Crosstab Queries.
Lesson 31: Creating Forms in Layout View.
Lesson 32: Creating Forms in Design View.
Lesson 33: Acc ess Form Properties.
Lesson 34: Access 2010 Form Controls.
Lesson 35: Working with Subforms and Subreports.
Lesson 36: Embedded Macros in Forms.
Lesson 37: Adding Code to Forms.
Lesson 38: Access 2010 Form Types.
Lesson 39: Creating PivotCharts.
Lesson 40: Access Application Navigation.
Lesson 41: Creating Reports in Layout View
Lesson 42: Creating Reports in Design View.
Lesson 43: Access Report Properties.
Lesson 44: Report Sorting, Grouping, and Totals
Lesson 45: Using Macros in Reports.
Lesson 46: Creating Macros in Access 2010.
Lesson 47: Macro Types and Security.
Lesson 48: Macro Parts.
Lesson 49: Building Macros.
Lesson 50: Data Macros in Access 2010.
Lesson 51: The Visual Basic Editor.
Lesson 52: Introduction to VBA.
Lesson 53: Using Operators in VBA.
Lesson 54: Using Variables in VBA.
Lesson 55: Creating Class Modules.
Lesson 56: The Access Object Model.
Lesson 57: Working with DAO.
Lesson 58: Access Application Settings.
Lesson 59: Customizing the Navigation Pane.
Lesson 60: Customizing the Ribbon.
Lesson 61: Customizing the Backstage.
Lesson 62: The Access Runtime.
Appendix: What’s on the DVD?
|All Lesson Files for Download||Download|
|82||Error in Text|
Line 3 currently reads:
"When set to a value of YES,"
"When set to a value of NO,"
|98||Error in Text|
Remove the original "Step 17" and "Step 18," and replace them with the following:
Step 17. Open the tblSales table in Design View mode. Add a field named: State. For the Data Type, choose the Lookup Wizard option. The Lookup Wizard dialog will be opened.
Step 18. On the first page of the Lookup Wizard, click Next. On the second page of the wizard, choose the tblState4 table and click Next. On the third page of the wizard, double click on the StateName field to add it to the lookup and click Next. On the fourth page of the wizard, choose the StateName field from the drop down menu and click Next. On the fifth page of the wizard click on the Finish button. The new lookup field will be created between the State field in the tblSales table and the StateName field in the tblStates4 table. Save the table and close it.
Step 19. Double click on the tblSales table in the Navigation Pane to open the table in Datasheet View. Notice that it now has a State field, and if you click on the blank State field for a record, you'll see that it provides a drop down box with a list of the state name values for the user to choose from.
|Lesson 4 DVD||Error in Text|
On the first screen seen after the Windows logo, there is a series of bullets listing each of the objects in Access. The bullet written "Marcos" should be "Macros."