Share this Page URL
Help

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

The Microsoft Office Access 2003 Inside Track Road Map · Manage unexpected behavior in a form · Run a Visual Basic procedure by using a form event xxii Chapter 9: Extending Your Use of Queries Before beginning this chapter: You should understand the basics of creating a query. See Chapter 6, "Sorting, Filtering, and Re- trieving Data," for detailed procedures. You should also be familiar with table design and table re- lationships. See Chapter 1, "The HelloWorld Database;" Chapter 2, "The Basics of Database De- sign;" and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." for informa- tion about these topics. In this chapter, you will learn how to: · · · · · · Create a crosstab query to summarize data Create a query using Structured Query Language (SQL) Use action queries to update, append, and delete data Run a make-table query. Create special-use queries using SQL Use query properties to return unique values and records Create an outer join and a self-join in a query Chapter 10: Presenting Data with Reports Before beginning this chapter: You should understand the fundamentals of table and query design and how to build and modify a query. You should also be familiar with how to use design tools, including the toolbox and the field list. For information about designing tables, see Chapter 2, "The Basics of Database Design," and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." For information about designing queries, see Chapter 6, "Sorting, Filtering, and Retrieving Data." For information about design tools, see Chapter 7, "Designing Basic Forms." In this chapter, you will learn how to: · · · · · · · Create a report with the Report Wizard Work with a report in Design view Manage a report's record source to filter and select records Display data in a chart Add a subreport to a report Set report properties that control how data appears Work with report events Chapter 11: Analyzing Data with PivotTables and PivotCharts Before beginning this chapter: You should know the basic procedures for creating a form and a query. You can find information about creating forms in Chapter 7, "Designing Basic Forms." You can find information about creating queries in Chapter 6, "Sorting, Filtering, and Retrieving Data," and in Chapter 9, "Extending Your Use of Queries." In this chapter, you will learn how to: · Create a PivotTable