Your profile pic

computer MCQs

12th • Chapter 07

50 Questions TextBook
1

What is the primary function of a Form in Microsoft Access?

A
To perform complex calculations
B
To create the user interface for a table
C
To design the database schema
D
To link external data sources
2

The individual design elements that make up a form, such as buttons and text boxes, are called what?

A
Objects
B
Entities
C
Controls
D
Modules
3

Which type of form created by the Form Wizard displays one record at a time in a vertical format?

A
Tabular
B
Main/Subform
C
Graph
D
Single-column
4

In the Form Wizard, which button is used to move all available fields to the 'Selected Fields' list at once?

A
>
B
>>
C
<
D
<<
5

Which form layout displays multiple records at a time with fields in columns and records in rows?

A
Columnar
B
Justified
C
Tabular
D
Datasheet
6

To create a form from scratch without the wizard, you should select which option in the database window?

A
Create form by using wizard
B
Design View
C
AutoForm
D
Chart Wizard
7

In Design View, which tool is used to hold field names or other static text?

A
Text Box
B
Label
C
Combo Box
D
Option Group
8

What is the function of the 'New Record' button on the form window?

A
To save the current record
B
To delete the current record
C
To create a blank record for data entry
D
To print the current record
9

The feature in Design View that helps align form elements easily using a series of lines and dots is called?

A
Snap to Grid
B
Alignment Tool
C
Gridlines
D
Formatting Bar
10

How can you change the order in which the cursor moves through fields on a form?

A
By using the Tab Order option
B
By physically rearranging fields
C
By renaming the fields
D
By changing the data type
11

Page Headers and Footers added to a form are only visible when the form is...?

A
in Design View
B
in Form View
C
Printed
D
Saved
12

Which control is better for a long list of options, where values are not displayed until an arrow is clicked?

A
List Box
B
Check Box
C
Combo Box
D
Radio Button
13

When using radio buttons in an option group, how many options can be selected at one time?

A
Any or all
B
Only one
C
Exactly two
D
A maximum of five
14

Which control is most suitable for displaying yes/no or true/false values?

A
Text Box
B
Check Boxes
C
List Box
D
Command Button
15

A form that is placed inside another parent form is known as a...?

A
Child Form
B
Nested Form
C
Linked Form
D
Subform
16

Subforms are particularly useful for displaying data from tables that have what kind of relationship?

A
One-to-one
B
One-to-many
C
Many-to-many
D
No relationship
17

What is the presentation of processed data obtained from a database, which can be displayed on screen or printed, called?

A
A Form
B
A Query
C
A Report
D
A Table
18

Which of the following is a basic variety of a standard report?

A
Justified
B
Datasheet
C
Columnar
D
Graph
19

Which report layout resembles the layout of a form and spreads a single record's information over many rows?

A
Tabular
B
Columnar
C
Justified
D
Multi-page
20

Which control allows you to easily create multi-page forms?

A
Page Break
B
Subform Control
C
Tab Control
D
Section Control
21

Special formatting that depends on a control's value can be added using which feature?

A
AutoFormat
B
Conditional Formatting
C
Style Wizard
D
Format Painter
22

To make characters in a text box appear as asterisks for security, you should modify the...?

A
Validation Rule
B
Default Value
C
Format property
D
Input Mask property
23

Unlike importing, what does linking an object from another database do?

A
It copies the object and its data
B
It creates a shortcut without copying the table
C
It embeds the object permanently
D
It moves the object from the source
24

What is the built-in Access Add-In used to create a menu-driven interface for a database?

A
Form Wizard
B
Report Manager
C
Switchboard Manager
D
Database Utilities
25

Which keyboard shortcut is used to save a record in a form?

A
CTRL+S
B
SHIFT+ENTER
C
CTRL+ENTER
D
F11
26

What does the F5 key do in Access?

A
Opens Help
B
Toggles between Form and Design view
C
Finds and replaces text
D
Saves the database
27

To insert the current date in a field, which shortcut is used?

A
CTRL+D
B
CTRL+:
C
CTRL+;
D
ALT+D
28

What happens when you press the Tab key on the last field of a record in a form?

A
It moves to the first field of the same record
B
It saves the form and closes it
C
It creates a new record
D
It moves to the previous record
29

Which form layout displays a single record with labels and fields listed across the screen?

A
Columnar
B
Tabular
C
Datasheet
D
Justified
30

What is the purpose of the 'Control Wizards' button in the toolbox?

A
To check for code errors
B
To assist in creating complex controls like combo boxes
C
To change the form's theme
D
To validate data entry
31

A report can retrieve data from how many tables?

A
Only one
B
Exactly two
C
Only one table and one query
D
One or more tables
32

Which keyboard shortcut opens the 'Find and Replace' dialog box?

A
CTRL+H
B
CTRL+F
C
SHIFT+F
D
F7
33

In the Report Wizard, what is the purpose of the 'Priority' buttons?

A
To set the most important field
B
To change the sort order
C
To change the order of grouped fields
D
To highlight key data
34

To modify page margins and orientation for printing a report, you should use...?

A
File > Print Preview
B
File > Page Setup
C
Format > Page Layout
D
View > Report Settings
35

What is the term for combining a single-form and tabular format into one form?

A
Linked form
B
Complex form
C
Datasheet form
D
Main/subform
36

Which control object is used to enter and edit data in a form?

A
Label
B
Check Box
C
Text Box
D
Image
37

In the Command Button Wizard, what is the first step?

A
Choose the button's appearance
B
Name the button
C
Select an action category and action
D
Write VBA code for the button
38

Which option in the Combo Box Wizard allows you to remember the selected value for later use in a macro or procedure?

A
Store that value in this field
B
Remember the value for later use
C
Find a record on my form
D
Look up the values in a table
39

What type of control is best used for a short list of options (five or less)?

A
Combo Box
B
List Box
C
Radio Buttons or Check Boxes
D
Text Box
40

What is the main purpose of using a 'Report' in a database application?

A
To edit data quickly
B
To create a user-friendly data entry screen
C
To create printed copies of information
D
To build relationships between tables
41

What does the 'Snap to Grid' feature do in form Design View?

A
It connects objects to the data grid
B
It aligns form objects with the grid lines and dots
C
It quickly formats the entire form
D
It takes a picture of the grid
42

In Conditional Formatting, which condition applies formatting as soon as the field has focus?

A
Field Value Is
B
Expression Is
C
Field Has Focus
D
On Entry
43

How do you create a composite primary key?

A
Select one field and click the primary key button twice
B
Use a wizard to combine keys
C
Drag over multiple fields in Design View and click the primary key button
D
Write a query to define multiple keys
44

What does the keyboard shortcut CTRL+- (minus sign) do in a datasheet?

A
Adds a new record
B
Deletes the current record
C
Undoes the last action
D
Copies the previous record's data
45

Which of these styles is NOT listed as a visual style for a form in the Form Wizard?

A
Industrial
B
Modern
C
SandStone
D
Sumi Painting
46

To create a subform using the drag and drop method, you must first open the main form in...?

A
Form View
B
Datasheet View
C
Layout View
D
Design View
47

In the Report Wizard, how many fields can you sort your records by?

A
One
B
Two
C
Up to four
D
Unlimited
48

Which object is considered the 'front end' of a database in Microsoft Access?

A
Table
B
Query
C
Form
D
Report
49

Which type of AutoForm displays one record at a time?

A
Tabular
B
Columnar
C
Datasheet
D
Justified
50

What is used to display multiple records at a time in a tabular format?

A
A Tabular form
B
A Columnar form
C
A Subform
D
A Justified form