Outlines
Microsoft Access Outline
Chapter One: The Fundamentals
- Introduction to Databases
- What´s New in Access?
- Starting Access and Opening a Database
- Understanding the Access Program Screen
- Using Toolbars
- Hiding, Displaying, and Moving Toolbars
- Filling Out Dialog Boxes
- Keystroke and Right Mouse Button Shortcuts
- Opening and Modifying Database Objects
- Working with Multiple Windows
- Tour of a Table
- Adding, Editing, and Deleting Records
- Tour of a Form
- Tour of a Query
- Tour of a Report
- Previewing and Printing a Database Object
- Selecting Data
- Cutting, Copying, and Pasting Data
- Using Undo
- Checking Your Spelling
- Getting Help from the Office Assistant
- Changing the Office Assistant and Using the “What´s This” Button
- Using the Zoom Box
- Closing a Database and Exiting Access
- Chapter One Review
|
Beginning
|
Chapter Two: Creating and Working with a Database
- Planning a Database
- Creating a Database Using the Database Wizard
- Creating a Blank Database
- Creating a Table Using the Table Wizard
- Modifying a Table and Understanding Data Types
- Creating a New Table from Scratch
- Creating a Query in Design View
- Modifying a Query
- Sorting a Query using Multiple Fields
- Developing AND and OR Operators
- Creating a Form with the Form Wizard
- Creating a Report with the Report Wizard
- Creating Mailing Labels with the Label Wizard
- Database Object Management
- File Management
- Compacting and Repairing a Database
- Converting an Access 97 Database
- Chapter Two Review
|
Beginning
|
Chapter Three: Finding, Filtering, and Formatting Data
- Finding and Replacing Information
- Sorting Records
- Filtering by Selection
- Filtering by Form
- Creating an Advanced Filter
- Adjusting Row Height and Column Width
- Rearranging Columns
- Changing Gridline and Cell Effects
- Freezing a Field
- Hiding a Column
- Changing the Datasheet Font
- Chapter Three Review
|
Intermediate
|
Chapter Four: Working with Tables and Fields
- Understanding Field Properties
- Indexing a Field
- Adding a Primary Key to a Table
- Inserting, Deleting, and Reordering Fields
- Changing a Field´s Data Type
- Using Field Descriptions
- Adding a Caption
- Change the Field Size
- Formatting Number, Currency, and Date/Time Fields
- Formatting Number, Currency, and Date/Time Fields by Hand
- Formatting Text Fields
- Setting a Default Value
- Requiring Data Entry
- Validating Data
- Creating an Input Mask
- Creating a Lookup Field
- Creating a Value List
- Modifying a Lookup List
- Chapter Four Review
|
Intermediate
|
Chapter Five: Creating Relational Databases
- Understanding Table Relationships
- Creating Relationships between Tables
- Enforcing Referential Integrity
- Testing Referential Integrity and Deleting a Relationship
- Understanding of Relationship Types
- Chapter Five Review
|
Intermediate
|
Chapter Six: Working with Queries
- A Quick Review
- Creating a Multiple Table Query
- Creating a Calculated Field
- Using Expressions
- Using an IIF Function
- Summarizing Groups of Records
- Using Criteria
- Display Top or Bottom Values
- Parameter Queries
- Finding Duplicate Records
- Finding Unmatched Records
- Crosstab Queries
- Delete Queries
- Append Queries
- Make Table Queries
- Update Queries
- Chapter Six Review
|
Intermediate
|
Chapter Seven: Working with Forms
- Creating a Form with AutoForm
- Modifying a Form
- Adding and Deleting Fields
- Moving and Sizing Controls
- Changing the Tab Order
- Working with Control Properties
- Control Property Reference
- Working with Form Properties
- Form and Report Property Reference
- Working with Multiple Controls
- Adding, Cutting, Copying, and Pasting Controls
- Changing a Control´s Data Source
- Creating a Calculated Control
- Changing a Control´s Default Value
- Using the Control Wizard
- Creating a Subform
- Modifying and Working with Subforms
- Chapter Seven Review
|
Advanced
|
Chapter Nine: Working with Reports
- Creating a Report with AutoReport
- Modifying a Report
- Adding and Deleting Fields
- Moving and Sizing Controls
- Adjusting Page Margins and Orientation
- Adding Page Numbers and Dates
- Understanding Report Sections
- Grouping and Sorting Records
- Creating Calculated Controls
- Working with Section Properties
- Creating Charts with the Chart Wizard
- Chapter Nine Review
|
Advanced
|
Chapter Ten: Formatting Forms and Reports
- Formatting Fonts with the Formatting Toolbar
- Changing Text Alignment
- Using AutoFormat
- Changing Colors
- Applying Special Effects
- Using the Format Painter
- Adding Pictures and Lines
- Aligning Controls with One Another
- Changing a Control´s Formatting Properties
- Chapter Ten Review
|
Advanced
|
Chapter Eleven: Working with Macros
- Creating and Running a Macro
- Editing a Macro
- Working with Macro Groups
- Assigning a Macro to an Event
- Creating Conditional Expressions
- Assigning a Macro to a Keystroke Combination
- Macro Action Reference
- Chapter Eleven Review
|
Advanced
|
Chapter Twelve: Using Access with Other Programs
- Importing Information
- Exporting Information
- Importing Objects from another Access Database
- Linking Information from an External Source
- Analyzing Records with Microsoft Excel
- Exporting Records to Microsoft Word
- Mail Merging Records to Microsoft Word
- Using Hyperlink Fields
- Using OLE Object Fields
- Chapter Twelve Review
|
Advanced
|