Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Access Basics – Year 9 Quiz

Total questions: 91

Worksheet time: 46mins

Name
Class
Date
1.

What is a database?

a)

A drawing program

b)

A collection of organized information

c)

A computer game

d)

A web browser

2.

Which Microsoft Office program is used to create databases?

a)

Word

b)

Excel

c)

Access

d)

PowerPoint

3.

A database is most like:

a)

A random pile of papers

b)

A digital treasure chest with organized drawers

c)

A paint palette

d)

A calculator

4.

In a database table, data is stored in:

a)

Slides

b)

Tables

c)

Emails

d)

Games

5.

In a table, the vertical columns are called:

a)

Records

b)

Pages

c)

Fields

d)

Forms

6.

In a table, the horizontal rows are called:

a)

Records

b)

Fields

c)

Cells

d)

Pages

7.

What does a field hold?

a)

One type of information, like "Name"

b)

All data in the database

c)

Only pictures

d)

Only numbers

8.

What does a record hold?

a)

Information about one person or thing

b)

Only names

c)

Only dates

d)

Only prices

9.

In a "Students" table, which is a good field name?

a)

Thing

b)

X1

c)

StudentName

d)

Stuff

10.

In a "Books" table, which is an example of a record?

a)

"Title"

b)

"Author"

c)

All details about one book

d)

"Price"

11.

Which view in Access shows data like a grid with rows and columns?

a)

Slide view

b)

Design view

c)

Datasheet view

d)

Print view

12.

Which Access object is mainly used to store data?

a)

Form

b)

Table

c)

Report

d)

Macro

13.

Which Access object is used to make entering data easier, one record at a time?

a)

Table

b)

Form

c)

Query

d)

Report

14.

Which object is used to ask questions about data, like "show all Year 6 students"?

a)

Form

b)

Query

c)

Report

d)

Macro

15.

Which object is best for printing a nicely formatted list of data?

a)

Table

b)

Query

c)

Report

d)

Form

16.

A field that uniquely identifies each record is called a:

a)

Main field

b)

Primary key

c)

First field

d)

Master record

17.

What is true about a primary key?

a)

It can be the same for many records

b)

It must be empty

c)

It is unique for every record

d)

It must always be text

18.

In a "Students" table, which field is BEST as primary key?

a)

FirstName

b)

FavouriteColour

c)

StudentID

d)

ClassName

19.

In datasheet view, how can you add a new record?

a)

Type in the blank row at the bottom

b)

Press Delete

c)

Rename the table

d)

Close the database

20.

In a field called "DateOfBirth", which data type is best?

a)

Number

b)

Short Text

c)

Date/Time

d)

Yes/No

21.

In a field called "Age", which data type is best?

a)

Number

b)

Hyperlink

c)

Long Text

d)

Yes/No

22.

In a field called "EmailAddress", which data type is best?

a)

Number

b)

Currency

c)

Short Text

d)

Yes/No

23.

In a field called "IsBusUser", which data type is most suitable?

a)

Number

b)

Date/Time

c)

Yes/No

d)

Currency

24.

Which data type is best for a field that stores marks like 87, 64, 95?

a)

Short Text

b)

Number

c)

Yes/No

d)

Hyperlink

25.

You want to store fees like 150.50 or 200.00. Which data type is most suitable?

a)

Currency

b)

Short Text

c)

Yes/No

d)

Date/Time

26.

Which data type is best for a field called "Comments" where the teacher may type a long sentence?

a)

Short Text

b)

Long Text (Memo)

c)

Number

d)

Yes/No

27.

Which data type is best for storing a website link in a field called "SchoolWebsite"?

a)

Hyperlink

b)

Currency

c)

Yes/No

d)

Number

28.

A field called "StartTime" stores lesson times like 08:30. Which data type should be used?

a)

Short Text

b)

Date/Time

c)

Currency

d)

Yes/No

29.

A field called "HasPaidFees" should only show True or False. Which data type is correct?

a)

Number

b)

Yes/No

c)

Date/Time

d)

Short Text

30.

Which description of a database is MOST child-friendly and correct?

a)

A magic box that destroys data

b)

A digital treasure chest with organized drawers of information

c)

A type of virus

d)

A music playlist only

31.

Which object is BEST for quickly changing data in many records?

a)

Report

b)

Query

c)

Slide

d)

Picture

32.

Which object is BEST for letting a user click buttons and type into boxes to add data?

a)

Form

b)

Report

c)

Table only

d)

Macro

33.

Which object is mainly used for printing neat summaries of data?

a)

Form

b)

Report

c)

Query

d)

Macro

34.

In a school database, which table name is best?

a)

Stuff

b)

Things

c)

Students

d)

Data1

35.

Why is it important that data in a database is correct and tidy?

a)

So games run faster

b)

So searches and reports give accurate answers

c)

So the mouse does not break

