Home/Computer/Computer Introduction to Microsoft Access Test Online

Computer Introduction to Microsoft Access Test Online

Mustansar KhanLast Updated: October 15, 2025

Important Introduction to Microsoft Access Question and Answer

Total Questions:	50
Time Allowed:	25 Minutes
Total Marks:	50
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	ECAT Entry Test Computer Online Test Interview Questions about Computer All Universities Entrance Test Recruitments Tests

Computer Introduction to Microsoft Access Practice Test Online With Explanation

Please wait...

Page 1 of 2

Uncategorized

1. Which object in Access is used to store raw data?

Query

Form

Report

Table

2. What is the default file extension for an Access 2016 database?

.xlsx

.docx

.mdb

.accdb

3. Which of these views allows you to design the structure of a table?

Report View

Print Preview

Design View

Datasheet View

4. Which of the following views allows users to enter or edit data directly?

Design View

Print Preview

Datasheet View

SQL View

5. Which of the following is used to import or export data?

Design View

Create Tab

Report Wizard

External Data Tab

6. What is the use of the Lookup Wizard?

To delete duplicates

To validate data

To search records

To create a list of values from another table or value set

7. Which property defines the number of characters that can be stored?

Required

Format

Field Size

Input Mask

8. Which of the following is not an object in MS Access?

Report

Worksheet

Query

Table

9. What is the purpose of the Input Mask property in a field?

To control how data is entered

To filter records

To sort values

To convert data types

10. Which option is used to define a relationship between tables?

Report Layout

Query Design

Table Wizard

Relationship Window

11. Which feature allows multiple users to access the database at the same time?

Backup Tool

Query Wizard

Form View

Record Locking

12. Which feature allows you to filter records quickly?

Module

Pivot Table

Form View

Filter by Selection

13. Which field type is used to store monetary values?

Currency

Short Text

AutoNumber

Number

14. Which of the following commands is used to sort records in a query?

GROUP BY

WHERE

ORDER BY

HAVING

15. Which key combination is used to switch between views in Access?

F11

Ctrl + W

Ctrl + P

16. Which of the following is used to automatically generate a unique value?

Text

AutoNumber

Hyperlink

Long Text

17. What is the primary function of a report in MS Access?

Query design

Data entry

Printing and presenting data

Form creation

18. Which of the following statements about relationships in Access is correct?

Only reports can define relationships

A table can only have one relationship

Access does not support relationships

Relationships help link data across tables

19. Which of the following is not a valid data type in Access?

Short Text

Number

Date/Time

Picture

20. Which of these can be used to copy only the structure of a table?

Make Table Query

Copy-Paste

Append Query

Export to Excel

21. Which Access object can be used to automate tasks?

Macro

Query

Form

Table

22. Which of the following is a database management system from Microsoft?

Word

Access

PowerPoint

Excel

23. Which query type is used to change data in a table?

Make Table query

Append query

Select query

Update query

24. Which of the following views is used to modify a form’s structure?

Form View

Layout View

Table View

Datasheet View

25. Which of the following field types can store large text in Access?

Hyperlink

Number

Long Text (Memo)

Short Text

Page 2 of 2

26. Which view allows you to see one record at a time?

Report View

Form View

Datasheet View

Layout View

27. Which field property in Access ensures a field must contain a value?

Field Size

Required

Input Mask

Format

28. Which of these is true about AutoNumber in Access?

It's a text-based field

Requires formatting

Automatically increments value

Must be entered manually

29. Which property controls how data is displayed but not stored?

Input Mask

Validation Rule

Field Size

Format

30. Which feature in Access is used to automatically calculate totals?

Table

AutoNumber

Totals row in Datasheet View

Report Wizard

31. Which of these allows searching across all fields in a table?

Navigation Pane

Search Box

Filter by Form

Design View

32. Which of the following is used to enter, view, and edit data in a user-friendly format?

Query

Form

Macro

Report

33. Which tab in Access is used to create tables, queries, forms, and reports?

External Data

Home

File

Create

34. Which query type is used to add records from one table to another?

CrossTab query

Append query

Delete query

Select query

35. Which object in MS Access is used to present data visually?

Table

Query

Report

Form

36. What is the maximum number of characters for a Short Text field in Access?

255

500

100

37. What is the Row Source property used for?

Formatting rows

Generating primary keys

Linking data to combo boxes or list boxes

Creating reports

38. In Access, what is a macro?

A set of actions to automate tasks

A stored procedure

A data entry field

A type of table

39. Which command is used to remove all records from a table?

Drop Table

Delete Query

Remove Form

Truncate Table

40. What is a parameter query?

A read-only query

A query with foreign key

A query that asks the user for input

A query used only in reports

41. In a report, which view is used to make changes to the structure?

Print Preview

Report View

Datasheet View

Layout View

42. What is the maximum number of characters allowed in a field name?

128

255

43. What does the Data Type property in Access define?

Input form layout

Column formatting

Table sorting order

Type of data stored in a field

44. Which of the following relationships ensures referential integrity?

Many-to-many

One-to-one

Self-join

One-to-many with foreign key

45. What is the primary key used for in an Access table?

Filtering

Formatting

Uniquely identifying each record

Sorting records

46. Which Access object is used to retrieve specific data based on criteria?

Query

Form

Report

Table

47. Which of the following allows grouping and summarizing data?

Select query

Crosstab query

Append query

Parameter query

48. Which of these allows data validation in MS Access?

Validation Rule property

Macros

Queries

Reports

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.

Introduction to Computers Online Test
Computer File Handling in “C” Test Online
Computer Functions in “C” Test Online
Computer Loop Constructs Test Online
Computer Decision Constructs Test Online
Computer Input Output Test Online
Computer Elements of “C” Test Online
Computer Getting Started with “C” Test Online
Computer Microsoft Access-Forms and Reports Test Online
Computer Table and Query Test Online

Mustansar KhanLast Updated: October 15, 2025

Computer Introduction to Microsoft Access Test Online

Important Introduction to Microsoft Access Question and Answer

Computer Introduction to Microsoft Access Practice Test Online With Explanation

Uncategorized

Related Posts

Mustansar Khan

Leave a Reply Cancel reply