Access 2016 Part 1 - eBSI Export Academy
Access 2016 Part 1 - eBSI Export Academy
Access 2016 Part 1 - eBSI Export Academy

 

Book a Consultation

Access 2016 Part 1

eBSI Export Academy
€40.00
€40.00
Tax included. Shipping calculated at checkout.

The Microsoft Access 2016 Part One program covers all the basics, including:

  • An introduction to the Access interface
  • The basics of creating a database with tables, forms, queries, and reports
  • Table management tools, including data normalization and the Relationships window
  • Techniques for importing and exporting data with Access

Course Topics:

Lesson 1:
Getting Started with Access

  • Microsoft Access 2016
  • Access Files
  • Opening Databases
  • Access Web Apps
  • The Access 2016 Application Window
  • Tables
  • Forms and Views
  • Queries
  • Reports
  • The Ribbon Interface
  • Activity 1-1
  • Database Templates
  • Web App Templates
  • Save Options
  • Field Definition
  • Methods to Create a Form
  • Form Object Views
  • Form Sections
  • Modifying Existing Forms
  • Saving Forms
  • Deleting Forms
  • Access Web App Views
  • Activity 1-2
  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3
  • Summary
  • Review Questions

Lesson 2:
Working with Table Data

  • AutoCorrect
  • Commit, Save, and Undo
  • Quick Search
  • The Find and Replace Dialog Box
  • Datasheet Totals
  • Activity 2-1
  • Adding New Records
  • Updating Records with a Query
  • Append Queries
  • Navigating Through Records
  • Printing Records
  • Activity 2-2
  • The Sort Feature
  • The Filter Feature
  • Filter Commands
  • The Group Feature
  • Activity 2-3
  • Lookup Fields
  • The Property Sheet Pane
  • Activity 2-4
  • Summary
  • Review Questions

Lesson 3:
Querying a Database

  • Query Views
  • The Simple Query Wizard
  • Types of Queries
  • The Run Command
  • Query Design
  • Saving Queries
  • Deleting Queries
  • Renaming Queries
  • Activity 3-1
  • Query Criteria
  • Comparison Operators
  • Logical Operators
  • Sorting Query Results
  • Grouping Query Results
  • Formatting Query Fields
  • The Zoom Dialog Box
  • Activity 3-2
  • Arithmetic Operators
  • Adding Calculated Fields
  • Adding Conditional Logic
  • Activity 3-3
  • Summary
  • Review Questions

Lesson 4:
Creating Advanced Queries

  • Parameter Queries
  • Wildcards in a Parameter Query
  • The Ampersand Operator
  • Activity 4-1
  • Action Queries
  • Types of Action Queries
  • Activity 4-2
  • The Find Duplicates Query Wizard
  • The Find Unmatched Query Wizard
  • Activity 4-3
  • Crosstab Queries
  • Multiple Table Queries
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5:
Generating Reports

  • Report Creation Tools
  • Using Application Parts to Create Reports
  • Report Views
  • The Report Wizard
  • Saving a Report
  • Modifying an Existing Report
  • Deleting a Report
  • Activity 5-1
  • Report Sections
  • Adding Controls
  • Modifying Control Properties
  • Managing Labels
  • Inserting Images
  • Activity 5-2
  • Galleries
  • Themes
  • Activity 5-3
  • Adding a Header or Footer
  • Inserting Page Numbers
  • Page Setup Options
  • The Print Preview Tab
  • Activity 5-4
  • Summary
  • Review Questions

Lesson 6:
Customizing the Access Environment

  • Access Options
  • Activity 6-1
  • Summary
  • Review Questions

Lesson 7:
Designing a Relational Database

  • Relational Databases
  • The Relational Database Design Process
  • The Statement of Purpose
  • Existing Data
  • Guidelines for Determining Fields
  • Business Rules
  • Guidelines for Grouping Fields into Tables
  • Primary Keys
  • Foreign Keys
  • Composite Keys
  • Table Relationships
  • Activity 7-1
  • Table Creation Options
  • Importing Tables from Other Databases
  • Creating Tables with Templates
  • Table Views
  • Data Types
  • Inserting Fields
  • Quick Start Fields
  • Deleting Fields
  • Calendar for Picking Dates
  • The Lookup Wizard
  • The Table Properties Dialog Box
  • Activity 7-2
  • Renaming a Table
  • Changing Field Captions
  • Changing Field Sizes
  • Configuring Fields to Auto-Increment
  • Setting the Default Value for a Field
  • Activity 7-3
  • The Relationships Window
  • Referential Integrity
  • Guidelines for Enforcing Referential Integrity
  • The Edit Relationships Dialog Box
  • Join Lines
  • Relationship Report
  • Activity 7-4
  • Summary
  • Review Questions

Lesson 8:
Joining Tables

  • Query Joins
  • Inner Joins
  • Outer Joins
  • The Join Properties Dialog Box
  • Activity 8-1
  • Joining Tables with No Common Fields
  • Activity 8-2
  • Self-Joins
  • The Alias Property
  • Activity 8-3
  • Subdatasheets
  • Activity 8-4
  • Subqueries
  • Activity 8-5
  • Summary
  • Review Questions

Lesson 9:
Organizing a Database for Efficiency

  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Denormalization
  • The Table Analyzer Wizard
  • Activity 9-1
  • Many-to-Many Relationships
  • Junction Tables
  • Activity 9-2
  • Summary
  • Review Questions

Lesson 10:
 Sharing Data Across Applications

  • Data Importing
  • The Get External Data Wizard
  • Delimiters
  • Activity 10-1
  • Data Exporting
  • Activity 10-2
  • Exporting Access Data to Excel
  • Activity 10-3
  • The Microsoft Word Mail Merge Wizard
  • Merge Fields
  • The Mail Merge Task Pane
  • Activity 10-4
  • Summary
  • Review Questions

Lesson 11:
Advanced Reporting

  • Report Design Elements
  • Report Design Tools
  • The Group, Sort, and Total Pane
  • The Field List Pane
  • Adding a Background Image to a Report
  • Activity 11-1
  • Report Format Tools
  • Report Control Properties
  • Report Pagination
  • Activity 11-2
  • Data Bars
  • Charts
  • Activity 11-3
  • Calculated Fields
  • Activity 11-4
  • Subreports
  • Activity 11-5
  • Summary
  • Review Questions

Lesson 12:
Additional Reporting Options

  • The Label Wizard
  • Activity 12-1
  • Publishing a Report as PDF
  • Activity 12-2
  • Summary
  • Review Questions