| A | B |
|---|
| When you _____________________ the row height increases automatically to display additional lines until all the text is visible. | Wrap Text |
| Number _____________________ change the way data looks in a cell. | Formats |
| Unless you specify otherwise, number you enter in a cell are aligned to the ______________________. | Right |
| _____________________ enables you to copy formatting from one worksheet cell to another without copying the cell’s contents. | Format Painter |
| Unless you specify otherwise, text you enter in a cell are aligned to the ______________________. | Left |
| 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 |
| 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 top of every page of the report. | Page Header |
| The _____________ section is printed at the beginning of each new group of records. | Group Header |
| The ____________ section is printed once at the top of the first page of the report, and usually includes the report title. | Report Header |
| A(n) ____________________ is used to search for and retrieve data from tables using conditions. | Query |
| To add a condition to a field, click in the field’s _____________ box, and then type the condition. | Criteria |
| A(n) ____________________ is a collection of objects. | Database |
| A combination of numbers and text is also called _______________ data. | Alphanumeric |
| You can create a new table in a database by clicking the ____________________ tab on the Ribbon, and then clicking the Table button in the Tables group. | Create |
| Sorting a field in __________________ order arranges from Z to A, or largest to smallest. | Descending |
| Data in the database is stored in a ______________ which is similar to a worksheet in Excel. | Table |
| If you were creating a query that matches a range of values, you would need to include a relational ____________ in the condition. Example of these are >, <, =, >=, <=, <> | Operator |
| Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest. | Ascending |
| When you create a blank database, the table that Access creates for you contains one field named ID. Access sets the ID field as the table’s _____. | Primary Key |
| In _______________ view, you can add, delete, and make changes to the way that fields store data. | Design |
| Functions used to analyze loans and investments. | Financial Functions |
| Functions, such as the square root functions, that manipulate quantitative data in a worksheet. | Mathematical Functions |
| Functions that are used to insert dates and times in a worksheet. | Date & Time Functions |
| Functions that are used to format and work with cell contents. | Text Functions |
| Functions used to describe large quantities of data. | Statistical Functions |
| The data in a report is ____________, which means that you can view it but you cannot change it. | Read-Only |
| When data is formatted using comma separators, it is called ______________________. | Delimited Data |
| A(n) ____________________ organizes data based on one or more fields. | Grouping Level |
| 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 |
| 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 |
| The _____________________ field stores unique values for each record in a table. | Primary Key |
| 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 |
| When you insert codes in a main document they are called _____________________. | Merge Fields |
| Moving a _______________ affects 3-D references in the workbook. | Worksheet |
| The ______________________ function returns the current date and time based on the computer’s date and time settings. | NOW |
| A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then ______________________ the total sales in another worksheet. | Summarize |
| The ____________________ task pane provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias. | Research |
| The primary financial functions are future value, present value, and ________________. | Payment |
| The template includes all the parts of a workbook that will not change, such as text _______________, formulas, and formatting. | Labels |
| _______________ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell. | Formula AutoComplete |
| A ___________________ reference is a reference to the same cell or range in multiple worksheets that you use in a formula. | 3-D |
| You can make a perfect square or circle by pressing and holding the ________________ key as you drag in the worksheet to draw the shape. | Shift |
| A _______________________ is a picture of all or part of something you see on your monitor. | Screen Shot |
| A formula with a function has three parts: an ____________________, a function name, and (for most functions) at least one argument. | Equal sign |
| You can apply more than one filter to data to further limit the __________________ of data. | Subset |
| The _______________________ sheet has a white sheet tab. | Active |
| Adds the values in cell D10 of the Sheet2 worksheet and cell D11 of the Sheet3 worksheet | =Sheet2!D10+Sheet3!D11 |
| Adds the values in cells D10 and D11 of the Sheet2 worksheet | =SUM(Sheet2!D10:D11) |
| Adds the values in cell D10 in the Sheet2, Sheet3, and Sheet4 worksheets | =SUM(Sheet2:Sheet4!D10) |
| Inserts the value in cell D10 of the Sheet 2 worksheet | =Sheet2!D10 |
| Adds the values in cells D10 and D11 of the Sheet3 worksheet | =Sheet3!D10+Sheet3!D11 |
| To create a(n) ____________________ between two tables, you must design the tables so they contain a common field. | Relationship |
| When you enter a new record in the table, you do not need to type a value in the ID field if it has an ______________ data type for that field. | Autonumber |
| Each object in the navigation pane has a different ____________________ to identify its function. | Icon |
| The ___________ property specifies how you want Access to display numbers, dates, times, and text. | Format |
| The ___________ property enters the same field value in a field every time a new record is added to the table. | Default |
| Queries that are based on more than one table are referred to as ________. | Multiple Queries |
| Rows must all have the same height, however ________________ can have different widths. | Columns |
| The ______________ property specifies whether you must enter a field value in a record. | Required |
| A(n) ____________________ is a collection of objects. | Database |
| A field’s ____________________ determines the kind of data that you can enter in the field, such as numbers or text. | Data Type |
| An example of a square root function written correctly is ____. | =SQRT(C4) |
| 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 |
| A database is a collection of ____. | objects |
| A ____ is a reference in a worksheet that opens another file or page when you click it. | hyperlink |
| In a one-to-many relationship, one record in the first table (called the ____ table) can match many records in the second table (called the related table). | primary |
| You can switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys. | Ctrl+` (grave accent) |
| A _________ is a doucment that includes codes that insert information from a data source. | form letter |
| If you make changes to the layout of a datasheet and try to close the table, Access will ____. | prompt you to save your changes |
| If you are entering data for customers and all of your customers live in Texas, you may want to enter Texas as the _____________ value property the State field. | default |
| The data source for a form letter can be a(n) ____. | Access, Word & Excel |
| If you were applying for a loan online and forgot to enter your address, you would receive an error message “you must enter a value.” The address field property was probably set as | a required field |
| In a CSV file, ____ separate the field values of each record in the data source. | commas |
| As you format cells, ____ shows the results of the different formatting options you | Live Preview |
| When you export the data from the database, it will be saved as an RTF file, which stands for _______. | Rich Text Format |
| The SUM function that adds the numbers in the range D5:D17 is ____. | =SUM(D5:D17) |
| When you insert a merge field in a Word document, the field name is enclosed in double | angle brackets |
| ____ are predesigned workbook files that you can use as the basis or model for new workbooks. | Templates |
| ____ is a program known as a database management system (DBMS). | Access |
| The sequence used to calculate the value of a formula is called the ____. | order of evaluation |
| In Datasheet view, the table displays its data in rows and columns in a ____. | spreadsheet |
| When viewing a table in Design view, the bottom half of the Table window is called the Field ____ pane. | Properties |
| When you relate tables, Access uses a set of rules to ensure that there are matching values in the common field used to form the relationship, both at the time you create the relationship and as you enter data in the tables after you create the relationship. This set of rules is called ____. | referential integrity |
| To select multiple worksheets in a workbook, hold down the ____ key as you click the sheet tab of each worksheet you want to include in the group. | Ctrl |
