Access 2007 Introduction
**Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information**
Description: Students will learn how to design and create databases;
work with tables, fields, and records; sort and filter data;
and create queries, forms, and reports.
work with tables, fields, and records; sort and filter data;
and create queries, forms, and reports.
Days: 1
Prerequisites: Microsoft Windows XP Basic or Microsoft Windows Vista
Basic, or equivalent experience.
Unit 1: Getting started
Topic A: Database concepts
· Identifying database components
· Identifying the advantages of relational databases
Topic B: Exploring the Access environment
· Starting Access and examining the Access window
· Opening a database
· Using the Navigation Pane
· Examining a database table
Topic C: Getting help
· Using Help
Unit 2: Databases and tables
Topic A: Planning and designing databases
· Planning a database
· Creating a database from a template
· Creating a blank database
Topic B: Exploring tables
· Discussing views
· Examining a table in Datasheet view
· Navigating in a table in Datasheet view
· Examining a table in Design view
Topic C: Creating tables
· Creating a table by using the table templates
· Creating a table in Design view
· Adding fields and descriptions to a table
· Setting the primary key
· Saving the table
· Adding a record
· Copying, modifying, and deleting a table
· Creating a composite key
Unit 3: Fields and records
Topic A: Changing the design of a table
· Modifying field names
· Deleting and inserting fields
· Moving a field
· Using the Attachment data type
· Adding a total row
Topic B: Finding and editing records
· Finding and replacing a value
· Undoing changes
Topic C: Organizing records
· Sorting records by a single field
· Sorting records by multiple fields
· Using Filter By Selection
· Using Filter By Form
· Using Filter Excluding Selection
· Using Advanced Filter/Sort
· Deleting a record
Unit 4: Data entry rules
Topic A: Setting field properties
· Setting the Required property
· Using the Allow Zero Length property
· Setting the Field Size property
· Setting the Append Only property
Topic B: Working with input masks
· Creating an input mask
· Working with the Input Mask Wizard
Topic C: Setting validation rules
· Creating validation rules
· Setting validation text
Unit 5: Basic queries
Topic A: Creating and using queries
· Planning a query
· Using the Query Wizard
· Creating a query in Design view
· Saving and running the query
· Sorting query results
· Filtering a query by adding criteria
· Creating a query from a filter
Topic B: Modifying query results and queries
· Editing query results
· Adding fields to a query
· Finding records with empty fields
Topic C: Performing operations in queries
· Using comparison operators
· Using the OR condition
· Using the AND condition
· Using the * wildcard
· Using calculations in a query
· Totaling a group of records
· Using the Avg and Count functions
· Using the Min and Max functions
Unit 6: Using forms
Topic A: Creating forms
· Examining a form
· Creating a basic form
· Creating a form using the Form Wizard
Topic B: Using Design view
· Creating a form in Design view
· Adding controls
· Modifying properties
· Applying conditional formatting
Topic C: Sorting and filtering records
· Using a form to sort records
· Using a form to filter records
Unit 7: Working with reports
Topic A: Reports
· Examining a report
· Creating a basic report
· Creating a report using the Report Wizard
· Creating a report using Design view
Topic B: Modifying and printing reports
· Modifying a report in Design view
· Modifying a report in Layout view
· Grouping, sorting, and filtering a report
· Adding summary fields using the Report Wizard
· Modifying the layout and style of a report
· Printing a report
Price: $295
Or you can purchase our CW vBook training:
Or you can purchase our CW vBook training:
