- +63 917 714 4350 or DUO: (02) 7971 5203
-
Main: 11th Floor, SM Aura Office Tower, 26th Street, Mckinley Parkway, Fort Bonifacio, Taguig City, Metro Manila, Philippines
Satellite Office: 2nd Floor, Bonifacio Technology Center, 31st St. cor. 2nd Ave., Bonifacio Global City, Taguig City
- Courses
High Potential Leadership
Leadership, Professional and Personal Training
Customer Service
Sales
Business Etiquette
Business Communication
- Opportunities
Careers at Acumen
Trainer for Hire
Microsoft Access 2016 Basic & Intermediate
COURSE DESCRIPTION
This course provides the learners an understanding of the basic concepts of databases and demonstrates the ability to use a database on a personal computer. The module is divided in two sections; the first section tests the learners’ ability to design and plan a simple database using a standard database package; the second section requires the learners to demonstrate that he or she can retrieve information from an existing database by using the query, select and sort tools available in the data-base. The learners shall also be able to create and modify reports.
COURSE OUTLINE
Module 1. Exploring Access
- Working with Access
- Starting Access
- Opening an Existing Database
- Using the Ribbon
- Using the Contextual Tabs
- Using the Mini Toolbar
- Using the Navigation Pane
- Opening a Database Object
- Using Tabbed Documents
- Closing a Tabbed Document
- Closing All Tabbed Documents
- Using the Status Bar
- Using the Options Dialog Box
- Closing a Database
- Exiting Access
- Labs
Module 2. Creating Tables
- Using the Database Templates
- Creating a New Database
- Creating a Table in Design View
- Adding Field Names
- Assigning Data Types
- Saving a New Table
- Adding a Field Description
- Setting a Primary Key
- Using Multi-valued Fields
- Labs
Module 3. Setting Field Properties
- Using Field Properties
- Limiting Field Size
- Setting Number Formats
- Setting Date/Time Formats
- Setting Yes/No Formats
- Setting Default Values
- Setting Validation Rules
- Creating an Input Mask Wizard
- Creating an Input Mask Manually
- Creating a Custom Input Mask
- Typing a Lookup List
- Modifying Lookup Properties
- Labs