Ready to Learn More

Microsoft Access 2016

Objective:

Microsoft Access 2016 is a database management system and is a part of Microsoft Office 2016. Learn the features of the latest version of this powerful program that allows users to store and track large amounts of data, and analyze the data for various applications. Discover how to use database knowledge to track and analyze information

Learn to create meaningful reports and share valuable information

Course Outline

Introduction
  • Creating a desktop database
  • Importing and exporting data
  • Navigating the user interface
  • Working with data in a datasheet
  • Configuring Access options
  • Linking Access to external data
  • Compacting, repairing, and encrypting a database
Creating basic tables and queries
  • Creating tables for your data
  • Creating a table in Datasheet view
  • Choosing a field data type
  • Adding validation and calculated fields to your tables
  • Adding a table validation rule
  • Adding a calculated field
  • Indexing a table
  • Linking tables together with relationships
  • Creating a manual relationship
  • Creating a select query
  • Creating a query by selecting specific fields
  • Joining multiple tables in a query
  • Working with query criteria
  • Filtering and sorting a field
  • Adding multiple criteria to a query
  • Adding parameters to queries
  • Working with totals and crosstab queries
  • Cross tabulating data
Designing forms and reports
  • Creating continuous form
  • Working with form in layout view
  • Creating a datasheet with conditional formatting
  • Creating a single record form
  • Creating a single record form by using the Split Form Template
  • Creating a parent/child form
  • Creating a parent/child pop-up form by using the Form Wizard
  • Tying your forms together with a navigation form
  • Creating a single record report
  • Creating a tabular report with grouping
  • Creating a continuous report with conditional formatting
  • Creating a parent/child report
Creating and sharing a Web App
  • Signing in to Office 365
  • Creating a blank Web App
  • Opening an existing Web App
  • Importing data from a spreadsheet
  • Importing data from an Access desktop database
  • Navigating a Web App with the table selector
  • Navigating a Web App with Navigation pane
  • Launching a Web App
  • Opening a database in Access from Team Site
  • Working with views
  • Working with datasheet view
  • Working with List Details view
  • Adding a new blank table
  • Creating a lookup
  • Creating a summary view
  • Creating a Web App from a template

DURATION:1 Full day (9 am to 5 pm)

Scedule:

Please contact OptionTrain Tel: (416) 486-6555 E-mail: info@optiontrain.com