Computer Training
Course Objectives: Intermediate Microsoft Access 2007
Compare your skills and experiences to these objectives to see if this course would be appropriate for you to take.
- Finding and Replacing Data
- Sorting Records Using Common Filters
- Filtering by Selection
- Filtering by Form
- Creating an Advanced Filter
- Adjusting and Rearranging Rows and Columns
- Changing Gridline and Cell Effects
- Changing the Datasheet Font
- Freezing a Column
- Hiding a Column
- Understanding Field Properties
- Indexing a Field
- Adding a Primary Key to a Table
- Inserting, Deleting and Reordering Fields
- Adding Field Descriptions and Captions
- Changing 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
- Understanding Different Types of Queries
- Creating a Multiple Table Query
- Creating a Calculated Field
- Working with Expressions and the Expression Builder
- Using an IIf Function
- Summarizing Groups of Records
- Display Top or Bottom Values
- Parameter Queries
- Finding Duplicate Records
- Finding Unmatched Records
- Crosstab Queries
- Delete Queries
- Make-Table Queries
- Update Queries
- Creating and Using a Form
- Understanding Form Views
- Modifying a Form in Layout View
- Form Design View Basics
- Changing Tab Order
- Working with Control Properties
- Control Property Reference
- Working with Form Properties
- Form Property Reference
- Changing a Control’s Data Source
- Creating a Calculated Control
- Changing a Control’s Default Value
- Creating a Subform
- Modifying and Working with Subforms
- Creating a Report
- Working in Layout View
- Adding a Logo
- Working in Design View
- Adjusting Page Margins and Orientation
- Adding Page Numbers and Dates
- Grouping and Sorting
- Summarize Data using Totals
- Understanding Report Sections