Microsoft Access 2019 Basic & Intermediate

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