Microsoft Access
(ไมโครซอฟต์ แอคเซส)
Definition
Microsoft Access (ไมโครซอฟต์ แอคเซส) Tool
Microsoft Access is a database management tool that allows users to create, manage, and manipulate relational databases through a graphical interface and built-in tools for queries, forms, and reports.
Expertise Level
Level 1
Basic
1. Can navigate the Access interface and basic database components.
2. Understands tables, records, and fields concepts.
3. Can create simple tables and input data manually.
Level 2
Intermediate
1. Can design and modify relationships between tables.
2. Creates and uses queries to filter and sort data.
3. Builds basic forms and reports for data entry and presentation.
Level 3
Advanced
1. Develops complex queries and macros to automate tasks.
2. Designs advanced forms with controls and navigation features.
3. Implements data validation, security settings, and optimizes database performance.
