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. Which query type is used to change data in a table?

Select query

Append query

Make Table query

Update query

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

100

500

255

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

Date/Time

Picture

Number

Short Text

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

Macro

Report

Form

Query

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

ORDER BY

GROUP BY

HAVING

WHERE

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

Field Size

Input Mask

Validation Rule

Format

7. What is the use of the Lookup Wizard?

To search records

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

To validate data

To delete duplicates

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

Excel

Word

Access

PowerPoint

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

Format

Field Size

Input Mask

Required

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

F11

Ctrl + P

Ctrl + W

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

To sort values

To convert data types

To filter records

To control how data is entered

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

Sorting records

Filtering

Formatting

Uniquely identifying each record

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

Short Text

Long Text (Memo)

Number

Hyperlink

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

Delete Query

Truncate Table

Remove Form

Drop Table

15. Which feature allows you to filter records quickly?

Form View

Filter by Selection

Module

Pivot Table

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

Reports

Queries

Validation Rule property

Macros

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

Design View

Report View

Datasheet View

Print Preview

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

128

255

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

Query design

Data entry

Printing and presenting data

Form creation

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

Crosstab query

Select query

Parameter query

Append query

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

Export to Excel

Append Query

Copy-Paste

Make Table Query

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

Form

Macro

Query

Table

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

File

Create

External Data

Home

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

Table

Totals row in Datasheet View

Report Wizard

AutoNumber

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

Form View

Layout View

Table View

Datasheet View

Page 2 of 2

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

Navigation Pane

Filter by Form

Design View

Search Box

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

.accdb

.xlsx

.docx

.mdb

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

Relationships help link data across tables

A table can only have one relationship

Access does not support relationships

Only reports can define relationships

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

Query Design

Report Layout

Relationship Window

Table Wizard

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

Format

Input Mask

Required

Field Size

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

Form

Table

Report

Query

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

Form View

Layout View

Datasheet View

Report View

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

Short Text

AutoNumber

Currency

Number

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

AutoNumber

Hyperlink

Long Text

Text

35. What is the Row Source property used for?

Formatting rows

Generating primary keys

Linking data to combo boxes or list boxes

Creating reports

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

Table

Report

Worksheet

Query

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

Select query

Delete query

Append query

CrossTab query

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

Table sorting order

Column formatting

Type of data stored in a field

Input form layout

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

Layout View

Report View

Print Preview

Datasheet View

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

Create Tab

Design View

External Data Tab

Report Wizard

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

Form

Table

Report

Query

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

Query Wizard

Form View

Backup Tool

Record Locking

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

Datasheet View

SQL View

Design View

Print Preview

44. In Access, what is a macro?

A set of actions to automate tasks

A stored procedure

A data entry field

A type of table

45. What is a parameter query?

A query that asks the user for input

A query with foreign key

A query used only in reports

A read-only query

46. Which of the following relationships ensures referential integrity?

One-to-one

One-to-many with foreign key

Many-to-many

Self-join

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

Requires formatting

Must be entered manually

It's a text-based field

Automatically increments value

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

Table

Report

Query

Form

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

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

Your Related

UET Lahore, Taxila ECAT English Entry Test Online Preparation

ECAT Mathematics Fundamentals of Trigonometry Online Test

ECAT Physics Vectors and Scalars Test Online

ECAT Chemistry Chemical Bonding Online Test

ECAT English Synonyms Test Online

ECAT Chemistry Common Chemical Industries in Pakistan Test Online

Leave a Reply Cancel reply