Microsoft Access Exam Questions: Test Your ICT Knowledge

This set of 20 multiple-choice questions is designed to assess and strengthen your understanding of Microsoft Access Database, focusing on key concepts such as database objects, data types, relationships, queries, and basic database management skills that every ICT student should master. 
 How to answer the questions 
  •  Select either A, B C or D 
  •  A 3 seconds countdown will begin 
  •  Next question will be revealed.
QUESTION 1 OF 20
What is Microsoft Access primarily used for?
Word processing
Database management
Graphic design
Video editing
A database is a collection of related ______.
Pictures
Tables
Slides
Emails
Which object in MS Access is used to store data?
Form
Query
Table
Report
Forms in MS Access are mainly used for:
Printing data
Data entry and viewing
Data calculation
Data deletion
Which object is used to retrieve specific data from a database?
Table
Report
Query
Macro
A primary key is used to:
Duplicate records
Identify each record uniquely
Delete records
Sort records
Which data type would you use to store long text in MS Access?
Number
Short Text
Long Text
Date/Time
The field that automatically increases its value is called:
Currency
AutoNumber
Hyperlink
Yes/No
A report in MS Access is used to:
Enter data
Modify tables
Display formatted output
Create relationships
Which view allows you to design the structure of a table?
Datasheet View
Layout View
Design View
Print Preview
A relationship between tables is created to:
Delete records
Link related data
Create forms
Format reports
The field name in a table must be:
A number only
Unique within the table
The same in all tables
Hidden always
Which of the following is NOT an Access object?
Table
Query
Slide
Form
Datasheet View is used to:
Design tables
View and edit records
Print reports
Create macros
Which operator is used in queries to find matching values?
=
+
/
%
A field in a database table represents:
A row
A record
A column
A database
A record in a database table represents:
A column
A single data entry
A table
A query
Which data type would you use to store a date?
Currency
Number
Date/Time
Short Text
Queries can be used to:
Only delete data
Only view data
Retrieve, update, and delete data
Only print data
Which feature ensures data accuracy by restricting input?
Validation Rule
AutoFormat
Sorting
Filtering

QUIZ DONE!

0%
0
0
Learning ICT is important because it equips students with essential digital skills needed in today’s technology-driven world. By answering questions in ICT, students develop a deeper understanding of how computers and information systems work, including databases, software, hardware, and data processing. These skills not only improve problem-solving and critical thinking abilities but also prepare students for future studies and careers in fields such as business, engineering, health, and information technology. Mastering ICT also helps students become confident and responsible users of technology in everyday life.



Previous Post Next Post

Advertisement

Advertisement