How to use a database application to quickly input, securely store and easily find information.
Create and modify a database structure with tables and appropriate field types.
Create forms for entering information, and for updating and removing records.
Sort and filter your data, and create queries to retrieve specific information.
Format the content and layout of reports from the information in your database.
Create and modify a database structure with tables and appropriate field types.
Create forms for entering information, and for updating and removing records.
Sort and filter your data, and create queries to retrieve specific information.
Format the content and layout of reports from the information in your database.
Gain the knowledge and skills to create and modify tables, queries, forms and reports. Learn how to relate tables, and how to retrieve and manipulate information from a database by using query and sort tools.
Understand what a database is and how it is organised and operated
Create a simple database and view the database content in various modes
Create a table, define and modify fields and their properties; enter and edit data in a table
Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database
Understand what a form is and create a form to enter, modify and delete records and data in records
Create routine reports and prepare outputs ready for distribution