Microsoft Access 365

by OptionTrain College of Management and Technology Claim Listing

Microsoft Access 365 is a database management system and is a part of Microsoft Office 365. 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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

OptionTrain College of Management and Technology Logo

img Duration

1 Day

Course Details

Microsoft Access 365 is a database management system and is part of Microsoft Office 365. 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 cross-tab 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 Panel
    • 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
  • Toronto Branch

    20 Eglinton Avenue E, Suite# 390, Toronto

Check out more MS Access courses in Canada

Working Skills Centre (WSC) Logo

Microsoft Word 2013 (Intro)

In this module the participants will learn basic computer word processing operations. They will be learning the fundamentals of MS Word 2013 including creating files, writing and editing documents.

by Working Skills Centre (WSC) [Claim Listing ]
ON-TRACK Corporate Training Ltd Logo

Microsoft Word (365 / 2019 / 2016 Level 1)

Microsoft Office Word is full of tools and capabilities that can help improve the quality of your academic work

by ON-TRACK Corporate Training Ltd [Claim Listing ]
Diamond Learning Logo

MS PowerPoint

MS PowerPoint course is offered by Diamond Learning. We are a group of highly qualified professionals from different industries. Diamond Learning is based in Saskatoon and offers training classes across western provinces of Canada.

by Diamond Learning [Claim Listing ]
Eccentrix Logo

Visio

Microsoft Visio is a tool for representing dozens of patterns and flows, used to graphically represent the sequential operation of a complex process, pattern, or system. Visio has many chart possibilities and visual scenarios to help you choose the right representation for your project.

by Eccentrix [Claim Listing ]
SETC Training Logo

Office Training

Our training includes document editing with MS Word, analyzing data in spreadsheets with MS Excel, creating rich diagrams with MS Visio, writing and editing emails with MS Outlook, and creating databases with MS Access.

by SETC Training [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy