Smart Trainer LMS

Office 2013 Access P2

0 rate

0 purchased SKU: SKU_PIQFX46730

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 - Designing a Relational Database

Topic A: Relational Database Design

Database Relationship

Relational Database Design Process

Statement of Purpose

Existing Data

Business Rules

Primary Keys

Primary and Foreign Keys

Composite Keys

One-to-One Relationships

One-to-Many Relationships

Relationships Window

Topic B: Create a Table

Calendar for Picking Dates

Lookup Wizard

Topic C: Create Table Relationships

Edit Relationships Dialog Box

Enforce Referential Integrity Options

Determine Fields

Group Fields into Tables

List of Data Types in Datasheet View

List of Data Types in Design View

Turn the Date Picker On or Off

Demo 1-2: Analyzing the Relational DB Design Process

Join Line

Relationship Report

Demo 1-3: Creating a Table Relationship

Lesson 02 - Joining Tables

Topic A: Create Query Joins

Query Joins

Join Properties Dialog Box

What the Join Options Return

Subquery Example

Subquery Expression Example

Inner Join

Left Outer Join

Right Outer Join

Demo 2-1: Creating Inner and Outer Joins

Topic B: Join Tables That Have No Common Fields

Demo 2-2: Joining Unrelated Tables

Topic C: Relate Data within a Table

Self Join

Demo 2-3: Creating a Self Join

Topic D: Work with Subdatasheets

Subdatasheet

Demo 2-4: Modifying Data in a Subdatasheet

Topic E: Create Subqueries

Demo 2-5: Creating Subqueries

Lesson 03 - Organizing a Database for Efficiency

Topic A: Data Normalization

First Normal Form

Second Normal Form

Third Normal Form

Denormalization

Table Analyzer Wizard

Topic B: Create a Junction Table

Junction Table

Topic C: Improve Table Structure

Demo 3-1: Running the Table Analyzer Wizard

Many-to-Many Relationship

Demo 3-2: Creating a Many-to-Many Relationship

Demo 3-3: Improving Table Structure

Lesson 04 - Sharing Data Across Applications

Topic A: Import Data into Access

External Data Tab—Import & Link Group

Get External Data Wizard

External Data Tab—Export Group

Topic D: Create a Mail Merge

Microsoft Word Mail Merge Wizard

Merge Fields

The Mail Merge Task Pane

Demo 4-1: Importing Data from a Text File

Demo 4-2: Importing Data from an Excel File

Topic B: Export Data to Text File Formats

Demo 4-3: Exporting Data to Text File Formats

Topic C: Export Access Data to Excel

Demo 4-4: Exporting Data to Excel

Demo 4-5: Merging Access Data with a Word Document

Lesson 05 - Advanced Reporting

Some Controls

The Group, Sort, and Total Pane

The Field List Pane

Rich Text Property

Report Format Options

Property Sheet Controls

Useful Control Properties

Keep Together Property Settings

Force New Page Property Options

Topic A: Organize Report Information

Report Controls Group

Demo 5-1: Making Report Design Modifications

Topic B: Format Reports

Report Arrange Options

Demo 5-2: Formatting a Report

Topic C: Include Control Formatting in a Report

Demo 5-3: Adding Data Bars to a Report

Topic D: Add a Calculated Field to a Report

Demo 5-4: Adding a Calculated Field to a Report

Topic E: Add a Subreport to an Existing Report

Demo 5-5: Adding a Subreport to an Existing Report

Additional Information

Author

Administrator

Lessons

Level

Course detail

Office 2013 Access P2

Course Outline

Additional Information

Administrator

Beginner

Related Courses

Shopping cart (0)

Office 2013 Access P2

Course Outline

Additional Information

Administrator

Beginner

Related Courses