MS Access

Course Content MS Access Duration: 16 Hours



Module 1: Exploring the Microsoft Office Access Environment
  • Database Concepts
  • Explore the User Interface
  • Use an Existing Access Database
  • Customize the Access Environment
Module 2: Designing a Database
  • Tables
  • Records and Fields
  • Values
  • RDBMS concepts
  • Designate Primary and Foreign Keys
  • Determine Table Relationships
Module 3: Building a Table & Linking Tables
  • Explaining the Datasheet Tab
  • Entering Data in a New Table
  • Using a Table Template
  • Identifying the Entities
  • Working with Design View
  • Creating Data Types
  • Using Field Validation Rules
  • Defining Primary Keys
  • Working with Table Relationships
  • Creating Table Relationships
  • Defining Multi-Value Field Lookups
Module 4 : Managing Data in a Table
  • Modify Table Data
  • Sort/Filter /Advanced Filter Records
  • Work with Sub datasheets
Module 5 : Linking, Importing and exporting the data
  • Importing the data from excel to access
  • Importing the data from text files to access
  • Exporting the data from access to excel
Module 6: Designing Forms
  • Using Quick Create Commands
  • Exploring Form Types
  • Navigating within Forms
  • Using the Form Wizard
  • Creating a Form from Scratch
  • Working in Layout View
  • Working in Design View
  • Setting Form Properties
  • Using Form Controls
  • Using Control Layouts
  • Applying Auto Formats
  • Understanding Sub forms
Module 7: Generating Reports
  • Using the Report Command
  • Running the Report Wizard
  • Exploring Report Views
  • Creating a Report from Scratch
  • Using Conditional Formatting
  • Grouping & Sorting
  • Setting Report Properties
  • Detailing Your Report
  • Applying Auto Formats
  • Adding Sub reports
  • Alternating Record Colors
  • Filtering in Report View
  • Creating Labels
Module 8: Macros
  • An Overview
  • Creating Macros and Running Macros
  • Various Macro Actions
  • Conditional Macros
  • Msgbox
  • Set value
  • Using functions
  • Event Procedures
  • On open/close
  • On got/lost
  • Creating a Switchboard (User Interface)
  • Designing a switchboard