Share this Page URL

Part II: The Database Application - Pg. 193

193 Part II. The Database Application Accumulating data in a set of well-organized tables is one goal in building a Microsoft Access data- base. After you've created the tables and established the relationships you need between the tables, you need to create a database application that lets you interact with the data effectively and effi- ciently. With a database application, you can update and maintain your data, retrieve the data you need, organize and summarize the data, and present the data so that you and others can review and analyze it. In the chapters in Part II of this book, we'll explore in detail the features you use in Access to create and develop queries, forms, reports, and data access pages, as well as other resources that Ac- cess provides for organizing and presenting data. You'll first learn how to simply sort or filter data, for example, and how to create a database query that you use to select and summarize a set of records. You'll also gain more experience building forms, learn how to modify the appearance and behavior of forms, and discover how to automate the functions that a form is designed to carry out. You'll find out how you can design a report to present a single view of your data and how you can customize a single report so that the report shows detailed or summary data at your choice. We'll cover how you can work with data in PivotTables and PivotCharts-tools you can use to examine your data from multiple perspectives by dragging and dropping field names-and data access pages, the built-in fea-ture of Access that you can use to display and update data over the Web. Finally, you'll customize Access, creating your own toolbar and menu and designing a form that can you use to help manage the workflow in your database. Throughout Part II, we'll build on the background information presented in the first part of this book. In addition to seeing how the data stored in tables is displayed on a form and presented in a report, you'll see more examples of how to add flexibility and automation to your database.