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 view allows you to see one record at a time?

Form View

Report View

Layout View

Datasheet View

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

Number

Short Text

Long Text (Memo)

Hyperlink

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

Validation Rule property

Queries

Macros

Reports

4. In Access, what is a macro?

A type of table

A data entry field

A set of actions to automate tasks

A stored procedure

5. 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

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

Drop Table

Remove Form

Delete Query

Truncate Table

7. What is the Row Source property used for?

Generating primary keys

Linking data to combo boxes or list boxes

Creating reports

Formatting rows

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

Design View

SQL View

Print Preview

Datasheet View

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

Field Size

Format

Input Mask

Required

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

Table sorting order

Column formatting

Type of data stored in a field

Input form layout

11. Which of the following relationships ensures referential integrity?

Many-to-many

One-to-many with foreign key

One-to-one

Self-join

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

Print Preview

Report View

Datasheet View

Layout View

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

Append query

Delete query

CrossTab query

Select query

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

255

128

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

Report

Query

Macro

Form

16. What is a parameter query?

A query that asks the user for input

A query used only in reports

A read-only query

A query with foreign key

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

Report View

Datasheet View

Print Preview

Design View

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

To control how data is entered

To convert data types

To sort values

To filter records

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

255

500

100

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

Format

Field Size

Input Mask

Required

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

Printing and presenting data

Query design

Form creation

Data entry

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

Crosstab query

Parameter query

Append query

Select query

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

Form

Report

Table

Query

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

Create Tab

External Data Tab

Report Wizard

Design View

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

.accdb

.mdb

.xlsx

.docx

Page 2 of 2

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

Query

Table

Form

Report

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

Table Wizard

Relationship Window

Query Design

Report Layout

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

Make Table query

Select query

Append query

Update query

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

Form

Macro

Query

Table

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

Sorting records

Uniquely identifying each record

Formatting

Filtering

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

Form View

Query Wizard

Backup Tool

Record Locking

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

External Data

File

Create

Home

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

Query

Form

Report

Table

34. Which feature allows you to filter records quickly?

Form View

Pivot Table

Module

Filter by Selection

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

It's a text-based field

Automatically increments value

Requires formatting

Must be entered manually

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

Append Query

Make Table Query

Copy-Paste

Export to Excel

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

Short Text

AutoNumber

Currency

Number

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

Ctrl + W

Ctrl + P

F11

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

AutoNumber

Report Wizard

Table

Totals row in Datasheet View

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

Number

Date/Time

Picture

Short Text

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

Filter by Form

Design View

Search Box

Navigation Pane

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

Layout View

Form View

Datasheet View

Table View

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

WHERE

GROUP BY

ORDER BY

HAVING

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

PowerPoint

Word

Excel

Access

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

Text

Hyperlink

Long Text

AutoNumber

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

Report

Table

Worksheet

Query

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

Validation Rule

Field Size

Input Mask

Format

48. What is the use of the Lookup Wizard?

To search records

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

To delete duplicates

To validate data

More Related Resources

9th Class Computer: chapter 8 Intro...

Can't find what you're looking for? Search below:

Latest Updates

Computer Software and Hardware Test 7 Online
SEO Mcqs Test Online
Computer Network Skills Test 6 Online
MS Windows 7 Basic Info Test Online
Python Mcqs Test Online
Computer Data Communication Online Test
Computer MS Excel Shortcuts Keys Test 3 Online
Basic Computer Information Test 3 Online

Mustansar KhanLast Updated: October 15, 2025

Important Introduction to Microsoft Access Question and Answer

Computer Introduction to Microsoft Access Practice Test Online With Explanation

Uncategorized

More Related Resources

Latest Updates

Mustansar Khan

Leave a Reply Cancel reply