Once you have worked through this manual you should be able to:
- Understand what a database is and how it is organised.
- Create a simple database and view the database content in various modes.
- Create a table, define and modify fields, and create relationships between tables. Enter and edit data in a table.
- Use filters and queries to retrieve specific information from a database.
- Create a form to enter, modify, and delete records and data in records.
- Create routine reports and prepare outputs ready for print or electronic distribution.
This manual is based on ECDL Using Databases Syllabus 6
Understand what a database is.
Understand that information is the processed output of data.
Understand how a database is organised in terms of tables, records and fields.
Understand that all database data is stored in tables. Understand that changes are automatically saved.
Know some of the common uses of databases.
Understand that each table in a database should contain data related to a single subject type.
Understand that each record in a database should contain data related to a single subject.
Understand that each field in a table should contain only one element of data.
Understand that field content is associated with an appropriate data type.
Understand that fields have associated field properties.
Understand what a primary key is.
Understand that the main purpose of an index is to speed up search queries.
Understand that the main purpose of relating tables in a database is to minimize duplication of data.
Understand that a relationship is built by matching a unique field in one table with a field in another table.
Understand the importance of maintaining the integrity of relationships between tables.
Open, close a database application.
Open, close a database.
Create a new database and save to a location on a drive.
Display, hide built-in toolbars. Restore, minimize the ribbon.
Use available Help resources.
Open, save and close a table, form, query, report.
Switch between view modes in a table, form, query, report.
Delete a table, form, query, report.
Navigate between records in a table, query, form. Navigate between pages in a report.
Sort records in a table, form, query output in ascending, descending numeric, alphabetic order.
Add, delete records in a table.
Add, modify, delete data in a record.
Create and name a table and specify fields with their data types.
Apply field property settings.
Understand consequences of changing data types, field properties in a table.
Create a simple validation rule for number, date/time, currency.
Set a field as a primary key.
Index a field.
Add a field to an existing table.
Adjust the width of column(s) in a table.
Create a one-to-many relationship between tables.
Delete a one-to-many relationship between tables.
Apply referential integrity between tables.
Understand that a form is used to display, add and edit records.
Create and name a simple form.
Use a form to insert new records.
Use a form to delete records.
Use a form to add, modify, delete data in a record.
Add, modify text in headers, footers in a form.
Use the search command for a specific word, number, date in a field.
Apply a filter to a table, form.
Remove a filter from a table, form.
Understand that a query is used to extract and analyse data.
Create a named single-table query using specific search criteria.
Run a query.
Create a named two-table query using specific search criteria.
Edit a query: add, remove, move, hide, unhide fields.
Add criteria to a query using one or more operators.
Add criteria to a query to sort records in ascending, descending numeric, alphabetic order.
Edit a query: modify, remove criteria.
Add criteria to a query using one or more of the following logical operators.
Use a wildcard in a query.
Understand that a report is used to present selected information from a table, query.
Create and name a simple report based on a table, query.
Create and name a grouped report. Sort records and calculate summary information.
Edit a report: change arrangement of data field headings.
Edit a report: add, modify text in headers, footers.
Export a table, query, output in spreadsheet, text file, csv, XML format to a location on a drive.
Export a report output in pdf format to a location on a drive.
Change table, form, query output, report orientation: portrait, landscape. Change paper size.
Print a page, selected records(s), complete table.
Print all records, specific page(s) using form layout.
Print the result of a query.
Print specific page(s) in a report, print complete report.