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 of the following views allows users to enter or edit data directly?

SQL View

Print Preview

Datasheet View

Design View

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

Form View

Backup Tool

Record Locking

Query Wizard

3. What is the use of the Lookup Wizard?

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

To search records

To delete duplicates

To validate data

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

Report

Form

Query

Table

5. In Access, what is a macro?

A type of table

A set of actions to automate tasks

A stored procedure

A data entry field

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

Form

Table

Macro

Query

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

Append query

Parameter query

Select query

Crosstab query

8. What is the Row Source property used for?

Linking data to combo boxes or list boxes

Generating primary keys

Formatting rows

Creating reports

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

Navigation Pane

Design View

Filter by Form

Search Box

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

Report

Form

Table

Query

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

Short Text

Picture

Date/Time

Number

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

Column formatting

Input form layout

Type of data stored in a field

Table sorting order

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

Query

Report

Table

Worksheet

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

Append Query

Make Table Query

Export to Excel

Copy-Paste

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

Delete Query

Drop Table

Truncate Table

Remove Form

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

Short Text

Number

Hyperlink

Long Text (Memo)

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

Select query

CrossTab query

Delete query

Append query

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

Report View

Layout View

Datasheet View

Form View

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

External Data Tab

Create Tab

Report Wizard

Design View

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

Layout View

Report View

Datasheet View

Print Preview

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

Design View

Print Preview

Report View

Datasheet View

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

Report

Macro

Form

Query

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

Required

Field Size

Input Mask

Format

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

Access does not support relationships

Only reports can define relationships

A table can only have one relationship

Relationships help link data across tables

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

External Data

Create

File

Home

Page 2 of 2

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

GROUP BY

WHERE

ORDER BY

HAVING

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

Query

Table

Form

Report

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

Report Wizard

Table

AutoNumber

Totals row in Datasheet View

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

100

500

255

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

Format

Input Mask

Required

Field Size

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

Requires formatting

Must be entered manually

Automatically increments value

It's a text-based field

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

Make Table query

Update query

Append query

Select query

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

Input Mask

Field Size

Validation Rule

Format

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

Ctrl + P

Ctrl + W

F11

35. What is a parameter query?

A query that asks the user for input

A read-only query

A query used only in reports

A query with foreign key

36. Which of the following relationships ensures referential integrity?

One-to-many with foreign key

Many-to-many

One-to-one

Self-join

37. Which feature allows you to filter records quickly?

Module

Filter by Selection

Pivot Table

Form View

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

Relationship Window

Report Layout

Table Wizard

Query Design

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

.docx

.mdb

.xlsx

.accdb

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

Short Text

Number

Currency

AutoNumber

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

Uniquely identifying each record

Filtering

Formatting

Sorting records

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

PowerPoint

Access

Word

Excel

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

Form creation

Printing and presenting data

Data entry

Query design

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

Validation Rule property

Macros

Reports

Queries

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

128

255

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

Datasheet View

Table View

Form View

Layout View

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

To filter records

To control how data is entered

To sort values

To convert data types

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

AutoNumber

Hyperlink

Text

Long Text

More Related Resources

9th Class Computer: chapter 8 Intro...

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

Latest Updates

Basic Information Technology Info Test 2 Online
Important Shortcuts Keys of Computer Keyboard Test Online
Windows 10 Shortcut Keys Test Online
Computer Elements of “C” Test Online
Computer Fortran Online Test
MS Office Information Test Online
Internet Explorer Shortcut Keys Test Online
Computer Table and Query Test 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