A ____ control, like a text box, is linked to data source while a _____ control, like a label, is used to describe data and create aesthetically pleasing forms
A(n) ____ is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options
If you need to sort records contained in a report, you can do so from the ______ of the report
In the first form wizard dialog box, you would specify the _____
tables or queries to be used and the fields to include
Jill must creat a report for an access database, but is unfamilar with creating reports in Access. Which report tool should Jill use?
Referencing the image above, What number represents the section that a page number would appear in the report
Referencing the image above, what number represents the section where a comprehensive total valve would appear in the report
Referencing the image above, what number represents the section where a the date and time would appear in the report
Referencing the image above, what number represents the section where data from a record source would appear in the the report.
Referencing the image above, what number represents the section where the title would appear in the report?
Steve is working in a database that holds patients data for a medical center. A patients identification number serves as a primary key in the patient table. A patient's identification number serves as a foreign key in the doctor table records with foriegn key value that matc the primary key value in the patient table. How should Steve proceed?
Use the form tool to create the form and access will analyze the table relationships Steve created in the database, and automaticaly add a subform form to his form.
What type of control is used to help keep controls aligned horizontally and vertically, giving forms a uniform appearance
what type of form diplays records in a tabular layout simular to a table's datasheet view but has more editing options, such as adding graphics and buttons, than a datasheet?
Multiple items form
When you use the Split Form tool, the ____ views are synchronized with each other at all times
Form and Data sheet
Which of the following statements accurately describes a Split form
Split Forms combine two different views of the same record source
Which of the following statements is NOT true regarding a Form's design view
record Source data is shown in Design view
Which of the following statements is true in reference to the report Detail section?
The detail section repeats for every record in the record source
Which of the following statements is true in referenece to comparing the sections in access forms and the sections in access reports
Reports have more sections than forms but working with reports sections is simular to working with Form section.
Which of the following statements is true when comparing forms and reports
Creating Forms and reports begin by sketching an outline of the the form or report
You are working on an Access form and want to apply programming logic to a field in the form. This can be done in _______.
You can use Form View to ____ the data in a report, fr example, to organize fields in order from A toZ
You can use the _____ to create specialized reports that come preformatted to fr name-brand labels such as Avery
You have been working in a database. Your boss ask you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?
You need to create a report from an access database containing sales figures. You want the report to include a final grand total and page numbers. Which of the following statements accurately defines what you must do in order to achieve these results?
Page numbers would included on the page footer section and the grand total would be included on the Report Footer Section