Microsoft Access

Computing

Quiz 4 :

Creating Forms and Reports

Quiz 4 :

Creating Forms and Reports

Question Type
search
arrow
Describe the process for moving a control to another location on a report in Layout view.
Free
Essay
Answer:

Answer:

There are many ways of moving a control to a new location on a report in Layout design:
• Click on the object or objects to select them and drag them from their place location to new location.
• Objects can be moved through the use of the arrow keys in the keyboard after selecting the object.

Tags
Choose question tag
close menu
arrow
To print only the current record displayed in a form, you need to select the img option button in the Print dialog box.
Free
Essay
Answer:

Answer:

Select Record Option
Records in the form can be printed in paper and you can print any number of copies. It allows you to print all the records or a particular record. You can select a range of pages to print records in selected rage of pages.
Set printer name, paper size, orientation in print dialog box. To print only the current record displayed in a form, you need to select the selected record(s) option button in print dialog box.
Therefore, the appropriate word to fill in the blank is Select record.

Tags
Choose question tag
close menu
arrow
In a form that contains a main form and a subform, what data is displayed in the main form and what data is displayed in the subform
Free
Essay
Answer:

Answer:

There exist one-to-many relationships between the two tables that are included in a form.
The main form contains data from the primary table and the subform contains data from the related table.
For example:
• Take a form having data of visits with the clinic's patients. The main form will have the key fields: patient ID (primary key), first and last names, date of birth, phone number and email address etc of every patient.
• The subform will contain the information about the visits of patients. i.e. subform contains the data from the related table.

Tags
Choose question tag
close menu
arrow
Identify three types of modifications you can make to a report in Layout view.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
img in a report (or form) is special formatting applied to certain field values depending on one or more conditions.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
What is a theme and how do you apply one to an existing form
Essay
Answer:
Tags
Choose question tag
close menu
arrow
In a(n) img report, the data from a record in the primary table appears together, followed on subsequent lines by the joined records from the related table.
Not Answered

There is no answer for this question

Tags
Choose question tag
close menu
arrow
Which wildcard character matches any single alphabetic character
Essay
Answer:
Tags
Choose question tag
close menu
arrow
When you create a report based on two tables that are joined in a one-to-many relationship, the field values for the records from the related table are called the img records.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
img is an item on a form, report, or other database object that you can manipulate to modify the object's appearance.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Which table record is displayed in a form when you press the Ctrl+End keys while you are in navigation mode
Essay
Answer:
Tags
Choose question tag
close menu
arrow
When working in Layout view for a report, which key do you press and hold down so that you can click to select multiple controls (field labels, field value boxes, and so on)
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Describe the difference between creating a form using the Form tool and creating a form using the Form Wizard.
Essay
Answer:
Tags
Choose question tag
close menu