Microsoft Access is a complete relational database management system that offers powerful tools for creating tables, queries, forms, and reports. Forms and reports are the most important objects in an Access database for managing data entry, presentation and summarization. This book covers these important objects in detail, providing the reader with essential information to enable the creation of a wide variety of useful forms and reports. The reader will learn how to create forms for data entry, editing, and review - for data residing in single tables and across multiple tables. A complete and detailed review of the controls available to both forms and reports is also presented, as well as chapters that cover creating calculated controls. The chapters on reports discuss how to create a wide range of reports, from simple single table designs to reports that pull, group, and summarize data from multiple tables. Each topic is covered in a clear and concise manner.
This title is the third in a series on Building components for a Microsoft Access 2010 database. The books in this series focus on a task-based approach to learning Microsoft Access and therefore differ from other books that feature a complete review of all the commands and tools available in Microsoft Access. Schiavone taught database design for large organizations for over 10 years. This task-based approach to learning is the result of years of field experience in training office and technology workers what they need to know to get the job done.