Microsoft Access 2016/19

by DPA Communications Claim Listing

This course is for students who have never worked with an Access database before. The course introduces you to Microsoft Access 2016/19, which is a powerful database application software.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

DPA Communications Logo

img Duration

1 Day

Course Details

This course is for students who have never worked with an Access database before. The course introduces you to Microsoft Access 2016/19, which is a powerful database application software.

During this course, you will learn how to create simple tables, forms, queries, and reports. At the end of the course, you will be able to create your own simple database.

 

Design a Table

  • Design a table with various field types and properties to collect data.

 

Design a Form

  • Create a simple form based on a table to display the fields in a more user-friendly environment.

  • Use the formatting commands to design your form.

  • Use the property sheet or callouts located next to each section or control to design your form.

  • Create your own AutoFormats for future forms.

 

Create Queries

  • Create select queries using wildcards and operators to extract the information that you have collected on your table.

  • Create a calculated field in a query.

  • Run Delete and Update queries.

  • Create calculated fields in a query.

  • Create summary queries using SUM, AVERAGE, MAX, and MIN to summarize data.

 

Set up Relationships

  • Set up simple relationships between tables based on a key field.

  • Display related tables in a query.

 

Create a Report

  • Create a simple report based on tables or queries to display your data.

  • Place a calculated control on a report.

 

Validations and Restrictions

  • Add validations, restrictions, and input masks to fields to ensure the data is consistent.

 

Mail Merge

  • Create a query in Microsoft Access that is based on two tables, and then merge the query into a Word document.

 

Application Overview: Microsoft Access 2016/19

Microsoft Access is a relational database management system that combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container.

Get started quickly with prebuilt applications that you can modify or adapt to your needs. You can create and edit detailed reports that display sorted, filtered, and grouped information.

Using Microsoft Access, you can manage all your information from a single database file, run queries to find and retrieve just the data you want, and create forms to view, add, and update data in tables.

  • Toronto Branch

    PO Box 1363, Toronto

Check out more MS Access courses in Canada

Ultimate IT Courses Logo

Microsoft Office Training

Popular applications like Word, Excel, PowerPoint, and Outlook are among the productivity tools that make up the Microsoft Office apps suite

by Ultimate IT Courses [Claim Listing ]
Priority Management Logo

MS Excel (Level 1)

This workshop is intended to help all novice computer users get up to speed with Excel quickly. There are different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing.

by Priority Management [Claim Listing ]
  • Price
  • Start Date
  • Duration
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 ]
Broadview Academy Logo

Microsoft Excel 2013 / 2016 (Level 2)

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel®: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence.

by Broadview Academy [Claim Listing ]
HiTech Institute Logo

Microsoft Access 2010

This course describes the new and improved features in Microsoft Access 2010 that help you easily create and share databases.

by HiTech Institute [Claim Listing ]

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