Share this Page URL
Help

The Microsoft Office Access 2003 Inside ... > The Microsoft Office Access 2003 Ins... - Pg. xxi

The Microsoft Office Access 2003 Inside Track Road Map xxi · Add code to handle errors and debug your code. Work with data using data access object models · Use the object model for another Microsoft Office application from Access Part II: The Database Application Chapter 6: Sorting, Filtering, and Retrieving Data Before beginning this chapter: You should understand tables, fields, data types, and table relationships. For information, see Chapter 1, "The HelloWorld Database;" Chapter 2, "The Basics of Database Design;" and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." In this chapter, you will learn how to: · Sort table data in Datasheet view · Create and apply a filter to data in a table · Design a select query, use query criteria to select data, group and summarize records in a query, and use an expression to create a calculated field · Design a query in which you enter criteria at run time (called a parameter query) · Create a query in Microsoft Visual Basic Chapter 7: Designing Basic Forms Before beginning this chapter: You should understand the purpose of a query and how to create a query. This information is cov- ered in Chapter 6, "Sorting, Filtering, and Retrieving Data;" You should also understand table rela- tionships. This topic is covered in Chapter 2, "The Basics of Database Design" and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." In this chapter, you will learn how to: · Create a form using the Form Wizard or an AutoForm format · Use the sections of a form to display an image, a title, or a calculated field · Use form design tools to select, size, and align controls on a form; set the tab order for a form; and add a control to a form Chapter 8: Adding Features and Function to Forms Before beginning this chapter: You should be familiar with how to create and design forms. These tasks are covered in Chapter 7, "Designing Basic Forms." You should also be familiar with the components of a Visual Basic event procedure, which is covered in Chapter 5, "Using Visual Basic to Automate Your Database." In this chapter, you will learn how to: · · · · · · Customize the appearance of your forms Display data with conditional formatting Add a subform to a form to view related data Create an option group that lets you perform a set of alter native operations Use a control's value as query and filter criteria Turn a control on and off using its Enabled property