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. What is the function of a control in a form?

To run macros

To filter queries

To print reports

To display or collect data

2. Which property defines the appearance of a control?

Row Source

Tab Order

Control Source

Format

3. What is the function of a subform?

To sort data

To change table structures

To print records

To include a form within another form

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

Report Header

Detail

Group Footer

Page Header

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

Label

Text Box

Command Button

Combo Box

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

Sorting only

Conditional Formatting

Group & Sort

Filter by Form

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

Layout View

Form View

Print Preview

Design View

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

Line

Text Box

Combo Box

Label

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

Page Footer

Report Header

Detail

Group Text

10. Which tool helps you create basic forms quickly?

Report Wizard

Form Wizard

Form Design

Query Wizard

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

Report View

Design View

Layout View

Print Preview

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

To run macros

To define print layout

To change fonts globally

To apply visual formatting based on data values

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

Specifies the field or expression that the control displays

Enables conditional formatting

Sets the color of the control

Controls the alignment of the control

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

Relationship

Query

Image

Macro

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

Text Box

Combo Box

Option Button

Command Button

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

Command Button with Close macro

Refresh Button

Submit Button

Cancel Button

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

Macro Builder

Expression Builder

Tab Order Tool

Form Wizard

18. Which control allows multiple selection from a list?

Check Box

List Box with Multi Select

Combo Box

Text Box

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

Table

Form

Query

Report

20. What is the advantage of using Layout View?

You can modify design while viewing live data

You can change the data source

You can delete relationships

You can apply filters only

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

Form View

Design View

Datasheet View

Layout View

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

Printing and displaying data in a readable format

Executing queries

Updating tables

Data entry

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

Locked

Allow Edits

Visible

Allow Macros

24. What is a bound control?

A control for navigation

A control used only in reports

A control that displays static text

A control that is connected to a table or query field

25. Which type of report displays summary data only?

Tabular Report

Summary Report

Crosstab Report

Columnar Report

Page 2 of 2

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

Split Form

Single Form

Datasheet Form

Continuous Form

27. What is a calculated control in a form?

A control displaying the result of an expression

A control for form design

A control storing user input

A control displaying data from a table

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

Page Header

Group Header

Detail

Report Header

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

Linking tables

Calculations

Data entry

Displaying field names or titles

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

Check Box

List Box

Option Group

Label

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

It cannot be edited

It shows one field per page

It displays records in a spreadsheet-like format

It is used only for printing

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

Subform

Tabular Form

Split Form

Datasheet Form

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

Caption

Control Source

Format

Record Source

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

Form View

Datasheet View

Layout View

Design View

35. What is the use of the Report Wizard?

To manage forms

To design tables

To filter data

To automatically generate reports with selected fields and layout

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