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