Home/ECAT/ECAT Computer Science Introduction to Microsoft Access Test Online

ECAT Computer Science Introduction to Microsoft Access Test Online

Mustansar KhanLast Updated: May 1, 2025

ECAT Computer Science Introduction to Microsoft Access Test

ECAT Computer Science Chapter 15 Introduction to Microsoft Access Online Test

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

ECAT Introduction to Microsoft Access Test Online MCQs

Please wait...

Page 1 of 2

Uncategorized

1. What is the Row Source property used for?

Generating primary keys

Creating reports

Linking data to combo boxes or list boxes

Formatting rows

2. Which feature allows you to filter records quickly?

Filter by Selection

Form View

Module

Pivot Table

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

Report Wizard

AutoNumber

Table

Totals row in Datasheet View

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

Queries

Macros

Validation Rule property

Reports

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

Format

Input Mask

Field Size

Required

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

Filter by Form

Navigation Pane

Search Box

Design View

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

PowerPoint

Access

Excel

Word

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

ORDER BY

GROUP BY

HAVING

WHERE

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

Report

Query

Table

Form

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 property controls how data is displayed but not stored?

Validation Rule

Format

Input Mask

Field Size

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

Currency

Number

Short Text

AutoNumber

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

Form

Report

Query

Table

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

To convert data types

To sort values

To filter records

To control how data is entered

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

Datasheet View

Layout View

Print Preview

Report View

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

Report Wizard

Design View

Create Tab

External Data Tab

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

Print Preview

SQL View

Design View

Datasheet View

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

100

255

500

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

Long Text

Text

AutoNumber

Hyperlink

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

Must be entered manually

It's a text-based field

Automatically increments value

Requires formatting

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

Layout View

Table View

Datasheet View

Form View

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

Backup Tool

Record Locking

Query Wizard

Form View

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

Macro

Table

Query

Form

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

Printing and presenting data

Query design

Data entry

Form creation

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

File

Home

External Data

Create

Page 2 of 2

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

Only reports can define relationships

A table can only have one relationship

Relationships help link data across tables

Access does not support relationships

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

Sorting records

Uniquely identifying each record

Filtering

Formatting

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

Short Text

Hyperlink

Number

Long Text (Memo)

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

Report

Form

Query

Table

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

Append query

Select query

Delete query

CrossTab query

31. What is a parameter query?

A query used only in reports

A read-only query

A query with foreign key

A query that asks the user for input

32. In Access, what is a macro?

A data entry field

A stored procedure

A set of actions to automate tasks

A type of table

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

Report Layout

Query Design

Relationship Window

Table Wizard

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

F11

Ctrl + P

Ctrl + W

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

Worksheet

Report

Table

Query

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

Short Text

Number

Date/Time

Picture

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

Layout View

Form View

Report View

Datasheet View

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

Remove Form

Drop Table

Delete Query

Truncate Table

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

Update query

Append query

Select query

Make Table query

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

Copy-Paste

Append Query

Make Table Query

Export to Excel

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

Field Size

Input Mask

Required

Format

42. What is the use of the Lookup Wizard?

To validate data

To search records

To delete duplicates

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

43. Which of the following relationships ensures referential integrity?

One-to-many with foreign key

One-to-one

Self-join

Many-to-many

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

Print Preview

Report View

Datasheet View

Design View

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

Select query

Crosstab query

Append query

Parameter query

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

128

255

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

.docx

.accdb

.xlsx

.mdb

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

Form

Report

Query

Macro

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

UET Peshawar Entry Test 2025 Registration Online ETEA Test D...
ECAT Statistics Test Set 17
ECAT Statistics Test Set 16
ECAT Statistics Test Set 15
ECAT Statistics Test Set 14
ECAT Statistics Test Set 13
ECAT Statistics Test Set 12
ECAT Statistics Test Set 11
ECAT Statistics Test Set 10
ECAT Statistics Test Set 9

Mustansar KhanLast Updated: May 1, 2025

Facebook Twitter Reddit WhatsApp Share via Email Print

ECAT Computer Science Introduction to Microsoft Access Test Online

ECAT Computer Science Introduction to Microsoft Access Test

ECAT Computer Science Chapter 15 Introduction to Microsoft Access Online Test

ECAT Introduction to Microsoft Access Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply