USE A GUI BASED DATABASE APPLICATION TO WORK WITH SIMPLE DATABASES
UNIT STANDARD ID: 116936
NQF LEVEL: 3
CREDITS: 3
NOTIONAL HOURS: 30
SAQA UNIT STANDARD ALIGNMENT
SPECIFIC OUTCOMES (SO)
Level 3 | Credit 3
UNIT STANDARD 116936 :
Use a Graphical User Interface (GUI)-based database application to work with simple databases.
SPECIFIC OUTCOME 1
Understand the principles of databases.
ASSESSMENT CRITERION 1
A database management system is defined in terms of its purpose and use.
ASSESSMENT CRITERION 2
Examples of uses of databases are provided.
ASSESSMENT CRITERION RANGE
At least three examples.
ASSESSMENT CRITERION 3
Properties of databases are described in terms of their purpose and relation to the database as a whole.
ASSESSMENT CRITERION RANGE
Field, Record, Table, Index, Field Property, Data type.
SPECIFIC OUTCOME 2
Open and save a simple existing databases.
ASSESSMENT CRITERION 1
The database application is opened or started.
ASSESSMENT CRITERION 2
The parts of the database application window are described in terms of their features and use.
ASSESSMENT CRITERION RANGE
All of: Menu Bar, Toolbar, Status Bar, scroll bar, Object Bar.
ASSESSMENT CRITERION 3
An existing database is opened.
ASSESSMENT CRITERION 4
Data is entered into an existing database table.
ASSESSMENT CRITERION RANGE
At least 5 records are entered.
ASSESSMENT CRITERION 5
Saving a database giving it a descriptive name related to its purpose and use.
ASSESSMENT CRITERION 6
The database is closed.
ASSESSMENT CRITERION 7
The database application program is closed.
SPECIFIC OUTCOME 3
Produce and edit a simple database table from given specifications.
OUTCOME RANGE
At least 5 fields.
ASSESSMENT CRITERION 1
A database table is created with the required format bases on a given specification.
ASSESSMENT CRITERION RANGE
Data types to include at least: text, numeric, date, currency.
ASSESSMENT CRITERION 2
The database table is saved with a descriptive name, as per the given specification.
ASSESSMENT CRITERION RANGE
The name of the new database table and database must allow the database table and database to be easily identified in terms of its purpose and content.
ASSESSMENT CRITERION 3
A column is moved within the database table.
ASSESSMENT CRITERION 4
Column widths of columns in the database table are changed.
ASSESSMENT CRITERION RANGE
At least 2 columns.
ASSESSMENT CRITERION 5
A database table is deleted.
ASSESSMENT CRITERION 6
The database table is saved and closed.
SPECIFIC OUTCOME 4
Data is entered into a simple database table from given specifications.
OUTCOME RANGE
At least 5 fields.
ASSESSMENT CRITERION 1
A new record is added to the database table.
ASSESSMENT CRITERION RANGE
At least 2 records are added.
ASSESSMENT CRITERION 2
Data in the database table is modified.
ASSESSMENT CRITERION RANGE
At least 3 records are modified.
ASSESSMENT CRITERION 3
Data in the database table is deleted.
ASSESSMENT CRITERION 4
A record is deleted from the database table.
SPECIFIC OUTCOME 5
Modify the design of a database table.
ASSESSMENT CRITERION 1
An existing database table is opened in design view.
ASSESSMENT CRITERION 2
The consequences of changing a field size are discussed.
ASSESSMENT CRITERION 3
Field formats are modified.
ASSESSMENT CRITERION RANGE
Field size, Number field, Date field.
ASSESSMENT CRITERION 4
A field is moved in the database table.
ASSESSMENT CRITERION 5
A new field is added to the database table.
ASSESSMENT CRITERION 6
A field is deleted from the database table.
ASSESSMENT CRITERION 7
The consequences of the changes made are explained and corrected if necessary.
ASSESSMENT CRITERION RANGE
Type conversions.
SPECIFIC OUTCOME 6
Sort and search for records in a database table.
ASSESSMENT CRITERION 1
A record in a database table is sorted according to one field.
ASSESSMENT CRITERION RANGE
Ascending, descending.
ASSESSMENT CRITERION 2
A record is located in a database table, by searching for specific data within the table.
Table of Contents
Introduction to Access 2010
Lesson 1 – Why Do I Need a Database?
What is a Database?
Why Use a Database?
Properties of a database
Forms, Queries, and Reports
Activity 1
Lesson 2-Opening and saving a database
Opening a Database
Working with Your Access Environment
Creating a database
Adding Records and Entering Data to an existing table
Closing database
Activity 2
Lesson 3 – Producing and editing database table
Creating database tables
Saving a table
Changing the Width of a Column
Moving a Column
Deleting a table
Saving and closing the table
Activity 3
Lesson 4 – Entering data in a table
Adding Records and Entering Data
Editing Records
Deleting data from a table
To Delete a Record
Activity 4
Lesson 5 – Modifying tables
To Open an Existing Table
Adding and Rearranging Fields
To Change the Data Type for Existing Fields:
Field Character Limits
Deleting a fields
Activity 5
Lesson 6 – Sorting and searching for records in a table
Sorting Records
Filtering Records
Creating a Filter from a Search Term
Activity 6
Introduction to Access 2010
Access 2010 is the database software in the Microsoft 2010 Office Suite. It allows you to order, manage, search, and report large amounts of information.
This tutorial will show you how to build a database from scratch, including how to plan and set up tables and fields, create and use forms to enhance data integrity, design and run meaningful queries, and create useful and attractive reports.
