Microsoft Access

Access is much more than a way to create desktop databases. It’s an easy-to-use tool for quickly creating customizable database applications.

Course Objectives

  • Examine database concepts and explore the Microsoft Office Access environment.
  •  Design a simple database.
  • Build a new database with related tables.
  •  Manage the data in a table.
  • Query a database using different methods.
  • Design a form.
  • Generate a report.
  • Import and export data.

Level-1. Understanding your Data

  •  What is a database?
  •  Why use a database?
  •  Access Basics

Level-2. Understanding your Data

  • Design a Database
  • Data modelling

Level-3. Overview of Access

  • Components
  • Creating a database
  • Work with Forms

Level-4.  Creating Tables

  • Attributes, Datatypes.
  • Adding/Editing Data, Manual editing
  • Importing data
  • Filtering/Exporting Tables
  • Filtering/sorting data
  •  Exporting data

Level-5. Table Relationships

  •  Types of relationship
  •  Referential Integrity

Level-6. SQL the Language

  • Types of queries
  • The SELECT statement

Level-7. Query Builder in Access

  • Building queries
  • Expressions

Level-8. Multipleā€table Queries  

  • The JOIN condition
  • Self joins

Level-9. Aggregate Queries

  • GROUP BY clause
  • Aggregate functions

Level 10. Advanced Topics

  • Database configuration
  • Advanced queries