ELEV-TG 004: Microsoft Office Specialist (MOS) – Access Essentials
Course Number: ELEV-TG 004
Duration: One day
Price: $499.00
Description:
Course Overview:
Microsoft Access is a powerful database application, and understanding its environment and fundamental principles is essential for effective data management. In our Access Essentials course, learners will gain a foundational understanding of this database application. They will learn how to correctly use key features, enabling them to create and maintain tables, establish relationships, design forms, generate reports, and execute queries. This course is suitable for individuals seeking a solid grasp of Access’s core functionalities and database management basics.
Course Modules:
Module One: Create and Manage a Database
- Create and modify databases
- Establish and manage relationships, keys, and referential integrity
- Efficiently navigate through a database
- Protect, maintain, and backup databases
- Print and export data in various formats
Module Two: Build Tables
- Create tables and import data
- Manage table structures, including hiding fields, adding descriptions, and renaming tables
- Control records within tables, such as updating, adding, deleting, and filtering records
- Create, modify, and configure fields, including adding validation rules, setting default values, and using input masks
Module Three: Create Queries
- Create various types of queries, including crosstab, parameter, action, and multi-table queries
- Modify queries, such as renaming, adding or removing fields, and sorting data
- Develop calculated fields and group data within queries
Module Four: Create Forms
- Create forms and configure form controls
- Format forms, including modifying tab order, configuring print settings, applying themes, and inserting backgrounds, headers, and footers
Module Five: Create Reports
- Create reports based on queries or tables
- Configure report controls, group and sort fields, and modify data sources
- Format reports, including adjusting columns, adding calculated fields, controlling positioning, changing orientation, and inserting header and footer information
By completing the Access Essentials course, learners will acquire the foundational skills needed to work confidently within the Microsoft Access environment. This knowledge empowers individuals to effectively manage and manipulate data, making them more efficient and productive in various roles requiring database management expertise.
Course Features
- Lectures 0
- Quizzes 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes