Microsoft Access 2013 Basic Level

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Course Content

Expand All

Basic Course Introduction 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Introduction to Basic Level

1.0 Getting Started with Access 2013 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

1.1 Starting and Closing Access

1.2 Identifying Tabs, Ribbons, QAT and Backstage

1.3 Identifying Account Information and Switching Users

1.4 Opening Existing and Recently Used Databases

1.5 Identifying the Primary Access Objects: Tables, Queries, Forms & Reports

1.6 Exploring the Different Access Views

1.7 Understanding Five Essential Steps for Database Design

1.8 Creating a New Database

1.9 Getting Help

2.0 Learning the Essential Access Building Blocks-Tables 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

2.1 Creating Tables

2.2 identifying Data Types

2.3 Setting Basic Properties: Field Size, Format, Caption and Default Value

2.4 Setting Additional Properties: Required, Allow Zero Length, Indexed and Others

2.5 Controlling Data Using Input Masks

2.6 Establishing a Primary Key

2.7 Creating Table Relationships

2.8 Establishing Referential Integrity

2.9 Identifying Table Relationships

3.0 Working with Access Data 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

3.1 Entering Table Data

3.2 Deleting and Changing Records

3.3 Using Find, Replace and Go To Features

3.4 Sorting and Filtering Records

3.5 Modifying Tables: Rename, Copy, Delete, Save As

3.6 Viewing Data from Related Tables

4.0 Using Queries 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

4.1 Introducing Queries

4.2 Creating a Select Query Using the Wizard

4.3 Building a Select Query in Design View

4.4 Adding Criteria to a Query

4.5 Asking And/or Questions

4.6 Using Wildcards to Find Data

4.7 Setting Query Properties

5.0 Designing Reports 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

5.1 Using an Access Form

5.2 Creating a Form Using The Form Wizard

5.3 Creating a Form FromScratch

5.4 Improving a Form Using The Form Design Tools

5.5 Adding a Calculated Field

5.6 Looking at Form Properties

5.7 Using the Data Entry Property

6.0 Generating Reports 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

6.1 Viewing an Access Report

6.2 Creating an Access Report from Scratch

6.3 Creating an Access Report Using the Wizard

6.4 Looking at Report Properties

6.5 Applying a Theme to a Report

6.6 Preparing a Report for Print

6.7 Making Changes to a Report