Smart Trainer LMS

Office 2013 Access P1

0 rate

0 purchased SKU: SKU_ZUJDE17889

Available ONLY TO SMART TRAINER USERS

To Purchase this Product you must be a customer BUY A SMART TRAINER

10 USD Become a customer

Course Outline

Lesson 01 - Getting Started with Access

Topic A: Orientation to Microsoft Access

Transform Data into Knowledge

Using Access Instead of Excel

Using Access Instead of Other Databases

Record Navigation Bar

A Query Join

Topic B: Create a Simple Access Database

Access Help Window

Why Use a Database Application?

Demo 1-2: Launching Access and Opening a Database

Access 2013 Window Components

Demo 1-3: Navigating and Editing Data in Tables

Forms and Views

Demo 1-4: Navigating and Editing Data in a Form

The Capable Query

Demo 1-5: Using Queries

Demo 1-6: Using Reports

Demo 1-7: Exploring Access Ribbon Commands

Create a Simple Access Database

Saving Options

Initial Views

Field Data Types

Primary Key

Object Names

Demo 1-8: Creating a New Database

Demo 1-9: Creating and Testing a Form

Topic C: Get Help in Microsoft Access

Demo 1-10: Getting Help in Access

Lesson 02 - Working with Table Data

Table Relationship

Topic A: Modify Table Data

Topic B: Sort and Filter Records

The Property Sheet

The Relationships View

Modify Table Data

Demo 2-1: Undoing Record Modifications

Quick Search

Demo 2-2: Using Quick Search to Find and Modify Records

Demo 2-3: Using Find and Replace to Modify Records

Adding Calculations to the Totals Row

Demo 2-4: Adding a Totals Row to a Datasheet

Records in Ascending Order by Dept

Filtering Records

Demo 2-5: Sorting and Filtering Records

Topic C: Create Lookups

Foreign Keys

Referential Integrity

Demo 2-6: Examining the Purpose of a Primary Key

Demo 2-7: Configuring a Form Lookup Field

Lesson 03 - Querying a Database

Query Object Views

Simple Query Wizard

Using Query Design to Create a Query

Topic B: Sort and Filter Data in a Query

Query Criteria

A Comparison Operator

Logical Operators

Zoom Dialog Box

Topic C: Perform Calculations in a Query

Topic A: Join Data from Different Tables in a Query

Types of Queries

Demo 3-1: Creating a Query by Using the Query Wizard

Types of Queries (cont.)

Demo 3-2: Creating a Query by Using Query Design

Wildcards

Like Operator Examples

Demo 3-3: Filtering a Query Using a Comparison Operator

Demo 3-4: Filtering a Query Using a Wildcard

Demo 3-5: Filtering a Query Using a Date Range

Calculations in a Query

Demo 3-6: Performing Calculations

Lesson 04 - Creating Advanced Queries

Topic A: Create Parameter Queries

A Parameter Query Displays a Prompt

Action Query Update Expression

Create Parameter Queries

Matching a Parameter Query

Using the Ampersand Operator

Demo 4-1: Creating a Parameter Query

Demo 4-2: Using Wildcards in a Parameter Query

Demo 4-3: Creating a Query with Multiple Parameters

Topic B: Create Action Queries

Action Queries

Demo 4-4: Creating Action Queries

Topic C: Create Unmatched and Duplicate Queries

Find Unmatched and Find Duplicate Queries

Demo 4-5: Creating Queries to Search for Unmatched and Duplicate Records

Topic D: Summarize Data

Crosstab Queries & Display Details

Analyzing Country of Origin

Demo 4-6: Creating a Crosstab Query

Lesson 05 - Generating Reports

Topic A: Create a Report

Report Creation Tools

The Report Wizard

Topic B: Add Controls to a Report

Sections in a Report

The Completed Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Report Object Views

Demo 5-1: Creating Reports

Demo 5-2: Using the Report Wizard

Demo 5-3: Adjusting Report Control Layout

Galleries and Themes

Demo 5-4: Enhancing the Appearance of a Report

Page Setup Options

Print Preview Tab

Demo 5-5: Preparing a Report for Print

Lesson 06 - Customizing the Access Environment

Access Options

Topic A: The Access Options Dialog Box

Demo 6-1: Setting Access Options

Additional Information

Author

Administrator

Lessons

Level

Course detail

Office 2013 Access P1

Course Outline

Additional Information

Administrator

Beginner

Related Courses

Shopping cart (0)

Office 2013 Access P1

Course Outline

Additional Information

Administrator

Beginner

Related Courses