d)

So the screen is brighter

36.

In a field "PhoneNumber", which type of data is usually used?

a)

Short Text

b)

Yes/No

c)

Date/Time

d)

Currency

37.

A primary key is like:

a)

A random number that might change

b)

A unique ID card for each record

c)

A picture in the table

d)

A password to open Access

38.

When you see a key icon next to a field name in table design view, it means:

a)

The field is locked from typing

b)

The field is the primary key

c)

The field is hidden

d)

The field is deleted

39.

Which is a good example of a Yes/No field name in a student table?

a)

FavouriteSubject

b)

PlaysInstrument

c)

Height

d)

DateOfBirth

40.

If you want to find all students in "Class 6A", which object do you create?

a)

Form

b)

Query with condition Class = "6A"

c)

Report without any filter

d)

New table

41.

What is the primary purpose of a database management system (DBMS)?

a)

To create graphics

b)

To send emails

c)

To manage and organize data

d)

To play games

42.

Which SQL command is used to retrieve data from a database?

a)

GET

b)

SELECT

c)

FETCH

d)

RETRIEVE

43.

In a relational database, what is a primary key?

a)

A unique identifier for a record

b)

A field that can be left empty

c)

A method of sorting data

d)

A type of data

44.

Which of the following is NOT a type of database?

a)

Relational

b)

Spreadsheet

c)

NoSQL

d)

Flat-file

45.

Which data type is most appropriate for a field named "EmailAddress"?

a)

Short Text

b)

Yes/No

c)

Long Text (Memo)

d)

Number

46.

For a field called "EnrollmentDate", which data type should be used?

a)

Date/Time

b)

Short Text

c)

Number

d)

Currency

47.

In a field named "IsActive", which data type is most suitable?

a)

Date/Time

b)

Short Text

c)

Yes/No

d)

Number

48.

What does a foreign key in a database signify?

a)

A field that stores images

b)

A unique identifier for a record

c)

A link to a primary key in another table

d)

A field that cannot be null

49.

What is the purpose of a query in Access?

a)

To create a new table

b)

To retrieve specific data from one or more tables

c)

To design a report layout

d)

To enter data into a form

50.

Which of the following is NOT a valid data type in Access?

a)

Text

b)

Currency

c)

Memo

d)

Image

51.

What does a report in Access primarily do?

a)

Runs calculations on data

b)

Displays data in a formatted manner

c)

Stores data

d)

Creates forms for data entry

52.

Which feature allows you to find specific records in a table?

a)

Filter

b)

Sort

c)

Group

d)

Join

53.

What is the primary purpose of a database?

a)

To create presentations

b)

To edit images

c)

To store and manage data

d)

To send emails

54.

Which of the following is NOT a type of database?

a)

Spreadsheet Database

b)

Relational Database

c)

Flat File Database

d)

NoSQL Database

55.

In Access, what is a form used for?

a)

To display data in a table format

b)

To create charts and graphs

c)

To run calculations

d)

To enter, modify, and view records

56.

What is the function of a primary key in a database?

a)

To uniquely identify each record

b)

To link tables together

c)

To store large amounts of data

d)

To format the data visually

57.

Which of the following is NOT a valid data type in a database?

a)

Text

b)

Boolean

c)

Number

d)

Image

58.

What is the purpose of a foreign key in a database?

a)

To enforce data integrity

b)

To link two tables together

c)

To uniquely identify a record

d)

To store large amounts of text

59.

Which SQL command is used to retrieve data from a database?

a)

DELETE

b)

UPDATE

c)

INSERT

d)

SELECT

60.

In a relational database, what does normalization help to achieve?

a)

Speed up data retrieval

b)

Increase data duplication

c)

Enhance data security

d)

Reduce data redundancy

61.

Which of the following is a characteristic of a database management system (DBMS)?

a)

It allows multiple users to access data simultaneously

b)

It does not support data backup

c)

It requires manual data entry only

d)

It is only used for small datasets

62.

What type of relationship does a primary key establish in a database?

a)

Many-to-many

b)

One-to-many

c)

None of the above

d)

One-to-one

63.

Which SQL command is used to retrieve data from a database?

a)

INSERT

b)

SELECT

c)

DELETE

d)

UPDATE

64.

What does the acronym SQL stand for?

a)

Structured Query Language

b)

Standard Query Language

c)

Simple Query Language

d)

Sequential Query Language

65.

In a relational database, what is a table?

a)

A graphical representation of data

b)

A method of data encryption

c)

A type of query

d)

A collection of related data entries

66.

Which of the following is NOT a type of database?

a)

Relational

b)

Hierarchical

c)

Sequential

d)

NoSQL

67.

What is the function of an index in a database?

a)

To enforce data types

b)

To speed up data retrieval

c)

To store large files

d)

To create backups

68.

What is the primary purpose of a database?

