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. In a report, which view is used to make changes to the structure?

Report View

Layout View

Datasheet View

Print Preview

2. What is the Row Source property used for?

Creating reports

Formatting rows

Linking data to combo boxes or list boxes

Generating primary keys

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

Export to Excel

Append Query

Make Table Query

Copy-Paste

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

Macro

Query

Table

Form

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

To sort values

To convert data types

To control how data is entered

To filter records

6. Which feature allows you to filter records quickly?

Module

Filter by Selection

Pivot Table

Form View

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

Access

Word

PowerPoint

Excel

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

WHERE

HAVING

ORDER BY

GROUP BY

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

500

100

255

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

Totals row in Datasheet View

Report Wizard

AutoNumber

Table

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

Field Size

Format

Input Mask

Required

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

Macros

Reports

Validation Rule property

Queries

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

Report View

Form View

Datasheet View

Layout View

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

Report View

Print Preview

Design View

Datasheet View

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

Relationship Window

Report Layout

Query Design

Table Wizard

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

Report

Form

Table

Query

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

Table

Report

Query

Form

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

Number

Date/Time

Short Text

Picture

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

.accdb

.docx

.xlsx

.mdb

20. In Access, what is a macro?

A type of table

A data entry field

A set of actions to automate tasks

A stored procedure

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

Field Size

Required

Input Mask

Format

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

Number

AutoNumber

Short Text

Currency

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

Filtering

Uniquely identifying each record

Formatting

Sorting records

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

Report Wizard

Design View

Create Tab

External Data Tab

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

It's a text-based field

Automatically increments value

Requires formatting

Must be entered manually

Page 2 of 2

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

Macro

Query

Report

Form

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

Append query

Select query

Update query

Make Table query

28. 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

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

Short Text

Number

Long Text (Memo)

Hyperlink

30. 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

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

Ctrl + P

Ctrl + W

F11

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

Design View

Print Preview

Datasheet View

SQL View

33. What is the use of the Lookup Wizard?

To delete duplicates

To search records

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

To validate data

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

Worksheet

Query

Report

Table

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

Report

Table

Query

Form

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

Table sorting order

Input form layout

Column formatting

Type of data stored in a field

37. Which of the following relationships ensures referential integrity?

One-to-many with foreign key

One-to-one

Many-to-many

Self-join

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

Table View

Layout View

Form View

Datasheet View

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

Remove Form

Truncate Table

Delete Query

Drop Table

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

Crosstab query

Append query

Parameter query

Select query

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

Long Text

Text

AutoNumber

Hyperlink

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

Select query

CrossTab query

Append query

Delete query

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

Navigation Pane

Design View

Filter by Form

Search Box

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

Format

Input Mask

Field Size

Validation Rule

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

Create

File

External Data

Home

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

255

128

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

Record Locking

Backup Tool

Query Wizard

Form View

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

Form creation

Data entry

Printing and presenting data

Query design

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 Current Electricity Online Test

ECAT English Prepositions 1 Online Test

ECAT Physics Electromagnetic Induction Test Online

ECAT English Spotting Errors Test 1 Online Preparation

ECAT Mathematics Trigonometric Identities Online Test

ECAT Computer Science Spreadsheet Software Test Online

Leave a Reply Cancel reply