State Employees: Training Classes for ND State Employees
Access 2010 Module 1
Prerequisite
Basic computer skills - use of mouse, keyboard, and understanding of Windows.
Lesson 1: Database Fundamentals
- Introduction to Access
- Identifying Database Components
- Designing Data Tables
- Relational Database Design
Lesson 2: Access Objects
- Starting Access
- Database Window Layout and Features
- Examining Tables
- Examining Queries
- Examining Forms
- Examining Reports
- Quitting Access
Lesson 3: Creating Databases and Tables
- Creating Databases
- Using Database Wizards to Create Databases
- Creating Blank Databases
- Choosing a File Format
- Creating Tables and Assigning a Primary Key using the Table Design Window
- Creating Tables using the Table Wizard
Lesson 4: Working with Table Data
- Overview of Working with Table Data
- Modifying Datasheet Layouts
- Changing Column Widths
- Moving Columns
- Hiding and Showing Columns
- Working with Table Records
- Adding Records
- Editing Records
- Deleting Records
- Sorting Records
- Navigating Through Records
Lesson 5: Working with Table Structure
- Modifying Table Design
- Adding, Deleting and Moving Fields
- Changing Field Names
- Modifying Field Properties
- Limiting Field Size
- Setting Field Formats
- Using Input Masks
- Setting Required Properties
- Specifying Data Validation for Fields
Lesson 6: Locating Information
- Finding Records
- Overview of Filters
- Using Comparison Operators
- Using Filters
- Filtering by Selection
- Filtering by Excluding Selection
- Filtering by Form
- Filtering for Input
Lesson 7: Working with Related Tables
- Overview of Table Relationships
- Identifying Table Keys
- Understanding Relationship Types
- Establishing Relationships
- Establishing One-to-Many Relationships
- Establishing Many-to-Many Relationships
- Enforcing Referential Integrity
- Creating Lookup Fields
- Using Lookup Fields to Add Data
- Modifying Lookup Fields
- Using Subdatasheets
Lesson 8: Using Select Queries
- Overview of Queries
- Creating Select Queries
- Using the Query Design Window
- Using the Simple Query Wizard
- Refining Query Results
- Using Criteria in Select Queries
- Modifying Select Queries
