Microsoft Access 2010 24-Hour Trainer (With CD)

0.0

Microsoft Access is the most popular database system in the world and this practical guide will 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 showingyou 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

0.0

Geoffrey Griffith is an avid Access user who contributed to the Access 2007 product as a Software Design Engineer in Test for the Microsoft Office Access team. He enjoys participating in software community events by attending and speaking for local users groups and helping all those who would seek it. Truitt L. Bradly is a Microsoft Access MVP; as an accountant, analyst, and developer, Truitt has developed insurance and health care database applications using Access and SQL Server. He was Technical Editor for Microsoft Office Access 2007 VBA (Que) Table of Contents Introduction. Installing Access 2010. Getting Started in Access 2010. Creating a New Database Application. Access Database Objects. The Access 2010 Ribbon. The Access 2010 Backstage. The Access 2010 Navigation Pane. Creating a Table in Datasheet View. Creating a Table in Design View. Access 2010 Data Types. Table and Field Properties. Data Validation and Limiting User Input. Creating Value List Fields. Creating Lookup Tables. Table Modifications. Creating Table Relationships. Creating Table Field Indexes. Creating Tables from External Data. Creating Linked Tables. Collecting Data via E-mail. Creating Queries with the Wizard. Creating Queries in Design View. Creating Select Queries. Data Aggregation and Grouping. Creating Parameter Queries. Creating Append Queries. Creating Update Queries. Creating Delete Queries. Creating Make Table Queries. Creating Crosstab Queries. Creating Forms in Layout View. Creating Forms in Design View. Acc ess Form Properties. Access 2010 Form Controls. Working with Subforms and Subreports. Embedded Macros in Forms. Adding Code to Forms. Access 2010 Form Types. Creating PivotCharts. Access Application Navigation. Creating Reports in Layout View Creating Reports in Design View. Access Report Properties. Report Sorting, Grouping, and Totals Using Macros in Reports. Creating Macros in Access 2010. Macro Types and Security. Macro Parts. Building Macros. Data Macros in Access 2010. The Visual Basic Editor. Introduction to VBA. Using Operators in VBA. Using Variables in VBA. Creating Class Modules. The Access Object Model. Working with DAO. Access Application Settings. Customizing the Navigation Pane. Customizing the Ribbon. Customizing the Backstage. The Access Runtime. Summary. Appendix: What's on the DVD? Index.