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

University of Ottawa’s Professional Development Institute Logo

Influential PowerPoint Presentations

A well-thought-out and constructed PowerPoint presentation can be an extremely effective way of communicating complex information quickly and efficiently to a range of audiences including senior officials and decision makers.

by University of Ottawa’s Professional Development Institute [Claim Listing ]
University Of Calgary Logo

Microsoft Office Specialist

You will focus on the core tools that you use; completing any three of the five courses will earn you a Microsoft Office Specialist digital badge from the University of Calgary.

by University Of Calgary [Claim Listing ]
Qualitemps Logo

Access for Intermediate Users

Microsoft's Access software is a very versatile relational database that allows the collection and management of a large volume of data. 

by Qualitemps [Claim Listing ]
The Great Canadian Training & Consulting Company Logo

Excel Level 3

Designed for users who are very comfortable in Excel and want to go beyond what the average Excel user can do. Set yourself apart from your colleagues and impress your less Excel-savvy bosses. Accomplish more complex tasks and automate repetitive ones.

by The Great Canadian Training & Consulting Company
  • Price
  • Start Date
  • Duration
New Horizons London Logo

Microsoft Visio 2019/2021: Part 1 (v1.1)

In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes.

by New Horizons London [Claim Listing ]

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