Access 2010 Foundation Courseware

Microsoft Access 2010 Foundation Training Course Teaching Materials

Computer Courseware Training Materials

Training Course Outline

Microsoft Access 2010 Database Concepts

  • Database
  • Relational Database
  • Table
  • Record (Row)
  • Field (Column)
  • Data Types

Opening a Database & Security Issues

  • Opening a Database
  • Trusted Locations
  • Setting the Default Folder Location
  • Closing the Access Program

Tables, Fields and Field Types

  • Creating a New Blank Database
  • Adding Fields and Setting the Field Type
  • About Access Data Types
  • Closing and Naming a Table

Table Navigation & Modification

  • Opening a Table within a Database
  • ‘Datasheet View’ vs. ‘Design View’
  • Adding Records to a Table
  • Navigating Through Records
  • Adjusting Column Width
  • Automatically Resizing a Column Widths
  • Rearranging the Column Order

Field Properties

  • Field Properties
  • Input Masks
  • Validating Numbers
  • Validating Dates
  • Data Entry Required / Not Required
  • Field Properties – Reference Materials
  • Field Properties – Logical Operators
  • Field Properties – General
  • Field Properties – Format
  • Field Properties – Input Mask Characters

Manipulating Tables & Records

  • Renaming a Table
  • Editing Data within a Record
  • Deleting Data within a Record
  • Using the Undo Command
  • Deleting a Single Record
  • Deleting Multiple Records
  • Deleting a Table

Primary Keys and Indexing

  • Defining a Primary Key
  • Indexing
  • Creating a Single-Field Index
  • Creating a Multiple-Field Index
  • Deleting Multi-Field Indexes

Filtering

  • Text Filters
  • Single Filter
  • Multiple Filters

Sorting

  • Sorting Records
  • Removing a Sort
  • Sorting on Multiple Fields

Searching

  • Searching Through Records in Access 2010

Access 2010 Relationships

  • One-To-Many Relationship
  • Many-To-Many Relationship
  • One-To-One Relationships
  • Creating Relationships between Tables
  • Referential Integrity
  • Cascade Options
  • Cascade Update Related Fields
  • Cascade Delete Related Records
  • Enabling Cascade Options
  • Deleting Relationships

Microsoft Access 2010 Forms

  • Creating Forms in Access 2010
  • Modifying Forms
  • Saving a Form
  • Access 2010 Form View
  • Adding and Formatting Attachments
  • Modifying Data within Records
  • Deleting Records using a Form
  • Adding Records using a Form
  • Closing Forms
  • Deleting a Form
  • Filtering a Form
  • Removing a Filter from a Form
  • Inserting and Modifying a Form Header
  • Inserting and Modifying a Form Footer

 

Access 2010 Foundation Courseware
1 (20%) 2 votes