Use these tests to enhance your understanding of the course material.

Choose the correct answer(s) for each question.

 

Keep trying to answer each question until you get it right (if you do this your overall % score will be calculated at the end of the quiz).

 

Once you answer a question correctly, you can check the other answers for that question without affecting your overall score (this is useful if you want feedback on all of the possible answers).

 

These tests were generated using "Hot Potatoes" from Half Baked Software

 

On-line quizzes: Contents
Test Description
Terminology Covers the introductory section of the course and tests you understanding of the common terms used in database design.
Boolean Logic This test will take you through the basic notation of boolean algebra (the simple stuff) and will test your understanding of developing Queries with Microsoft Access.
Reports Reports are used to format output from a database for print. Take this test to verify your understanding of theuse of Reports within Microsoft Access.
Forms User friendly on-screen input and output forms are an itegral part of designing a database for non-IT experts. Forms can be read only or they can allow users to update data.
Macros (Optional section) Macros are used to provide more user functionality to a database. It is possible to tailor a database to provide a user friendly interface.
Relational Databases The model of a relational database was developed by E. Codd inthe 1970's. Since then RDBMS's have played a major part in data processing. This test covers the introductiory section to relational design.
Normalisation and Relational terminology Normalisation is a crucial process in designing relational databases. This test also refers to more specialist relational terminology (Relations, Joins, Attributes, Tuples etc.), you are encouraged to "read around" the subject in order to answer a small number of these questions.
Entity Relational Modelling The Entity Relational Model is a high level conceptual model that is more appropriate for end users to understand. This quiz is intended to test your understanding of the terminology and the general uses or ERM, you may find that you will need to cary out additional research in order to fully answer some of the questions.
Data Warehousing Relational Databases are not the last word in database technology. Much recent work has been undertakien on data warehousing. This is an important section to understand as it will help you to identify the circumstances in which a Relational model would be suitable and those in which a Relational model is not neccessarily the best one to use.
SQL A knowledge of SQL (Stuctured Query Language) is important if you intend to further your study of Database Design. This quiz tests your knowledge of the SELECT command.