정보처리기사 실기 (2020 개정) 제대로 배우기 Part.2
유용한IT학습
정보처리기사 실기 과목 자격증 대비 강의로, 정보시스템 등의 개발 요구사항을 이해하기 위한 기초 지식을 익힐 수 있습니다. (두 번째 파트)
초급
정보처리기사
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))
What you will learn!
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
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
Curriculum
All
21 lectures ∙ (8hr 42min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
1 reviews
$26.40
usefulit's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![빠르게 취득하는 [5일만에 합격하는 컴퓨터활용능력 2급 실기]강의 썸네일](https://cdn.inflearn.com/public/courses/330613/cover/820dc36f-c51d-4917-9eab-2fa9d5a291e5/330613-eng.png?f=avif&w=420)
