Microsoft Access 2019 (Basic to Intermediate)

by Oaks Training Claim Listing

In this 2-days hand-on course, you will learn how to migrate your existing data and manage them in Microsoft Access 2019. This course is also designed for new and inexperienced users to appreciate the concept of database design through the process of normalization.

S$406.6

Contact the Institutes

Fill this form

Advertisement

Oaks Training Logo

img Duration

2 Days

Course Details

In this 2-days hand-on course, you will learn how to migrate your existing data and manage them in Microsoft Access 2019. This course is also designed for new and inexperienced users to appreciate the concept of database design through the process of normalization.

An essential approach which is a step that is often not taught to help you to build an effective and suitable database.

 

Some Key Pointers to Consider:

  • How to determine what fields are needed for the database/system?
  • How to determine how many tables are need?
  • How to determine which field goes into which table?

Failing to consider all these, your database would be inefficient and may not work properly. It would greatly hinder future enhancements to your database or even make it impossible for enhancements.

This course is designed with a workshop and many hands-on exercises to allow you to practice key lessons taught to help you create a proper working database.

 

Course Outline:

  • Introduction to Database
  • Working Through Normalisation Concept
  • Working Through Table Design
  • Understanding Field Properties
  • Understanding Relationships
  • Working with Datasheet View
  • Importing/Exporting Data
  • Working with Prefix
  • Form Wizard
  • Report Wizard
  • Central Branch

    1 Coleman Street #07-11, The Adelphi, Central

Check out more MS Access courses in Singapore

St.Hua Private School Logo

Microsoft Excel Essentials

Microsoft Excel is a powerful yet user-friendly spreadsheet software. In this course, you will learn how to input and organize data, use functions to perform calculations, format the appearance of your data and cells, and build stunning charts and PivotTables.

by St.Hua Private School [Claim Listing ]
SIM Singapore Institute Of Management Logo

Pivot Table Techniques In Microsoft Excel (Advance)

Attend our 1-day course on “Advanced Pivot Table Techniques in Microsoft Excel” to use Advanced techniques to summarize and analyze your Excel data effectively.

by SIM Singapore Institute Of Management [Claim Listing ]
IMA Logo

Basic Excel Skills For The Management Accountant

This course will help you develop the basic Excel skills required of most management accountants. Using financial statements and ratio analysis as examples of Excel usage, this training is customized for accounting and finance professionals.

by IMA [Claim Listing ]
Oaks Training Logo

Microsoft Excel 2019 (Basic To Intermediate)

This 2-days hands-on course covers all the essential basics you will need to enter data and build organized spreadsheets. It also provides guidance on how to create a proper database, organizing your data such that it can be used to work with multiple worksheets.

by Oaks Training [Claim Listing ]
Oaks Training Logo

Microsoft Office 365 PowerPoint

Microsoft Office 365 PowerPoint is the tool you need. PowerPoint is easy to use and equipped with many friendly ready to use features to make you presentation faster and easier, enabling you to be more productive and effective in meetings.

by Oaks Training [Claim Listing ]

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