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 purpose of the Input Mask property in a field?

To sort values

To filter records

To control how data is entered

To convert data types

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

Table

Worksheet

Query

Report

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

Filter by Form

Design View

Navigation Pane

Search Box

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

Form

Table

Query

Report

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

A table can only have one relationship

Relationships help link data across tables

Only reports can define relationships

Access does not support relationships

6. What is the Row Source property used for?

Generating primary keys

Linking data to combo boxes or list boxes

Creating reports

Formatting rows

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

AutoNumber

Currency

Number

Short Text

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

Append query

Select query

Parameter query

Crosstab query

9. Which of the following relationships ensures referential integrity?

Self-join

Many-to-many

One-to-many with foreign key

One-to-one

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

Design View

SQL View

Datasheet View

Print Preview

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

ORDER BY

WHERE

GROUP BY

HAVING

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

File

Create

Home

External Data

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

Design View

Datasheet View

Print Preview

Report View

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

Append query

Delete query

Select query

CrossTab query

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

Datasheet View

Report View

Layout View

Print Preview

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

Query

Form

Table

Report

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

Delete Query

Remove Form

Drop Table

Truncate Table

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

Uniquely identifying each record

Formatting

Sorting records

Filtering

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

Long Text

Hyperlink

Text

AutoNumber

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

.mdb

.accdb

.xlsx

.docx

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

Format

Field Size

Required

Input Mask

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

Update query

Append query

Make Table query

Select query

23. Which feature allows you to filter records quickly?

Filter by Selection

Module

Form View

Pivot Table

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

Input Mask

Required

Format

Field Size

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

Form

Query

Report

Table

Page 2 of 2

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

Macro

Table

Query

Form

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

Query

Macro

Report

Form

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

Totals row in Datasheet View

Table

AutoNumber

Report Wizard

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

Queries

Validation Rule property

Reports

Macros

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

Short Text

Number

Picture

Date/Time

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

Column formatting

Input form layout

Type of data stored in a field

Table sorting order

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

Number

Short Text

Long Text (Memo)

Hyperlink

33. In Access, what is a macro?

A data entry field

A type of table

A set of actions to automate tasks

A stored procedure

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

External Data Tab

Report Wizard

Create Tab

Design View

35. What is the use of the Lookup Wizard?

To delete duplicates

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

To validate data

To search records

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

Form View

Datasheet View

Layout View

Table View

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

128

255

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

Field Size

Format

Validation Rule

Input Mask

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

Query Design

Relationship Window

Report Layout

Table Wizard

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

PowerPoint

Excel

Access

Word

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

Copy-Paste

Make Table Query

Export to Excel

Append Query

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

Data entry

Query design

Form creation

Printing and presenting data

43. What is a parameter query?

A query used only in reports

A query that asks the user for input

A query with foreign key

A read-only query

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

Query Wizard

Record Locking

Form View

Backup Tool

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

Must be entered manually

It's a text-based field

Requires formatting

Automatically increments value

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

500

255

100

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

Report View

Layout View

Form View

Datasheet View

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

F11

Ctrl + W

Ctrl + P

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

Sibbi MCKRU University Jobs NTS Test Preparations…
District & Sessions Court Jobs Lahore 2025 NTS Test…
NTS Latest Jobs Test Preparation online
Islamic Studies General Knowledge Online Test [Updated 2025]
Join PAF Tests Online Preparation
Pakistan Air Force Jobs 2025 Online Test Preparation
Educators Arts & Science Written Test Online Preparation
World Countries Wise GK Info Quizzes Online Test Preparation

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

Related:

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply

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

Related:

You Might Also Like

Mustansar Khan

Your Related

ECAT Computer File Handling in “C” Test Online

ECAT Computer Science Information Networks Test Online

ECAT Chemistry The Halogens and Noble Gases Test Online

ECAT Computer Peripheral Devices Test Online

ECAT Computer Fortran Online Test

ECAT Chemistry Gases 3 Test Online

Leave a Reply Cancel reply