Microsoft Access Introduction
At the end of this course you will be able to identify the common objects of an Access database, design and build the structure of a database, input and maintain data, design user-friendly data entry forms, search the database using queries, and generate reports from your data.
Complete Course Syllabus
Database Concepts & Table Design
- The Access interface, relational database terminology, and core objects (Tables, Queries, Forms, Reports)
- Planning and designing tables, creating fields, and selecting appropriate data types
- Setting field properties (Field Size, Format, Input Mask, Validation Rules, Default Value)
- Entering, editing, sorting, filtering, and deleting table records
Table Relationships & Referential Integrity
- Defining Primary Keys and Foreign Keys
- Understanding One-to-Many and Many-to-Many table relationships
- Enforcing Referential Integrity and cascading updates/deletes
- Working with table subdatasheets
Designing Select Queries & Calculations
- Creating Select Queries using the Query Wizard and Query Design View
- Specifying single and multi-field query criteria, wildcards, and AND/OR logic
- Sorting query results, hiding fields, and adding calculated fields
Creating Data Entry Forms & Reports
- Creating user-friendly data entry forms and modifying form sections and controls
- Building main forms with embedded subforms
- Creating list reports, configuring grouping and sorting levels, and adding summary totals
More Access / It Courses
Microsoft Access Advanced
At the end of this course you will be able to use advanced features in the design of all major Access objects, apply simple automation to database objects using macros, use built-in database tools to manage a database, and work with external data to import, export and link data.
IT Beginners Course
This course will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows interface, managing files and folders, browsing the web, using OneDrive, and creating and managing emails in Outlook.
Microsoft Excel Introduction
Master workbook navigation, efficient data handling, and essential formulas. Create professional-looking spreadsheets, design clear charts, and produce polished print-ready reports.