Home/ECAT/ECAT Computer Science Microsoft Access-Forms and Reports Test Online

ECAT Computer Science Microsoft Access-Forms and Reports Test Online

Mustansar KhanLast Updated: May 1, 2025

ECAT Computer Science Microsoft Access-Forms and Reports Test

ECAT Computer Science Chapter 17 Microsoft Access-Forms and Reports Online Test

Total Questions:	35
Time Allowed:	20 Minutes
Total Marks:	35
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 Microsoft Access-Forms and Reports Test Online MCQs

Please wait...

Page 1 of 2

Uncategorized

1. Which of the following form types displays data in two synchronized views?

Tabular Form

Split Form

Datasheet Form

Subform

2. Which type of form allows you to view one record at a time?

Split Form

Single Form

Datasheet Form

Continuous Form

3. What is the use of conditional formatting in reports?

To apply visual formatting based on data values

To run macros

To define print layout

To change fonts globally

4. What is the function of a control in a form?

To print reports

To display or collect data

To run macros

To filter queries

5. Which type of report displays summary data only?

Columnar Report

Crosstab Report

Tabular Report

Summary Report

6. Which view is used to enter or edit data in a form?

Datasheet View

Design View

Layout View

Form View

7. Which feature allows grouping of data in a report?

Filter by Form

Group & Sort

Conditional Formatting

Sorting only

8. Which section in a report is printed for every record?

Page Header

Detail

Report Header

Group Footer

9. Which property of a form determines if users can edit data?

Allow Macros

Allow Edits

Locked

Visible

10. Which control is used to display values from a related table?

Label

Combo Box

Text Box

Command Button

11. Which control is used to trigger actions such as opening forms or running queries?

Option Button

Command Button

Combo Box

Text Box

12. Which form control is best for selecting a value from another table?

Combo Box

Label

Text Box

Line

13. Which tool helps you create basic forms quickly?

Query Wizard

Report Wizard

Form Wizard

Form Design

14. Which property defines the appearance of a control?

Control Source

Format

Row Source

Tab Order

15. What is the Control Source property in a control?

Controls the alignment of the control

Enables conditional formatting

Specifies the field or expression that the control displays

Sets the color of the control

16. What is the advantage of using Layout View?

You can change the data source

You can modify design while viewing live data

You can delete relationships

You can apply filters only

17. Which tool in Access helps set the tab order of controls in a form?

Expression Builder

Macro Builder

Form Wizard

Tab Order Tool

18. Which button is commonly used to close a form?

Refresh Button

Command Button with Close macro

Cancel Button

Submit Button

19. What is the use of the Report Wizard?

To automatically generate reports with selected fields and layout

To manage forms

To filter data

To design tables

20. What is the primary purpose of a report in Access?

Executing queries

Updating tables

Data entry

Printing and displaying data in a readable format

21. Which control allows multiple selection from a list?

Text Box

Combo Box

List Box with Multi Select

Check Box

22. What is a bound control?

A control that is connected to a table or query field

A control used only in reports

A control for navigation

A control that displays static text

23. Which view allows you to design the structure of a form?

Design View

Print Preview

Layout View

Form View

24. In forms and reports, what is a label control used for?

Calculations

Data entry

Linking tables

Displaying field names or titles

25. Which object in Access is used to create a user-friendly interface for data entry?

Report

Query

Table

Form

Page 2 of 2

26. What is the function of a subform?

To change table structures

To include a form within another form

To sort data

To print records

27. Which property controls the source of data for a form or report?

Record Source

Control Source

Caption

Format

28. Which section of a report is printed once at the beginning?

Page Header

Group Header

Report Header

Detail

29. Which of the following is not a section in a typical Access report?

Page Footer

Group Text

Detail

Report Header

30. Which form control is used to show yes/no options?

List Box

Option Group

Label

Check Box

31. Which of the following can be added to a report for visual aid?

Query

Relationship

Macro

Image

32. Which of the following views lets you interact with form controls?

Layout View

Form View

Design View

Datasheet View

33. Which of the following is true about a tabular form?

It shows one field per page

It displays records in a spreadsheet-like format

It is used only for printing

It cannot be edited

34. Which of the following views allows you to preview a report before printing?

Design View

Report View

Print Preview

Layout View

35. What is a calculated control in a form?

A control displaying the result of an expression

A control displaying data from a table

A control storing user input

A control for form 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 Microsoft Access-Forms and Reports Test Online

ECAT Computer Science Microsoft Access-Forms and Reports Test

ECAT Computer Science Chapter 17 Microsoft Access-Forms and Reports Online Test

ECAT Microsoft Access-Forms and Reports Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply

ECAT Computer Science Microsoft Access-Forms and Reports Test

ECAT Computer Science Chapter 17 Microsoft Access-Forms and Reports Online Test

ECAT Microsoft Access-Forms and Reports Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Your Related

ECAT Statistics Test Set 12

ECAT Physics Motion and Force 2 Online Test

ECAT English Antonyms 7 Online Test

ECAT English Spotting Errors Test 2 Online Preparation

UET Lahore, Taxila ECAT Physics Entry Test Online Preparation

ECAT Physics Circular Motion Online Test

Leave a Reply Cancel reply