Microsoft Access 365

by OptionTrain College Of Management & 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 & Technology Logo

img Duration

1 Day

Course Details

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.

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
  • Toronto Branch

    20 Eglinton Ave East, Suite 390, Toronto

Check out more MS Access courses in Canada

ORION Logo

Microsoft Word 365 (Intermediate/ Advanced)

This intermediate-level course is designed to help users who are familiar with Word’s basic features to take their skills to the next level.

by ORION [Claim Listing ]
New Horizons London Logo

Access 2016 - Part 1

In this course, students will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. This course may earn a Credly Badge.

by New Horizons London [Claim Listing ]
DJH Training & Application Solutions Inc. Logo

MS PowerPoint

MS PowerPoint course is offered by DJH Training & Application Solutions Inc. DJH Training & Application Solutions Inc. provides its clients with high quality computer training, support and application development services.

by DJH Training & Application Solutions Inc. [Claim Listing ]
ES Computer Training Logo

Microsoft Word

All of the necessary learning tools are provided, including class notes, computers, and software. All we require is a meeting room. Our unique training style will ensure no topic is unexplored, no question remains unanswered, and all participants exit the course more knowledgeable than they entered...

by ES Computer Training [Claim Listing ]
New Horizons Computer Learning Centre of Toronto Logo

Excel Training (Part 1)

What makes Excel so popular is its breadth and depth of functionality. From simple sums and equations to pivot tables and complex analysis, there are endless ways to use this powerhouse program.

by New Horizons Computer Learning Centre of Toronto [Claim Listing ]
  • Price
  • Start Date
  • Duration

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