Visited
| Unit 9 - Course Notes and Resources | |
| Part 1 | Understand the structure and principles of databases |
| Database basics | example uses of databases; |
| advantages and disadvantages of computerised databases; | |
| database objects (tables, queries, reports, forms); | |
| data types; | |
| estimation of size of database | |
| Database structures: | tables; |
| fields; | |
| records; | |
| primary key | |
| Data integrity | data accuracy; |
| consistency of data; | |
| validation rules eg lookup lists, default values, upper or lower limits | |
| Part 2 | Be able to create a simple database to meet user needs |
| Creating tables: | selection of fields; |
| choice of data types eg text, numeric, date/time; | |
| field properties eg field length, format, default value, fieldname; | |
| validation; | |
| modifying field characteristics | |
| Improving efficiency: | shortcuts |
| Naming: | appropriate names for database objects |
| Data storage requirements: | estimation |
| Check: | data eg by use of spellcheck, sorting, comparison with source data; |
| layout and output of reports and screens | |
| Part 3 | Be able to create database queries, forms and reports |
| Queries: | create queries using multiple criteria, use of AND, OR in criteria; |
| selecting fields for display; | |
| sorting results eg date, numeric, alphabetical order | |
| Reports: | use of tables and queries as basis for reports; |
| automatic creation of reports eg wizards; | |
| selection of appropriate layouts; | |
| adding or editing appropriate labels and titles; | |
| special fields eg date/time; multiple criteria | |
| Forms: | automatic creation of forms eg wizards; |
| formatting forms eg titles, labels, arranging data entry order | |
| Part 4 | Be able to document a database |
| Technical documentation: | fieldnames; |
| field descriptions; | |
| field properties; | |
| primary keys, descriptions of forms, queries and reports; | |
| validation techniques used | |