We have now finished Databases. Here is what you should know.

From Scholar

• How to describe the structure of a database in terms of tables, records and fields.

• The advantages of using relational databases.

• The purpose of primary, surrogate, foreign and compound keys.

• The differences between one-to-one, one-to-many and many-to-many relationships.

• The purpose and uses of tables, forms and reports.

• What is meant by a relationship in a database.

• How to perform complex operations, such as performing a query, creating a form, creating a report.

• A calculated field is one which is created using a query which calculates a result from one or more existing fields.