Microsoft Access 2019 Basic & Intermediate

COURSE DESCRIPTION

The course empowers the trainee to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The course is divided in two sections; the first section introduces the skills required to design and plan a simple database using a standard database package; the second section introduces the skills required to retrieve information from an existing database by using the query, select and sort tools available in the data-base. The trainee shall also be able to create and modify reports.

COURSE OUTLINE

Module 1. Exploring Access 2019

• Working with Access
• Starting Access
• Using the Interface
• Opening an Existing Database
• Using Database Objects
• Using the Navigation Pane
• Opening a Database Object
• Using the Options Dialog Box
• Closing a Database
• Exiting Access
• Practice – Exploring Access

Module 2. Creating Tables

• Using Database Templates
• Creating a New Database
• Designing Tables
• Creating a Table in Datasheet View
• 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
• Practice – Creating Tables

Module 3. 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
• Practice – Field Properties

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

Inquire Now