Grade 5 ICT Quiz – Databases with MS Access

What is a database?

• A collection of unrelated information

• A type of software

• A collection of related information

• A hardware component

What does each card represent in a paper-based database?

• A field

• A record

• A table

• A query

Which of the following is a field in a student database?

• School

• Teacher

• Group

• Class

What is the purpose of sorting data in a database?

• To delete records

• To rearrange data

• To create new fields

• To add new records

In MS Access, what is a flat-file database?

• A database that cannot be edited

• A database that only stores images

• A database with a single table

• A database with multiple tables

What is the first step in creating a new database in MS Access?

• Define fields

• Create a new blank database

• Add a table

• Enter data

How can you filter students with a score greater than 80 in MS Access?

• By using Queries

• By sorting the data

• By entering new records

• By creating a new table

What does grouping data in a database help you find?

• The highest score only

• The oldest record

• The newest record

• Total counts within categories

Which tool in MS Access can be used to visualize results?

• Report Wizard

• Data Entry Form

• Table Design

• Query Wizard

What is a record in a database?

• A collection of fields

• A database table

• A single set of data entries

• A type of information