Microsoft Access 2007 Content

Introduction to Access 2007

Chapter 1:  Getting started

  • Database concepts
  • Exploring the Access environment
  • Getting help

Chapter 2:  Databases and tables

  • Planning and designing databases
  • Exploring tables
  • Creating tables

Chapter 3:  Fields and records

  • Changing the design of a table
  • Finding and editing records
  • Organizing records

Chapter 4:  Data entry rules

  • Setting field properties
  • Working with input masks
  • Setting validation rules

Chapter 5:  Basic queries

  • Creating and using queries
  • Modifying query results and queries
  • Performing operations in queries

Chapter 6:  Using forms

  • Creating forms
  • Using Design view
  • Sorting and filtering records

Chapter 7:  Working with reports

  • Reports
  • Modifying and printing reports

Intermediate Access 2007

Chapter 1:  Relational databases

  • Database normalization
  • Relating tables
  • Implementing referential integrity

Chapter 2:  Related tables

  • Lookup fields
  • Modifying lookup fields
  • Subdatasheets

Chapter 3:  Complex queries

  • Joining tables in queries
  • Calculated fields
  • Summarizing and grouping values

Chapter 4:  Advanced form design

  • Adding unbound controls
  • Adding Graphics
  • Adding calculated values
  • Adding combo boxes
  • Advanced form types

Chapter 5:  Reports and printing

  • Customized headers and footers
  • Adding calculated values
  • Printing
  • Labels

Chapter 6:  Charts

  • Charts in forms
  • Charts in reports

Chapter 7:  PivotTables and Pivot Charts

  • PivotTables
  • Modifying PivotTables
  • Pivot Charts
  • PivotTable forms

Advanced Access 2007

Chapter 1:  Querying with SQL

  • SQL and Access
  • Discussing Structured Query Language
  • Examining an SQL statement in Access
  • Writing SQL statements
  • Writing an SQL SELECT statement
  • Using the WHERE clause
  • Displaying matching records from related tables
  • Finding unmatched records

Chapter 2:  Advanced queries

  • Creating Crosstab queries
  • Using the Crosstab Query Wizard
  • Creating parameter queries
  • Creating a single-criterion parameter query
  • Creating a query with multiple parameters
  • Using a wildcard in a parameter query
  • Using action queries
  • Adding records to a table with an append query
  • Deleting records with a delete query
  • Modifying records with an update query
  • Creating a Make Table query

Chapter 3:  Macros

  • Creating, running, and modifying macros
  • Modifying a macro
  • Attaching macros to the events of database objects
  • Attaching a macro to the Open event of a form
  • Attaching a macro to a command button

Chapter 4:  Advanced macros

  • Creating macros to provide user interaction
  • Creating a data validation macro
  • Creating a data-entry macro
  • Creating macros that require user input
  • Creating a macro that runs a parameter query
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer
  • Importing a database object by using a macro
  • Exporting data to a spreadsheet by using a macro

Chapter 5:  Importing, exporting, and linking

  • Importing objects
  • Importing multiple objects
  • Importing an object from Excel
  • Using a Saved Import specification
  • Importing a CSV file
  • Exporting objects
  • Exporting an object
  • Using a Saved Export specification
  • Linking Access objects
  • Linking to an Access table
  • Updating the links
  • Linking to an Excel workbook

Chapter 6: Database management

  • Optimizing resources
  • Converting a database to a prior version
  • Analyzing performance
  • Splitting a database
  • Using the Compact and Repair Database utility
  • Backing up a database
  • Protecting databases
  • Encrypting a database with a password
  • Removing a password and encryption
  • Setting options and properties
  • Setting Access Options
  • Creating and populating properties

Chapter 7: Internet integration

  • Hyperlink fields
  • Creating a hyperlink field
  • Inserting data in a hyperlink field
  • Modifying data in a hyperlink field
  • Working with Outlook 2007
  • Collecting data via e-mail

Application Development

Chapter 1:  Application design

  • Identifying the objectives of an application
  • Resolving design issues in an application
  • Planning application objects

Chapter 2:  Advanced form design

  • Creating and using grouped controls
  • Adding an option group control to a form
  • Using the Tab control
  • Adding a tab control to a form
  • Making a form read-only
  • Creating a Subform
  • Modifying a Subform

Chapter 3:  Dialog boxes and macros

  • Creating a dialog box
  • Working with macro groups
  • Creating a macro group
  • Attaching a macro group to an event
  • Automating navigation across forms
  • Creating a combo box to find records
  • Creating command buttons for navigating forms
  • Opening a form to a specific record
  • Creating a macro to open a form to a specific record

Chapter 4:  Application navigation

  • Working with switchboards
  • Creating a switchboard
  • Modifying a Switchboard
  • Working with splash screens
  • Making a splash screen
  • Automating a splash screen

Chapter 5:  Custom menus and navigation groups

  • Custom menu forms
  • Examining and modifying a custom menu form
  • Customizing the Quick Access Toolbar
  • Custom groups in the Navigation Pane
  • Creating custom categories and groups
  • Adding objects to custom navigation groups
  • Changing Navigation Pane display properties