a)

To store data

b)

To display images

c)

To create websites

d)

To send emails

69.

Which SQL command is used to add new records to a database?

a)

DELETE

b)

INSERT

c)

SELECT

d)

UPDATE

70.

What type of relationship exists when one record in a table is related to many records in another table?

a)

One-to-One

b)

One-to-Many

c)

None

d)

Many-to-Many

71.

Which of the following is a common database management system?

a)

CSS

b)

MySQL

c)

HTML

d)

JavaScript

72.

What does the acronym 'CRUD' stand for in database management?

a)

Connect, Retrieve, Update, Delete

b)

Create, Retrieve, Upload, Download

c)

Copy, Read, Update, Delete

d)

Create, Read, Update, Delete

73.

Which of the following is a valid SQL statement to remove a table?

a)

DROP TABLE table_name;

b)

DELETE TABLE table_name;

c)

ERASE TABLE table_name;

d)

REMOVE TABLE table_name;

74.

What is the function of a primary key in a database?

a)

To sort data

b)

To create relationships

c)

To store images

d)

To uniquely identify a record

75.

Which SQL command is used to retrieve data from a database?

a)

DELETE

b)

UPDATE

c)

INSERT

d)

SELECT

76.

In a database, what does the term 'foreign key' refer to?

a)

A key that is not used

b)

A key that is used for sorting

c)

A key that links to another table

d)

A key that is always unique

77.

Which of the following is a type of database model?

a)

Hierarchical

b)

Linear

c)

Sequential

d)

Random

78.

What does SQL stand for?

a)

Structured Query Language

b)

Simple Query Language

c)

Sequential Query Language

d)

Standard Query Language

79.

Which of the following is NOT a type of database?

a)

Relational

b)

NoSQL

c)

Text-based

d)

Flat-file

80.

What is the primary purpose of a foreign key in a database?

a)

To store large text data

b)

To link two tables together

c)

To uniquely identify a record

d)

To enforce data integrity

81.

Which SQL statement is used to update existing records in a table?

a)

CHANGE

b)

UPDATE

c)

ALTER

d)

MODIFY

82.

In a database, what does the term "normalization" refer to?

a)

Improving data retrieval speed

b)

Enhancing data security

c)

Increasing data duplication

d)

Reducing data redundancy

83.

Which of the following is a common type of NoSQL database?

a)

Document Store

b)

Network Database

c)

Relational Database

d)

Hierarchical Database

84.

What does the acronym ACID stand for in database management?

a)

Access, Control, Integrity, Data

b)

Atomicity, Consistency, Isolation, Durability

c)

Analysis, Creation, Implementation, Deployment

d)

Application, Configuration, Interface, Design

85.

Which SQL command is used to delete a table from a database?

a)

ERASE TABLE

b)

REMOVE TABLE

c)

DELETE TABLE

d)

DROP TABLE

86.

What is the primary function of a form in Access?

a)

To display data in a report

b)

To enter and edit data

c)

To run queries

d)

To create a new database

87.

Which of the following is a valid data type for a phone number field?

a)

Number

b)

Short Text

c)

Date/Time

d)

Currency

88.

What does a primary key do in a database table?

a)

It formats the data for reports

b)

It links to other tables

c)

It uniquely identifies each record

d)

It stores large amounts of data

89.

Which of the following is NOT a benefit of using a database?

a)

Improved data organization

b)

Faster data retrieval

c)

Increased data redundancy

d)

Enhanced data security

90.

What is the purpose of a relationship in a database?

a)

To store images

b)

To create forms

c)

To connect different tables

d)

To generate reports

91.

Which of the following best describes a query in Access?

a)

A way to filter and retrieve specific data

b)

A feature for printing reports

c)

A method for organizing data

d)

A tool for designing forms

Similar Resources on Wayground

ruston_pennington_79402

86 questions

ruston_pennington_79402

quiz

Worksheet

•

9th - 12th Grade

Windows OS Certification Review

95 questions

Windows OS Certification Review

quiz

Worksheet

•

9th - 12th Grade

Java - Chapter 7 - 8

90 questions

Java - Chapter 7 - 8

quiz

Worksheet

•

9th - 12th Grade

Midterm Review

92 questions

Midterm Review

quiz

Worksheet

•

9th Grade

TIK KELAS 7

87 questions

TIK KELAS 7

quiz

Worksheet

•

1st - 10th Grade

Prueba inicial TIC 4ESO 23/24

96 questions

Prueba inicial TIC 4ESO 23/24

quiz

Worksheet

•

7th - 12th Grade

Code.org Final Vocabulary

90 questions

Code.org Final Vocabulary

quiz

Worksheet

•

9th - 12th Grade

N5 Computing SDD/DDD/CS

89 questions

N5 Computing SDD/DDD/CS

quiz

Worksheet

•

9th - 10th Grade