Share this Page URL
Help

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

The Microsoft Office Access 2003 Inside Track Road Map xx Chapter 3: Managing the Consistency, Format, and Integrity of Your Data Before beginning this chapter: You should understand how to create tables, define fields, and set up a relationship between two tables. You can find information about these tasks in Chapter 1, "The HelloWorld Database," and Chapter 2, "The Basics of Database Design." In this chapter, you will learn how to: · · · · · · Manage records in related tables using referential integrity Set table and field properties Use an input mask to manage data entry Apply formats to data Use expressions to calculate values Create rules to validate data Chapter 4: Importing and Linking to Data Before beginning this chapter: You should be familiar with tables and fields, including field data types and the use of a primary key. You can find that information in Chapter 1, "The HelloWorld Database;" Chapter 2, "The Basics of Database Design;" and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." You should also understand the fundamentals of a Microsoft Excel spreadsheet. For basic infor- mation, see the Microsoft Excel online help. In this chapter, you will learn how to: · Determine whether to import data or link to data · Import data from an Excel worksheet, a text file, another Access database, and other data for- mats · Split a database so that forms and reports in one database file are linked to tables in another database file · Link to tables in a separate Access database · Use a macro to import data Chapter 5: Using Visual Basic to Automate Your Database Before beginning this chapter: You should understand the basics of tables and fields. You'll find this information in Chapter 1, "The HelloWorld Database;" Chapter 2, "The Basics of Database Design;" and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." You should also understand the requirements for importing data and for creating a simple macro. For information, see Chapter 4, "Importing and Linking to Data." In this chapter, you will learn how to: · · · · · · Convert a macro to Visual Basic code Create an event procedure Create an Access code module Declare variables Control database operations with standard programming statements Set up options in the Visual Basic Editor. Use the Visual Basic online help