Access XP/2000 Level 1

Prerequisites: Windows Level 1 or equivalent knowledge

This course teaches you how to create template-based databases, create a blank
database, and create tables in Table Design view. You will also learn how to sort records by multiple fields, find records, and filter by selection. This course teaches you to design queries in Query Design view, add a calculated field to a query, and create forms and reports. You will also work with form sections and add graphics to forms.

Register Online

Database Fundamentals
Identifying Database Components
Designing Data Tables
Examining Relational Database Design
Examining Access Objects
Starting Access and Exploring the Task Pane
Examining Tables
Examining Queries
Examining Forms
Examining Reports
Creating Databases and Tables
Creating New Databases
Using a Database Wizard
File Format Considerations
Creating Tables
Assigning a Primary Key
Using the Table Wizard
Working with Table Records
Modifying Datasheet Layout
Changing Column Width
Moving Columns
Hiding and Showing Columns
Adding Records
Sorting Records
Working with Table Structure
Modifying Table Design
Adding and Deleting Fields
Moving Fields
Using the Name AutoCorrect Feature
Renaming Fields
Setting Field Properties
Limiting Field Size
Setting Field Formats
Locating Information
Finding Records
Understanding Comparison Operators
Using Filters
Creating Filters by Form
Creating Filters for Input
Using Select Queries
Creating Select Queries
Working in Query Design View
Using the Simple Query Wizard
Working with Result Sets
Sorting Fields in Result Sets
Performing Calculations in Queries
Querying for Duplicate Records or Values
Creating and Using Forms
Creating Forms Using AutoForm
Creating Forms Using the Form Wizard
Working with Controls
Working with Control Properties
Working with Form Properties
Adding Records Using Forms
Printing Forms
Creating and Using Reports
Creating Reports Using AutoReport
Working with Report Sections
Modifying Report Controls
Working with Control Properties
Creating Reports Using the Report Wizard
Printing Reports