Essential Access 2000 fast

1 Why Use Access 2000?.- What is Access 2000?.- Is this book for you?.- What you need to run Access 2000.- How to use this book.- Conventions.- 2 Starting with Access.- The menu bar.- Tables.- Forms.- Queries.- Reports.- Data access pages.- Macros.- Modules.- 3 Database Concepts.- Paper database.- Tables.- Records.- Design ground rules.- Design stages.- Normalizing data.- Testing a design.- Field types.- 4 Creating a Table.- Creating the database.- Creating the table with data entry.- Creating a table using a wizard.- Field properties.- Editing your data.- Record navigation and editing.- Printing and deleting tables.- 5 Creating a Form.- Using the Form Wizard.- Manually designing a form.- Setting the record source.- Form properties.- Using the Toolbox.- Form types.- Form properties.- 6 Queries.- Building a simple query.- Selecting fields.- Sorting records.- Showing and hiding fields.- Selecting records by using the Criteria row.- Using expressions and functions in criteria statements.- Generating temporary fields in a query.- Using parameters in a query.- Using a query to update information.- Creating a crosstab query.- Using forms for parameter queries.- 7 Basic Reports.- Types of report.- Creating a new report using the AutoReport feature.- Changing the design of a report.- Using the expression builder in reports.- Adding calculated fields to a report.- Creating a report from scratch.- 8 SQL.- Using SQL.- Key SQL statements.- Adding SQL to Access objects.- SQL specific queries.- Creating a table using a data-definition query.- Creating a union query.- Creating a subquery.- 9 Using Multiple Tables.- Creating relationships.- What is referential integrity?.- What does cascade related mean?.- Using multiple tables with queries.- Using multiple tables with forms and subforms.- Using AutoNumber fields as primary keys.- Designing reports for multiple tables.- 10 Using Macros.- Macro design screen elements.- Creating a macro.- Setting conditions within a macro.- Adding a macro to an existing button.- Using macro names with macro groups.- 11 VB Modules.- Objects and events.- Displaying a message.- Asking for a value.- Setting values on a form using Visual Basic code.- Using a logical statement within a procedure.- 12 Further Reading.