Microsoft Access Forms and Reports Mastery: Key Concepts

Classified in Computers

Written on in English with a size of 3.01 KB

In Form view, you can go to the last record in the table by pressing the ____ keys. CTRL+END
____ levels are useful for reports with multiple levels. GROUPING
A form can be used to display fields from multiple records at one time by specifying the ____ layout. TABULAR
The second Form Wizard dialog box asks you to select a ___ for the form. LAYOUT
To change a form's style you must switch to ____. LAYOUT VIEW
To move from record to record in a form you can use the ___. NAVIGATION BUTTONS
You can move from field to field within a form by using the ___. TAB KEY
You can activate the Find command from the button on the ___ tab. HOME
When printing a form, you can choose to print ____. ALL PAGES
When a pencil symbol appears in the top-left portion of the form, it means that the form____. IS IN EDITING MODE
A form that accesses data from two tables has a main form and a ___. SUB FORM
When creating a form accessing data from two tables, Access uses the defined ____ to join the tables. RELATIONSHIP
Creating a form to access data from two tables requires that the tables ____. BE RELATED
When you create a form containing data from Two tables that have a one-to-many relationship, you create a ____ for Data from the primary table. MAIN FORM
Access can assist you in creating a report by using the ___. REPORT WIZARD
If a form shows two sets of navigation buttons, the bottom set is for the __. PRIMARY TABLE
Every item that you can manipulate to modify the object's appearance on a report is called a ___. CONTROL
The set of field values for the fields in a report that belong to a related table are called detail _____. RECORDS
The Columnar and ____layouts display the fields from one record at a time. JUSTIFIED
The ___record contains the set of field values for each related table record in a report. DETAIL
You've just navigated to the end of your form. What did you do? BOTH CTRL+END & LAST RECORD NAVIGATION BUTTON
To locate all records with the 316 area code and 282 exchange, he should use Find with ____. 3##-282-????
Tom wants to see a list of all donations from The Donations table listed with first and last name of each donor on The same line. This would be a _____ report. UNGROUPED
Tom wants to change the title of a report he created with the Report Wizard. To do this he should ___. DOUBLE CLICK THE TITLE CONTROL 
Emma has previewed the Guests and Reservations form and sees that the subform needs to have more room for All the fields to display fully. She should ___to fix the problem. ALL OF THE ABOVE
Emma is wondering what the similarities are between a report and a form. Which isn't a similarity? BOTH HAVE PRINT PREVIEW AS A VIEW ON THE HOME TAB



Related entries: