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 add records from one table to another?

Delete query

CrossTab query

Append query

Select query

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

Report View

Design View

Datasheet View

Print Preview

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

Layout View

Report View

Form View

Datasheet View

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

Report Wizard

Table

Totals row in Datasheet View

AutoNumber

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

Format

Input Mask

Field Size

Required

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

255

128

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

To filter records

To convert data types

To control how data is entered

To sort values

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

Datasheet View

Layout View

Form View

Table View

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

Datasheet View

SQL View

Design View

Print Preview

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

Select query

Parameter query

Crosstab query

Append query

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

Navigation Pane

Search Box

Filter by Form

Design View

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

Printing and presenting data

Form creation

Data entry

Query design

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

.docx

.accdb

.xlsx

.mdb

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

Report

Macro

Query

Form

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

Number

Short Text

Hyperlink

Long Text (Memo)

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

Relationship Window

Query Design

Table Wizard

Report Layout

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

F11

Ctrl + W

Ctrl + P

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

Long Text

AutoNumber

Text

Hyperlink

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

Must be entered manually

It's a text-based field

Automatically increments value

Requires formatting

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

Create Tab

External Data Tab

Report Wizard

Design View

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

Form

Report

Query

Table

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

Form

Table

Report

Query

23. Which of the following relationships ensures referential integrity?

One-to-one

Self-join

One-to-many with foreign key

Many-to-many

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

255

500

100

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

GROUP BY

ORDER BY

WHERE

HAVING

Page 2 of 2

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

Format

Validation Rule

Input Mask

Field Size

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

Truncate Table

Drop Table

Delete Query

Remove Form

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

Access does not support relationships

A table can only have one relationship

Relationships help link data across tables

Only reports can define relationships

29. Which feature allows you to filter records quickly?

Form View

Module

Pivot Table

Filter by Selection

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

Currency

Number

Short Text

AutoNumber

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

Queries

Macros

Reports

Validation Rule property

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

Select query

Append query

Update query

Make Table query

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

Append Query

Copy-Paste

Export to Excel

Make Table Query

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

Form

Report

Query

Table

35. What is the Row Source property used for?

Generating primary keys

Creating reports

Formatting rows

Linking data to combo boxes or list boxes

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

Date/Time

Short Text

Number

Picture

37. What is a parameter query?

A read-only query

A query used only in reports

A query with foreign key

A query that asks the user for input

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

Query

Report

Table

Worksheet

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

Print Preview

Datasheet View

Layout View

Report View

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

Table sorting order

Type of data stored in a field

Input form layout

Column formatting

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

Access

Word

PowerPoint

Excel

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

Form

Macro

Query

Table

43. What is the use of the Lookup Wizard?

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

To search records

To validate data

To delete duplicates

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

Input Mask

Required

Field Size

Format

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

File

Home

External Data

Create

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

Form View

Query Wizard

Backup Tool

Record Locking

47. In Access, what is a macro?

A type of table

A stored procedure

A data entry field

A set of actions to automate tasks

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

Formatting

Uniquely identifying each record

Sorting records

Filtering

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

ECAT Physics Atomic Spectra Test Online

ECAT English Antonyms 7 Online Test

NUST-Rawalpindi ECAT English Entry Test Preparation Online

ECAT Physics Electronics MCQS Online Test

ECAT Mathematics Conic Section Online Test

ECAT English Synonyms 4 Online Test

Leave a Reply Cancel reply