Microsoft Access is a DBMS (also known as Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It …
اطلاعات پایه
| نام رسمی |
وزارت تعاون، کار و رفاه اجتماعی |
| سازمان صادرکننده |
سازمان آموزش فنی و حرفه ای کشور |
| دپارتمان |
دفتر پژوهش، طرح و برنامه ریزی درسی |
| تاریخ تدوین |
2016/03/05 |
| کد ISCO |
|
| گروه شغلی |
اﻃﻼﻋﺎت ﻓﻨﺎوري |
| کد شناسایی صلاحیت ملی |
٩١٥٢-٣٥-٣٠١-١ |
کدهای آموزش شغلی ملی
| کد کامل |
2519-53-104-1 |
| شناسه صلاحیت |
1 |
| شناسه شغل |
104 |
| شناسه گروه |
53 |
| سطح مهارت |
1 |
تعاریف
Job standard:
The characteristics ' required competencies and abilities for Efficient Performance in work
environment is called "the Job standard", and sometimes “The Occupational standard”
Training standard:
The Training Map for achieving the Job’s subset Competencies.
Job title:
Is a set of Tasks and Abilities which is expected from an employed person in the defined level
Job description:
A statement covering the most important elements of a job, namely the position or title of the job, the
duties, job’s relation with other jobs in a occupational field, the responsibilities, workplace conditions
and required performance standards.
Course duration:
The minimum of time which is required to achieve the training objects.
Admission requirements:
The minimum of competencies and abilities which are obligatory for a potential admission.
Evaluation:
The process of collecting evidence and judgment about wetter a competency is achieved or not.
Include: written examination, practical examination
Required Qualifications for Trainers:
The minimum of Trainer’s technical and vocational abilities which the trainer is required to have.
Competency:
The ability of efficient performing a duty in a variety of workplaces conditions
Knowledge:
The minimum set of facts and mental capacities which is necessary for achieving a competency. This
can include science, (Mathematics, physics, chemistry or biology), technology or technical.
Skill:
The minimum coordination between mind and body for achieving an ability or competency. It
normally applied to practical skills.
Attitude:
A set of emotional behaviors required for achieving a competency and can have non-technical skills
and occupational ethics.
Safety:
The cases which doing or not doing something can cause harm or accident
Environmental Consideration:
A set of consideration about the act which should be done to minimize the environmental damage or
pollution.
خلاصه استاندارد صلاحیت
Microsoft Access 2016
Microsoft Access is a DBMS (also known as Database Management System) from Microsoft
that combines the relational Microsoft Jet Database Engine with a graphical user interface and
software-development tools. It is a member of the Microsoft Office suite of applications,
included in the Professional and higher editions or sold separately.
Microsoft Access stores data in its own format based on the Access Jet Database Engine. It
can also import or link directly to data stored in other applications and databases
| حداقل تحصیلات |
Post first year of high school |
| تواناییهای جسمی و ذهنی |
- |
| مهارتهای پیشنیاز |
|
| ساعات آموزش کل |
70 ساعت |
| ساعات نظری |
20 ساعت |
| ساعات عملی |
50 ساعت |
| درصد کتبی |
25% |
| درصد عملی |
65% |
| درصد اخلاق حرفهای |
10% |
صلاحیتهای مربی:
Computer engineer with 3 years experience
موقعیت شغلی و دشواری
| دستهبندی شغل |
|
| نیاز به استعلام وزارت |
خیر
|
اعضای کمیسیون
- - Ali Mosavi: Director Manager of Iran TVTO Curriculum Development Office
- - Cirrus Soltani nejad (Head of the General Department of Vocational Hormozgan)
- - Ramak Farahabad(Deputy for Planning and Training)
- - Golzar nazari gazic( Vice Minister of the General Administration of professional technical and
Hormozgan)
- - fatemeh taheri (Expert technical and vocational education, the Department of Hormozgan)
- - Asma Karimi: Director of Information Technology Training Center in Bandar Abbas
- - mohamamd reza kanjeh moradi: Director Manager of Iran TVTO Curriculum Development
Office
- -Shahram Shokofian: Manager of Iran TVTO IT Curriculum Development
سازمانهای همکار
- - Hormozgan Technical and Vocational Training Organization
- - IT Training Centre in Bandar Abbas
وظایف
1 - Quick Overview of the Access User Interface
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Access Ribbon
- FILE
- Save a Database as a Template
- HOME
- CREATE
- EXTERNAL DATA
- DATABASE TOOLS
- Contextual Tabs
- Quick Access Toolbar
- Object Navigation Pane
- Access Work Surface
- Access Options Dialog Box
- Object Overview
- Tables
- Queries
- Forms
- Reports
- Macros and Modules
- Process Overview
- Create a Database Using a Wizard
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
10 - Macros
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Macro Basics
- Open a Table, Form, and Report
- Run a Query
- Print a Report
- Running a Macro
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
11 - Completing the Desktop Application
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- The Navigation Form
- Running Macros from a Navigation Form
- Setting the Navigation Form as the Default
Form
- Splitting the Database
- Encrypt with a Password
- Distributing the Front-End Database
- Database Maintenance
- Compact and Repair
- Backup/Recover a Database
- Maintain Backward Compatibility
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
12 - Advanced Forms
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Design View
- Form Sections
- Adding a Header and Footer
- Adding a Logo to the Header
- Adding a Title to the Header
- Adding Fields to a Form
- Arranging Fields on a Form
- Spacing Objects on a Form
- Formatting
- Tab Order
- Setting Properties on a Form
- Controls
- Create Forms with Application Parts
- Creating a Subform
- Alter a Form
- Delete Forms
- Remove Form Controls
- Format a Form
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
2 - Approaches to Database Design
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Top-Down Database Design
- Bottom-Up Database
Design
- Reality
- Gather Information
- Data Mapping
- Sample Data Map
- Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
- Table Relationships
- Relationship Types
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
3 - Tables and Their Views
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Definition and Purpose
- Datasheet View
- Selection Tools
- Table Layout Tools
- Sorting and Filtering Tools
- Print Records
- Record Navigation
- Working in Datasheet View
- Design View
- Open a Table in Design
View
- Design View Layout
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
4 - Tables
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Creating an Access Database
- Data Types
- Create a Table in Design View
- Delete a Field
- Rename a Table
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
5 - Table Functions
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Importing Data
- Linking Tables from External Sources
- Import tables from other Databases
- Tables from Templates and Application
Parts
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
6 - Queries
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Queries
- Definition and Purpose
- Types
- Views
- Select Queries
- Select Queries with Criteria
- Logical Operators
- Group and Total with Queries
- Totals Row with Group By
- Query Design View
- Review of Select Queries
- Review of Select Queries with Criteria
- Logical Operators
- Parameter Queries
- Action Queries
- Make Table Queries
- Append Queries
- Update Queries
- Delete Queries
- Creating Crosstab Queries
- Delete a Query
- Rename a Query
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
7 - Forms
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Forms
- Definition and Purpose
- Views
- Alter a Form
- Form Record Navigation
- Layout View and Design View
- One-Click Forms
- Basic Data Entry Form
- Basic Multi-Record Form
- Datasheet Form
- Split Form
- Form Wizard
- Create a Form with the Form Wizard
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
8 - Advanced Forms
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Design View
- Form Sections
- Adding a Header and Footer
- Adding a Logo to the Header
- Adding a Title to the Header
- Adding Fields to a Form
- Arranging Fields on a Form
- Spacing Objects on a Form
- Formatting
- Tab Order
- Setting Properties on a Form
- Controls
- Create Forms with Application Parts
- Creating a Subform
- Alter a Form
- Delete Forms
- Remove Form Controls
- Format a Form
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
9 - Relationships
| ساعات کل |
0 ساعت |
| ساعات نظری |
0 ساعت |
| ساعات عملی |
0 ساعت |
دانش:
- Review
- Referential Integrity
- Relationships
- Data Types and Relationships
- Formalize the Relationship
between Tables
- A Few Words about Naming Conventions
نگرش:
- Speed and accuracy in doing the right thing
ایمنی و بهداشت:
- Compliance with safety protection in the workplace
ملاحظات زیستمحیطی:
- Compliance with environmental protection
استاندارد تجهیزات
نکته: تجهیزات و ابزارهای مورد نیاز برای انجام این استاندارد شغلی در جدول زیر ارائه شده است.
هیچ تجهیزاتی تعریف نشده است.
استاندارد ابزار
نکته: ابزارهای مورد نیاز برای انجام این استاندارد شغلی در جدول زیر ارائه شده است.
هیچ ابزاری تعریف نشده است.
دورههای مرتبط
گالری
تصویری برای گالری ثبت نشده است.