INF1050 Database 1

1.1 create databases using a predefined template

1.2 define data needs and types by planning a database and identifying the key features needed for later entry; e.g., records, fields, layout

1.3 create a blank database

1.4 define and create a primary key

1.5 use help functions and references as appropriate

2.1 identify the key features of a database system needed to create a simple table

2.2 create and modify tables

2.3 create fields and modify field properties using different methods of editing; e.g., design view, datasheet view, wizards

2.4 create forms from the fields identified

2.5 modify the form layout

2.6 create reports to meet different audiences

2.7 modify the report layout and page setup for presentation and printing

3.1 enter, edit and delete records

3.2 navigate among records and fields

3.3 find and replace data

3.4 import data from other sources; e.g., spreadsheets

3.5 access data and define problems; e.g., manage information, make decisions

4.1 create and modify queries

4.2 sort data in a variety of elements; e.g., tables, forms, queries

4.3 filter data

4.4 export data

4.5 split databases

4.6 save database objects as other file types

4.7 print database objects, including reports and queries

4.8 back up a database

5.1 demonstrate good health and safety; e.g., posture, positioning of hardware and furniture

5.2 employ practices that provide security for hardware, software, supplies and personal work

6.1 demonstrate fundamental skills to:

6.2 demonstrate personal management skills to:

6.3 demonstrate teamwork skills to:

7.1 complete/update a personal inventory; e.g., interests, values, beliefs, resources, prior learning and experiences

7.2 create a connection between a personal inventory and occupational choices