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

Please contact us for the full course outline, schedules and for booking a private class.

Inquire Now