Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Career

/

etc. (Career)

Computer Proficiency Level 1 Practical - Database Practice (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 Practical - Database Practice (2021 Revised))

29 learners are taking this course

  • usefulit
Computer Specialist in Spreadsheet & Database
Access

What you will learn!

  • Access Basics

  • DB construction

  • Implementing input and edit functions

  • Implementing query and output functions

  • Implementing processing functions

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! 📖

Level 1 Computer Proficiency Practical Test - Database Practice 📐

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 📚

Access Basics, DB Construction

  • Data types, input masks, and format properties
  • Setting primary keys, validation rules, and data types
  • Create query properties, automatically enter today's date, and save the designated code.
  • Setting up table relationships
  • Import/Export External Data

Implement input, edit, query, and output functions

  • Component, Form Run/Properties, 'Default View' property and Record Source settings
  • Set up a calculation formula, create a label control, and create a control.
  • Set tab order, create command buttons, and add subforms
  • Configure reports, run property sheets, and report types
  • Sort ascending, write report/page footers, and event procedures
  • Change the data displayed on the form, click the form 'Find' button, close/open the form, and open the report based on conditions.

Implementing processing functions

  • Create a query on your branch, product sales status, and inventory
  • Writing crosstab queries/update queries, utilizing reserved word operators
  • Calculate averages, write parameter queries, and specify parameter values
  • Ascending order notation, duplicate data search, SQL commands
  • Dcomd, if, MsgBox

Database Practice Test

  • Features of subforms, creating subforms
  • Linking the main form and subform
  • Handling Controls
  • Control properties
  • Data tab of control properties
Implementing input and edit functionality - Label control
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

Need to know before starting?

  • Computer Proficiency Level 1 Written Exam - Introduction to Databases

Hello
This is

8,256,039

Learners

6,086

Reviews

4.6

Rating

261

Courses

유용한 IT 강의를 통해 여러분의 성장을 돕겠습니다.

Curriculum

All

20 lectures ∙ (6hr 48min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

$26.40

usefulit's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!