강의

멘토링

커뮤니티

Career

/

etc. (Career)

Computer Application Skills Level 1 Written Exam - Database Fundamentals

Through this course, learners will be able to acquire the skills necessary to obtain a Computer Utilization Proficiency certification. This course is structured according to the examination standards for obtaining the Computer Utilization Proficiency certification. You can learn and apply fundamental knowledge of Computer Utilization Proficiency subjects to prepare for certification acquisition.

(5.0) 1 reviews

30 learners

Level Beginner

Course period 12 months

  • usefulit
Access
Access
Computer Specialist in Spreadsheet & Database
Computer Specialist in Spreadsheet & Database
Access
Access
Computer Specialist in Spreadsheet & Database
Computer Specialist in Spreadsheet & Database

What you will gain after the course

  • Create a database table

  • Database Overview

  • Queries, Forms, Controls

  • Reports, Macros, Events

Attention job seekers!
Develop your computer skills and apply for a job 👨‍💻

📢 Please check before taking the class!

  • This course does not offer Q&A sessions with knowledge sharing experts regarding the course content. Please keep this in mind when registering for the course.

To acquire computer skills
If you want to challenge yourself! 📖

Computer Proficiency Level 1 Written Exam - General Database 📐

This course is designed to help you obtain a computer proficiency certification, and is structured to reflect actual exam criteria. Learn and apply the basic knowledge for each computer proficiency subject to achieve certification!

Computer Proficiency Test Information 💻

Acceptance criteria

  • Written Exam: 40 points or more per subject out of 100 and an average of 60 points or more
  • Practical: 70 points or higher out of 100 (Level 1 requires 70 points or higher in both subjects)

Practical program

  • MS Office 2016

Test Registration & Other Details

  • Korea Chamber of Commerce and Industry Qualification Evaluation Division website 👉 Go to

What you'll learn 📚

Database Overview

  • Database definition, features, pros and cons
  • Schema, DBMS, Database Language
  • Relational databases, characteristics of relations, types of keys/constraints
  • Normalization, entity-relationship diagram, ER diagram

Create a table

  • Access objects, creating tables, data types
  • Field properties: format, input mask, validation
  • Primary keys and indexes, field properties (lookups), table properties
  • Establish relationships, enter and modify data, and import/connect external data.

Queries, forms, controls, reports, macros, events

  • Queries: simple query queries, queries using expressions, and execution queries.
  • Forms: Creating forms, form properties
  • Using Controls, Creating Controls/Creating Control Subforms
  • Handling Controls, Key Control Properties
  • Create, print, sort, and group reports
  • Creating and running macros, macro functions
  • Writing event procedures, access objects, and data access objects

Database General Mock Exam

  • Primary key of the table
  • Find and Replace Data
  • Linked Table
  • HAVING clause/WHERE clause
  • Multi-table queries, execution queries
  • Form properties, report sections
  • Report writing and other
Create Table - Primary Key
mock exam

Computer skills that are easy, light, and informative!

  • ✅ Everything from theory to problem solving is included in one place.
  • ✅ Review your theoretical knowledge by solving practice problems for each section.
  • ✅ We offer mock exams filled with past exam questions. Use them for a final check before your actual exam!

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

Hello
This is

8,278,678

Learners

6,372

Reviews

4.6

Rating

309

Courses

I will help you grow through useful IT lectures.

Curriculum

All

21 lectures ∙ (8hr 42min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • freeweer4498님의 프로필 이미지
    freeweer4498

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    Thanks to this, I think I'll be able to use the computer at work more easily.

    $26.40

    usefulit's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!