You can filter mail merge records by clicking the ____ link in the Refine recipient list section, which opens the Filter and Sort dialog box with the Filter Records tab selected. | Filter |
The ____ section displays information at the bottom of each form. | Form Footer |
Point to a button in the Controls group to display its name in a ____. | Screen Tip |
A _________ is a doucment that includes codes that insert information from a data source. | Form Letter |
Another way to resize a report is to use the report ____, which appears in the upper-left corner of the report, where the horizontal and vertical rulers intersect. | Selector |
The data source for a form letter can be a(n) ____. | Access, Excel and Word |
Another option for locating data quickly is to use the ____ command, which is available when you are using a table or query datasheet, form, or report. | Find |
You can use the ____ link in the Mail Merge task pane to add an address to the letter in the location of the insertion point. | Address Block |
In a CSV file, ____ separate the field values of each record in the data source. | Commas |
When ____ appear in a report, they appear in controls. | Fields |
The ___________________ lets you create a report that you can use to print standard or custom labels. | Label Wizard |
When you export the data from the database, it will be saved as an RTF file, which stands for _______. | Rich Text Format |
When a field name in the data source contains a space, the merge field in Word replaces the space with a(n) __________ character. | Underscore |
When you use a wizard to create a report, the report opens in ________________. | Print Preview |
The ____ tool creates a simple form that includes all the fields in the selected table or query, uses a simple format, and includes a title with the same name as the record source. | Form |
When you import data from a Word document, it is usually best to store it in a Word ____. | Table |
When you insert a merge field in a Word document, the field name is enclosed in double | Angle Brackets |
A(n) ____________________ is a database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report | Report |
You must be in ________________ view to add controls such as lines, rectangles, and labels to a form. | Design |
When you need to create a simple form quickly, you can use the ____________________, which helps you create a form by letting you select options in dialog boxes to specify the form’s record source and layout. | Form Wizard |
A form’s style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme. | Theme |
When you create a form, it contains one section called the _______________ section. | Detail |
A ____________________ is a “container” that groups together the controls in a form so that you can change them as a group. | Control Layout |
To delete a control from a form, click the control to select it, and then press ____________________. | Delete |
A _________________ control is connected to a field in the record source and is used to display, enter, and update data. | Bound |
If you are creating a document from scratch, the first step is to select the type of document you are creating. For a form letter, choose the ___________________ option button. | Letters |
The data in a report is ____________, which means that you can view it but you cannot change it. | Read Only |
A ____________________ is the file used in a mail merge that contains information that does not vary from one document to the next, can also be called a form letter. | main document |
You can _____________ data from a Word document into an existing database table when the data has the same number of columns and the same type of data as the database table. | import |
When you insert codes in a main document they are called _____________________. | merge fields |
When data is formatted using comma separators, it is called ______________________. | delimited data |
A(n) ____________________ organizes data based on one or more fields. | Grouping Level |
The _____________________ field stores unique values for each record in a table. | Primary Key |
Table, form, and report objects in the database can have the same name, but you cannot give the same name to a table and a _______ in the same database. | Query |
A/an ________ control is not connected to a record source and issued to display information, lines, rectangles, and pictures. | Unbound |
You can use the Undo button on the Quick Access toolbar to restore a deleted field value, but deleting a ______ permanently deletes it from the record source. | Record |
In the bottom pane of the Split From tool, you will see a _______ that contains the form data. | Datasheet |
When fields appear in a form, they appear in ________. | Controls |
The _____________ section is printed at the top of every page of the report. | Page header |
The ____________ section is printed once at the top of the first page of the report, and usually includes the report title. | Report Header |
The _____________ section is printed once for each row in the record source and contains the main body of the report. | Detail |
The _____________ section is printed at the beginning of each new group of records. | Group Header |
The _____________ section is printed once at the bottom of the last page of the report, and usually includes summary information for the entire report. | Report Footer |
What dialog box displays when you click the External data tab and then click the Excel button in the Export group quizlet?
Import an Excel worksheet into an Access database with the Excel button in this group on the External Data tab. Click this button in the Export group to display the Export-Excel Spreadsheet wizard dialog box.
When an access object is exported to word it is saved with the .rtf file extension What does RTF stand for?
The Rich Text Format (often abbreviated RTF) is a proprietary document file format with published specification developed by Microsoft Corporation from 1987 until 2008 for cross-platform document interchange with Microsoft products.
On which tab in access will you find buttons for exporting data?
To export data from Access, first select the table or other database object to export in the Navigation Pane. Then click the “External Data” tab in the Ribbon. Then click the button in the “Export” button group for the file format to which to export the object.
What is displayed in the three row grid in the middle of the Edit Relationships dialog box?
What is displayed in the three-row grid in the middle of the Edit Relationships window? one row to display in the results datasheet for each group.