European Computer Driving Licence

 

Back

  Module 5 Databases and Filing Systems

Syllabus Version 4

This module requires an understanding of the basic concepts of databases. It tests your ability to build a small database using a standard database package and create simple queries and reports from an existing database.

Click here to go to the practice tests (on the BCS website)
1  Using the Application
  • Understand database terminology and concepts
  • Open an existing database 
  • Save and close a database 
  • Close the database 
  • Use Help functions
  • Change display modes
  • Modify toolbar display 
2  Tables 
  • Create a table with fields and attributes.
  • Enter, modify and delete data in a table.
  • Add and delete records in the database.
  • Navigate throughout a table.
  • Define a primary key
  • Set up an index.
  • Modify table layout attributes.
  • Modify field attributes.
  • Create, modify and delete relationships between tables. 
  • Apply referential integrity.
3  Forms
  • Create a simple form.
  • Enter data into the database using simple forms.
  • Format text.
  • Modify form layout.
  • Change background colours in form layout.
4  Retrieving Information
  • Find a record based on given criteria.
  • Create and remove filters.
  • Create queries based on single or multiple criteria and on one or more than one table.
  • Add and remove fields from a query
  • Delete queries 
  • Select and sort data 
5  Reports
  • Create and save report based on table or query. 
  • Modify a report.
  • Create and customise Headers and Footers.
  • Group data in a report-totals, sub-totals etc.
  • Delete a report. 
6 Prepare outputs 
  • Preview table, form and report.
  • Modify Page Set up options.
  • Set print options. 
  • Print selected outputs from table, query or report.

Back