Motivational Speaking, Business Coaching, Corporate Training, Cyber Security, Web Design, Consulting

Access Level 1 Outline

 

Lesson 1 -  Exploring Access

Working with Access

Starting Access

Using the Interface

Using the File Tab

Opening an Existing Database

Using the Ribbon

Using the Contextual Tabs

Using the Quick Access Toolbar

Using the Mini Toolbar

Using Database Objects

Using the Navigation Pane

Opening a Database Object

Using Tabbed Documents

Closing a Tabbed Document

Closing All Tabbed Documents

Using the Status Bar

Using the Options Dialog Box

Closing a Database

Exiting Access

 

Lesson 2 -  Creating Tables

Using Database Templates

Creating a New Database

Designing Tables

Creating a Table in Datasheet View

Creating a Table in Design View

Adding Field Names

Assigning Data Types

Saving a New Table

Adding a Field Description

Setting a Primary Key

Using Multi-valued Fields

 

Lesson 3 -  Working with Tables

Using Datasheet View

Navigating Fields in Tables

Using Field Templates

Adding Records

Moving through Records

Selecting Records

Editing Records

Deleting Records

Displaying a Totals Row in a Table

 

Lesson 4 -  Editing Tables

Changing the Row Height

Changing the Column Width

Changing a Font Attribute

Changing a Cell Effect

Using Alternate Background Colors

Selecting a Column

Moving a Column

Hiding a Column

Unhiding a Column

Freezing a Column

 

Lesson 5 -  Setting Field Properties

Using Field Properties

Limiting Field Size

Setting Number Formats

Setting Date/Time Formats

Setting Yes/No Formats

Setting Default Values

Setting Validation Rules

Creating an Input Mask - Wizard

Creating an Input Mask Manually

Creating a Custom Input Mask

Typing a Lookup List

Modifying Lookup Properties

 

Lesson 6 -  Working with Indexes

Viewing Indexes

Creating a Single Field Index

Creating a Multiple Field Index

Deleting an Index

Creating a Multiple Field Primary Key

 

Lesson 7 -  Creating Relationships

Using Related Tables

Creating a Relationship between Tables

Setting Referential Integrity

Viewing Subdatasheets

Deleting a Join Line

 

Lesson 8 -  Using Simple Queries

Using Queries and Recordsets

Using the Simple Query Wizard

Creating a Query in Design View

Opening a Query

Adding a Table to a Query

Joining Tables in a Query

Running a Query

 

Lesson 9 -  Modifying Query Results

Sorting a Query

Adding Criteria to a Query

Hiding a Field in a Query

Displaying a Totals Row in a Query

Adding a Record using a Query

Printing a Query

 

Lesson 10 -  Creating Basic Forms

Using Forms

Using the Form Button

Adding a Record using a Form

Using the Calendar for Date Picking

Using the Form Wizard

Viewing Records in a Form

Printing Records in a Form

Basing a Form on a Query

 

 

Lesson 11 -  Creating Basic Reports

Using Reports

Using the Report Button

Using Print Preview - Reports

Printing Pages of a Report

Using the Report Wizard

Changing Views in a Report

Grouping and Summarizing Report Data

Basing a Report on a Query

​