Learn how to build databases to store and retrieve your data more efficiently with Access 2016. The trainer will show you how to use the powerful program to wrangle your data and create your first table, and highlights smart strategies to edit and modify fields and records.
Learn how to build databases to store and retrieve your data more efficiently with Access 2016. The trainer will show you how to use the powerful program to wrangle your data and create your first table, and highlights smart strategies to edit and modify fields and records.
The course also shows you how to build queries and action queries, create and design forms, use macros, integrate Access with the rest of the Office 2016 suite, and maintain your databases over time.
Course Highlights
Creating a new database
Creating tables and new data types
Importing and entering data
Setting up relationships and primary keys
Adding validation rules
Sorting and filtering table data
Building queries
Designing forms
Creating reports
Attaching macros to buttons and tables
Working with Excel and Outlook data
Maintaining an Access database
Certificate
All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.
Tertiary Courses Malaysia, a subsidiary of Tertiary Infotech Sdn. Bhd. (Company Reg #: 1187680-U) was founded in Jun 2016. We are a HRD Corp approved training provider in Malaysia.
We provide high quality classroom instructor-led adult learning trainings to professionals, executives, students in Malaysia. We provide professional adult trainings in various industries such as Infocomm, Digital Media, Robotics,Telecommunication, Life Science, Semiconductor, Horticulture and Business Administration.
The standard of trainings depends on the quality of trainers. Therefore, we strive to ensure high training standard through sourcing for qualified and experienced trainers.
This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel.
Microsoft Access is a software for creating and managing databases, developed by Microsoft Corporation. Microsoft Access is equipped with Forms, Query and Relationship functionality.
If you’ve ever worked with Excel, you’ve probably felt the misery of selecting the wrong formula to analyse a data set. Perhaps you worked on it for hours before giving up because the data output was incorrect or the function was too sophisticated.
Microsoft PowerPoint training is offered by Gem Consultancy. We emphasise on practical training through setting conditions for how learner can practice what they have learned and performance be evaluated.
This course mainly focuses on people who don't have any knowledge of computers. The basics of computers and MS Office are covered in this course. Also making the students familiar with Internet and emailing.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy