Understanding Databases

The Place For Free Online Training Courses

This quiz is designed to test your knowledge of the contents of the Understanding Databases Course, part of the Office Software Suite series. These quizzes are designed to improve your database skills.

There are twenty questions. The pass mark is 70 out of a potential 100 points, 5 for each question.

Once you are satisfied with your answers, complete your name and email address and select “Submit Quiz“ to have your answers marked.

You will shortly receive an email advising you of your score, whether you have passed the quiz, and how your answers have been scored. It will also include your Free Online Training course quiz completion Certificate for the appropriate quiz.

1. What is the purpose of a database report ?

It exports data from tables or queries to a text document

It allows you to view and save a snapshot of records at any given time

It lets you view specific records that are generated in a query

All of the above

2. The label field is…

An entry box in a form

An entry box in a report

A text box in a report

A heading in a table

3. What does a database administrator do?

Design and create databases

Enter data into a database

Provide access to specific records for users

All of the above

4. In a form, if you change the data it will automatically update the table without selecting save?

True

False

5. The unique identifying field that must be set in each database table is called the…

Unique ID

Special Key

Primary Key

Primary Field

6. After you have saved a table for the first time in Base, you can add fields in-between existing ones by right clicking and selecting 'insert'

True

False

7. What symbols do you use in a function or formula to represent 'not equal to'?

8. When filtering records, if you select <= 40 it will return values that are..

Less than 40

Between zero and 40

Slightly less than 40

Less than or equal to 40

9. To add records to an existing table you should…

Double click the table in the main window

Right Click and select "Edit"

Use a query

Go to File, Open, Table

10. When creating a relationship, when would you select 'update cascade'?

To update records in tables after running a query

To make all related fields the same

To create a relationship that can be changed easily

To ensure any changes in related fields are updated across tables

11. If you use criterion <5 AND >=25 in a query, which set of values for that field could possibly be returned from the following?

-9, 0, 4, 25, 160

5, 26, 29, 56, 100

1, 2, 13, 32, 50

-2, 3, 24, 60, 70

12. What word(s) could be returned from a query that used the criterion "LIKE No?" from the following?

North

Not

Nothing

All of the above

13. To change the orientation of a report or exported table or query, you should…

Click edit menu, then orientation

Click Format, then page

Right click the document or spreadsheet and select edit

Click properties

14. What is the keyboard shortcut to run a query?

F10

15. If you want to report the average amounts of a field you should…

Click on the average icon in the table design mode

In query design mode, right click the field and select average, then run a report

Create a query with average in the criterion for that field, then run a report

Make a query with a formula that adds up all the values, and divides by how many there are

16. To hide or unhide fields in a query you check or uncheck the 'Visible' box…

True

False

17. The keyboard shortcut to close a query that you have previously run is…

F11

18. To export data from a table or query you have to select records, copy, then paste into Calc or Writer..

True

False

19. Why would you want to use a grouped report?

To stop fields from being duplicated

To make sure that similar data is kept together

To prevent errors being created in the database

To allow tables and queries to be reported together

20. To generate whole numbers automatically in a table, what must you select from 'field type' and 'field properties'?

Integer / FillValue

Integer / AutoValue

Whole / AutoValue

Whole / AutoCount

Be sure to click Submit Quiz to see your results!

Name

Time is Up!

The Place For Free Online Training Courses

Improve Your Career Prospects

Understanding Databases

Comments

Understanding Databases — No Comments

Leave a Reply Cancel reply