Computer Proficiency Level 1 Written Test - Database General (2021 Revised)
Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1 Written - Database General (2021 Revised))
This course is prepared for Beginners.
What you will learn!
Create a database table
Database Overview
Queries, Forms, Controls
Reports, Macros, Events
Attention job seekers!
Get your computer skills and challenge yourself to get a job 👨💻
📢 Please check before taking the class!
- This course does not provide Q&A with the knowledge sharer regarding the lecture content. Please take note of this when registering for the course.
To acquire computer skills
If you want to challenge! 📖
Computer Proficiency Level 1 Written Test - Database General 📐
This course is designed to help you obtain a computer proficiency certificate, and is structured to match the actual exam criteria. Try to obtain the certificate by learning and utilizing basic knowledge for each subject of the computer proficiency exam!
Computer Proficiency Test Information 💻
Admission criteria
- Written: Each subject must have at least 40 points out of 100 and an average of at least 60 points
- Practical: 70 points or more out of 100 (Level 1: 70 points or more in both subjects)
Practical Program
- MS Office 2016
Test Registration & More Information
- Korea Chamber of Commerce and Industry Qualification Evaluation Division Homepage 👉 Go to
What you'll learn 📚
Database Overview
- Database definition, features, pros and cons
- Schema, DBMS, Database Language
- Relational database, characteristics of relations, types of keys/constraints
- Normalization, entity relationship diagram, ER diagram
Create a table
- Access Objects, Create Tables, Data Types
- Field properties: format, input mask, validation
- Primary keys and indexes, field properties (lookups), table properties
- Establish relationships, enter and modify data, import/connect external data
Queries, Forms, Controls, Reports, Macros, Events
- Queries: simple query queries, queries using expressions, and execution queries.
- Forms: Creating forms, properties of forms
- Using Controls, Creating Controls/Creating Control Subforms
- Handling Controls, Key Properties of Controls
- Create, print, sort and group reports
- Writing and running macros, macro functions
- Writing event procedures, access objects, data access objects
Database General Mock Test
- Primary key of the table
- Find and replace data
- connection table
- HAVING clause/WHERE clause
- Multi-table query, execution query
- Properties of forms, sections of reports
- Report writing and more
Computer skills that are easy, light, and informative to prepare for!
- ✅ It covers everything from theory to problem solving all at once.
- ✅ Review your theoretical learning by solving practice problems for each section.
- ✅ We provide mock exams consisting of past exam questions. Do a final check before the exam with mock exams!
Recommended for
these people!
Who is this course right for?
Anyone who wants to obtain a computer skills certificate
Anyone who wants to learn how to use computers for work
Curriculum
All
21 lectures ∙ (8hr 42min)
are provided.