Excel and Access Exam INFS1020
30) Which of the following is NOT a common error message? A) #NPV? B) #NAME? C) #REF! D) #VALUE!
A) #NPV?
7) When navigating a main form, pressing ________ will move the cursor to the first field of the current record. A) $$$Home$$$ B) $$$End$$$ C) $$$Tab$$$ D) $$$Ctrl$$$ + $$$Home$$$
A) $$$Home$$$
23) ________ is an example of the General Date format. A) 11/9/2015 10:10:10 PM B) Wednesday, November 9, 2015 C) 9-Nov-15 10:10:10 PM D) Wednesday, November 9, 2015 10:10 PM
A) 11/9/2015 10:10:10 PM
3) Formulas and functions begin with a(n) ________ sign. A) = B) # C) @ D) &
A) =
3) When cell B2 containing the formula =A4*B6 is copied to cell C1, the formula in cell C1 is ________. A) =A4*B6 B) =B3*C5 C) =A4*C5 D) =B3*C6
A) =A4*B6
20) A(n) ________ is the file extension for an Access 2007-2013 database template. A) ACCDB B) MDB C) MDE D) ACCDT
A) ACCDB
26) When you want to specify multiple criteria, and all criteria must be true for a record to be included in the results, then the ________ logical operator is used. A) AND B) OR C) NOT D) BETWEEN
A) AND
22) The Merge & Center button is located in the A) Alignment group on the HOME tab. B) Styles group on the HOME tab. C) Alignment group on the PAGE LAYOUT tab. D) Styles group on the LAYOUT tab.
A) Alignment group on the HOME tab.
3) Which of the following is true when breaking compound fields into smaller parts? A) Break names into first name and last name fields. B) Leave city, state, and zip code together in one field. C) For faster sorting, include the street address in the same field as the city, state, and zip code field. D) Always separate the area code from the phone number field.
A) Break names into first and last name fields.
12) To insert a comment into a cell, you click New Comment in the: A) Comments group on the REVIEW tab. B) Comments group on the INSERT tab. C) Documentation group on the REVIEW tab. D) Documentation group on the INSERT tab.
A) Comments group on the REVIEW tab.
26) The keyboard shortcut to hide or show formulas in a worksheet is ________. A) Ctrl + ~ B) Ctrl + @ C) Alt + ~ D) Alt + @
A) Ctrl + ~
16) The Navigation Pane allows for all of the following views except ________. A) Custom B) Object Type C) Queries and Related Views D) Created Date
A) Custom
1) Which of the following is NOT a primary business charting objective? A) Data modification B) Data exploration C) Argumentation D) Hypothesis testing
A) Data modification
11) To display the Create Names from Selection dialog box, you click Create From Selection in the: A) Defined Names group on the FORMULAS tab. B) Edit group on the FORMULAS tab. C) Defined Names group on the HOME tab. D) Edit group on the HOME tab.
A) Defined Names group on the FORMULAS tab.
10) Which of the following is NOT an example of worksheet documentation? A) Descriptive drop-down documentation menus B) Descriptive worksheet names C) Descriptive cell labels D) Descriptive column titles
A) Descriptive drop-down documentation menus
2) If you can see the blinking insertion point in a field, you are in ________. A) Edit mode B) Design view C) Layout view D) Navigation mode
A) Edit Mode
14) Which of the following is NOT an Excel function category? A) Educational B) Cube C) Logical D) Financial
A) Educational
17) To insert a line break or hard return in a cell, you would press ________. A) Enter B) Ctrl + Enter C) Alt + Enter D) Shift + Enter
A) Enter
8) When you ________, you select a value in a record and Access filters the records that contain only the values that match what you have selected. A) filter by selection B) use the Find command C) use the Replace command D) use the Navigation bar
A) Filter by selection
12) A ________ query is used when you want to find records with the same specific value. A) Find Duplicates B) Crosstab C) Find Unmatched D) Simple
A) Find Duplicates
13) The AutoSum button is located in the: A) Function Library on the HOME tab. B) Number group on the HOME tab. C) Function Library group on the FORMULAS tab. D) Number group on the FORMULAS tab.
A) Function Library on the HOME tab.
16) A ________ chart is used to shows project schedule where each bar represents a project component or task. A) Gantt B) Flow C) Structure D) Venn
A) Gantt
21) Which of the following is NOT a unit value option for the DATEDIF? A) H B) M C) D D) Y
A) H
7) The Picture dialog box is displayed by clicking Pictures in the: A) Illustrations group on the INSERT tab. B) Show group on the INSERT tab. C) Illustrations group on the PAGE LAYOUT tab. D) Show group on the PAGE LAYOUT tab.
A) Illustrations group on the INSERT tab.
2) Which of the following is NOT a numerical format? A) Integer B) Accounting C) Short Date D) General
A) Integer
10) To show changes over time, you would use a ________ chart. A) Line B) Column C) Bar D) Pie
A) Line
16) Which of the following functions returns the number in the middle of a set of numbers? A) MEDIAN B) COUNTA C) MEAN D) AVERAGE
A) MEDIAN
18) The ________ function returns the number of workdays between to dates. A) NETWORKDAYS B) WORKING DAYS C) DAYS D) WEEKNUM
A) NETWORKDAYS
14) When you open a database, Access displays the ________ on the left side. A) Navigation Pane B) Property Sheet C) Forms Pane D) Shutter Bar Pane
A) Navigation Pane
21) Which of the following is NOT true about modifying a form's design? A) Oftentimes, forms are customized to match company or group color themes. B) Pictures and other objects can also be added to a form but can make the form too difficult to use. C) Customizing forms can make them more personal and sometimes easier to use. D) Controls can also be added to a form to include additional fields or labels with text.
A) Oftentimes, forms are customized to match company or group colors themes.
39) You can perform ________ Compact and Repair Database action at any time. A) one B) two C) three D) four
A) One
6) When there are multiple worksheets, you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right. A) Page Down B) Page Up C) Home D) End
A) Page Down
22) To place an image into a chart, you click ________ in the Illustrations group on the INSERT tab. A) Pictures B) Figures C) Illustrations D) Images
A) Pictures
16) A(n) ________ key field is a field that uniquely identifies the record. A) primary B) identity C) foreign D) entity
A) Primary
26) Which of the following is NOT an Excel trendline type? A) Quadratic B) Linear C) Exponential D) Two-period moving average
A) Quadratic
31) ________ shows how the report would look in a continuous page layout. A) Report view B) Print Preview C) Layout view D) Design view
A) Report View
24) 4.5E + 13 is an example of the ________ format. A) Scientific B) Fixed C) Standard D) Percent
A) Scientific
21) Which of the following is NOT true about sorting query results on a single field? A) Sorting is the process of rearranging records within a table in a specific order. B) By default, records in a table or query are sorted by the primary key field. C) To sort records, you have to select a sort field, or a field used to determine the order of the records. D) A field may be sorted either in ascending order or descending order.
A) Sorting is the process of rearranging records within a table in a specific order.
28) Which of the following is NOT true about using special operators? A) Special operators are used to compare text values using Find & Replace along with the AND operator. B) Special operators are used to determine whether values are between a range of values using the BETWEEN operator. C) Special operators are used in a set of values using the IN operator. D) Special operators are used to compare text values using wildcards using the LIKE operator.
A) Special operators are used to compare text values using Find & Replace along with the AND operator.
15) The Total Row check box is located in the ________ group on the DESIGN tab. A) Table Style Options B) Number Styles C) Functions D) Totals
A) Table Style Options
15) Which of the following data types is NOT automatically right-aligned by Excel? A) Text B) Numeric C) Date D) Time
A) Text
27) To change the color of a chart , you click Change Colors in the: A) Chart Layouts group on the CHART TOOLS DESIGN tab. B) Chart Styles group on the CHART TOOLS DESIGN tab. C) Chart Layouts group on the CHART TOOLS FORMAT tab. D) Chart Styles group on the CHART TOOLS FORMAT tab.
B) Chart Styles group on the CHART TOOLS DESIGN tab.
12) To see possible types of graph to use, you can click Recommended Charts in the: A) Illustrations group on the INSERT tab. B) Charts group on the INSERT tab. C) Illustrations group on the VIEW tab. D) Charts group on the VIEW tab
B) Charts group on the INSERT tab.
13) If you wanted to compare the percentages of students in a class that received A's, that received B's, that received C's, and so on, you would use a ________ chart. A) Radar B) Column C) Scatter D) Pie
B) Column
17) A ________ chart can show information such as start and end times, sequence of tasks, and people assigned to each task. A) Scatter B) Combination C) Gantt D) Flow
B) Combination
11) A ________ query is used when you want to describe one field in terms of two or more fields in the table. A) Find Duplicates B) Crosstab C) Find Unmatched D) Simple
B) Crosstab
19) You can select a noncontiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse. A) Alt B) Ctrl C) F5 D) F7
B) Ctrl
21) After selecting a row, pressing the shortcut key ________ will insert a new row above the selected row. A) Ctrl + I B) Ctrl + + C) Ctrl + # D) Ctrl + R
B) Ctrl + +
16) The keyboard shortcut for Undo is ________. A) Ctrl + U B) Ctrl + Z C) Ctrl + Y D) Ctrl + W
B) Ctrl + Z
14) A ________ is a character such as a tab or comma that separates the fields. A) cell address B) delimiter C) named range D) range address
B) Delimiter
21) Which of the following is NOT true regarding tables and relational databases? A) Tables store data organized in an arrangement of columns and rows. B) Do not use special characters, such as an underscore, in table names. C) The power of a relational database comes when you link tables. D) A relational database is a database where data is stored in tables with relationships between the tables.
B) Do not use special characters, such as an underscore, in table names.
5) ________ Format Painter allows you to use it multiple times. A) Right-clicking B) Double-clicking C) Clicking while pressing Ctrl D) Clicking while pressing Alt
B) Double-clicking
25) The ________ format displays at least one digit after the decimal point. A) Scientific B) Fixed C) Standard D) Percent
B) Fixed
14) The base date for date and time data in Excel 2013 is ________. A) January 1, 1000 B) January 1, 1900 C) December 31, 999 D) December 31, 1899
B) January 1, 1900
30) ________ allows you to modify the report while seeing the data. A) Print Preview B) Layout view C) Report view D) Design view
B) Layout view
19) A(n) ________ is the file extension for an Access 2002-2003 database file. A) ACCDB B) MDB C) MDE D) ACCDT
B) MDB
29) ________ are small charts that are embedded into the cells in a worksheet to help with trend analysis. A) Minicharts B) Microcharts C) Sparklines D) Data bars
B) Microcharts
20) If two tables do not have a common field, Access will join the two tables by combining the records, regardless of whether they have a matching field. This is called the ________ effect. A) join B) multiplier C) relationship D) query
B) Multiplier
31) Sometimes your data will have a unique identifier that is already a part of your data. When that is true, you can use the field as a ________ key. A) foreign B) natural primary C) composite D) primary
B) Natural Primary
27) When you want to specify criteria in multiple fields, and at least one of the criteria must be true for a record to be included in the results, then the ________ logical operator is used. A) AND B) OR C) NOT D) BETWEEN
B) OR
27) Which of the following is NOT true about creating a report using the Report Wizard? A) In the Report Wizard, you can choose the table or query to base the report on, and choose the fields to include in the report. B) Once a report is created using the wizard, it will open in Design view. C) In the Report Wizard, you have the option to group the data in your report. D) The Report Wizard will walk you step by step through the process of building your report
B) Once a report is created using the wizard, it will open in Design view.
35) To print headings on multiple pages, you click Print Titles in the: A) Headings group on the PAGE LAYOUT tab. B) Page Setup group on the PAGE LAYOUT tab. C) Headings group on the PAGE VIEW tab. D) Page Setup group on the PAGE VIEW tab.
B) Page Setup group on the PAGE LAYOUT tab.
18) Which of the following lists follows Excel's order of operations? A) Parentheses Exponentiation Addition and subtraction Multiplication and division B) Parentheses Exponentiation Multiplication and division Addition and subtraction C) Exponentiation Parentheses Multiplication and division Addition and subtraction D) Exponentiation Parentheses Addition and subtraction Multiplication and division
B) Parentheses Exponentiation Multiplication and division
9) To illustrate the relationship of the parts to the whole, you would use a(n) ________ chart. A) Line B) Pie C) Scatter D) Area
B) Pie
30) ________ shows how the report would look on the printed page and allows you to change the page layout. A) Report view B) Print Preview C) Layout view D) Design view
B) Print Preview
34) The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report. A) Table B) Report C) Form D) Design
B) Report
7) The keyboard shortcut to move one column to the left is ________. A) Tab B) Shift + Tab C) Ctrl + Tab D) Alt + Tab
B) Shift + Tab
24) To hide or show gridlines in a worksheet, you click Gridlines in the: A) Workbook Views group on the VIEW tab. B) Show group on the VIEW tab. C) Workbook Views group on the HOME tab. D) Show group on the HOME tab.
B) Show group on the VIEW tab.
6) The Cell Styles gallery is displayed by clicking Cell Styles in the: A) Cells group on the HOME tab. B) Styles group on the HOME tab. C) Cells group on the PAGE LAYOUT tab. D) Styles group on the PAGE LAYOUT tab.
B) Styles group on the HOME tab.
9) The Table Styles gallery is displayed by clicking Format as Table in the: A) Themes group on the HOME tab. B) Styles group on the HOME tab. C) Themes group on the PAGE LAYOUT tab. D) Styles group on the PAGE LAYOUT tab.
B) Styles group on the HOME tab.
5) When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the main form and the second table you select becomes the ________. A) joined form B) subform C) co-form D) split form
B) Subform
2) To enter a footer or header to a worksheet, you click Header & Footer in the: A) Page setup group on the INSERT tab. B) Text group on the INSERT tab. C) Page setup group on the PAGE LAYOUT tab. D) Text group on the PAGE LAYOUT tab.
B) Text group on the INSERT tab.
36) Which of the following is NOT true when creating a backup database? A) In Access, you make backups by using the Back Up Database command. B) The Back Up Database command is available on Backstage view under Export. C) If you make multiple backup copies, you should give them different names. D) If you ever need a backup, simply return to the most recent copy that you have and start working with that file.
B) The Back Up Database command is available on Backstage view under Export.
38) Which of the following is NOT true about saving a report as a PDF file? A) If you need to distribute the report electronically, you also have the option to save the report as an Adobe PDF file. B) The correct terminology for saving a report as a PDF file format is to "repurpose" the report. C) An Adobe PDF file is usually smaller than the original document, is easy to send through e-mail, and preserves the original document look and feel so you know exactly what it will look like when the recipient opens it. D) When you are saving the re
B) The correct terminology for saving a report as a PDF file format is to "repurpose" the report.
2) Which of the following is NOT true about databases? A) Databases are used for two major purposes: for operational processing and for analytical purposes. B) The information in databases is summarized and classified to make data available to the decision makers. C) In operational or transaction-based databases, each sale or transaction that a business makes is tracked. D) Analytical databases are used for extracting data for decision making.
B) The information in databases is summarized and classified to make data available to the decision makers.
22) How is Access different from Excel? A) Access has numbered rows of data. B) Access allows you to manage data, perform calculations, and report on the data. C) Access allows multiple tables with relationships between the tables. D) Access has columns with labels.
C) Access allows multiple tables with relationships between the tables.
14) A(n) ________ chart is useful for showing categories that change over time and where each column represents a unit of time. A) Column B) Radar C) Area D) Surface
C) Area
10) ________ is a feature that can change the column width of the data to match the widest data entered in that field. A) Form fit B) Fit by selection C) AutoFit D) Field size
C) AutoFit
37) Which of the following is NOT true about printing a report? A) One way to print a report is to use the Print dialog box on the File tab to select your printing options. B) In Print Preview, you have many options to make design changes to your report before you send it to the printer. C) Before you print, it is always a good idea to view the report in Layout view to make sure it looks the way you want. D) In Print Preview, you can change the margins and orientation, and you can select how many pages, if not all, you want to print.
C) Before you print, it is always a good idea to view the report in Layout view to make sure it looks the way you want.
26) To change the width of a column, you click Column Width in the: A) Cells group on the FORMAT tab. B) Adjustment group on the FORMAT tab. C) Cells group on the HOME tab. D) Adjustment group on the HOME tab.
C) Cells group on the HOME tab.
21) To modify the layout and data in an existing chart, you click Change Chart Type in the: A) Chart Layouts group on the CHART TOOLS FORMAT tab. B) Type group on the CHART TOOLS FORMAT tab. C) Chart Layouts group on the CHART TOOLS DESIGN tab. D) Type group on the CHART TOOLS DESIGN tab.
C) Chart Layouts group on the CHART TOOLS DESIGN tab.
13) Which of the following is typically NOT contained in a separate documentation worksheet? A) Author B) Modification dates C) Charts D) Modification history
C) Charts
40) If you select ________, Access automatically compacts your database anytime you close it. A) Compact Now B) Compact on Exit C) Compact on Close D) Compact and Repair Database
C) Compact on Close
30) A university identifies a class by subject area and course number. The university has classes Math 101, Math 102, and MIS 101. It takes both subject and course number to identify a single course. The combination of the two fields is called a ________ key. A) foreign B) natural primary C) composite D) primary
C) Composite
31) The keyboard shortcut for inserting today's date is ________. A) Ctrl + T B) Ctrl + D C) Ctrl + ; D) Ctrl + :
C) Ctrl + ;
8) The keyboard shortcut to move to cell A1 is ________. A) Home B) Shift + Home C) Ctrl + Home D) Alt + Home
C) Ctrl + Home
29) The keyboard shortcut to display the Save As dialog box is ________. A) Alt + A B) Alt + S C) Ctrl + S D) Shift + S
C) Ctrl + S
1) The keyboard shortcut for apply the Comma format is ________. A) Ctrl + ! B) Ctrl + , C) Ctrl + Shift + ! D) Ctrl + Shift + ,
C) Ctrl + Shift + !
19) If you want to find the time between two dates, you would use the ________ function. A) DATE B) TIME C) DATEDIF D) WEEKNUM
C) DATEDIF
5) ________ is/are facts about people, events, things, or ideas. A) Knowledge B) A competitive advantage C) Data D) Information
C) Data
8) ________ define the kind of data that can be entered into a field, such as numbers, text, or dates. A) Field names B) Description C) Data types D) Field properties
C) Data Types
9) To modify a named range, you select its name in the Name Box, then click Name Manager in the: A) Defined Names group on the HOME tab. B) Edit Names group on the HOME tab. C) Defined Names group on the FORMULAS tab. D) Edit group on the FORMULAS tab.
C) Defined Names group on the FORMULAS tab.
10) ________ is the keyboard shortcut to display a list of named ranges. A) F1 B) F2 C) F3 D) F4
C) F3
5) Instead of typing the $ symbol in a cell reference, you can use the ________ keyboard shortcut. A) F2 B) F3 C) F4 D) F6
C) F4
25) Which of the following is NOT a Lookup or Reference function? A) VLOOKUP B) INDEX C) FIND D) MATCH
C) FIND
17) ________ indicates the maximum length of a data field. A) Input mask B) Format C) Field size D) Validation Rule
C) Field Size
3) In Datasheet view, you can use the ________ to quickly locate specific records using all or part of a field value. A) Replace command B) wildcard character C) Find command D) Find & Replace command
C) Find Command
13) A ________ query is used when you want to find the rows in one table that do not have a match in the other table. A) Find Duplicates B) Crosstab C) Find Unmatched D) Simple
C) Find Unmatched
29) Two fields needed to uniquely identify a record are called a ________ key. A) composite B) natural primary C) foreign D) primary
C) Foreign
28) Which of the following is NOT true about creating groups in a report? A) Grouping allows you to separate related records for the purpose of creating a visual summary of the data. B) A group is a collection of records along with introductory and summary information about the records. C) Groups can only be created with data from individual tables D) In the Report Wizard, you will have the option to group the data in your report.
C) Groups can only be created with the data from individual tables.
28) Which of the following is NOT true regarding foreign keys? A) The AutoNumber data type is typically used for foreign key fields. B) A foreign key is a field in a table that stores a value that is the primary key in another table. C) It is called foreign because it identifies a record in another table. D) Foreign keys do not need to be unique in the table.
C) It is called foreign because it identifies a record in another table.
23) Which of the following is NOT a problem that can be caused by using Excel to store data? A) Loss of data B) Errors in the data C) Lack of functionality D) Data redundancy
C) Lack of functionality
32) ________ shows the report and the data; some report design such as field lengths and fonts can be changed in this view. A) Report view B) Print Preview C) Layout view D) Design view
C) Layout View
15) If you wanted to find which value occurs most often in a cell range, you would use the ________ function. A) MEDIAN B) MEAN C) MODE.SNGL D) AVERAGE
C) MODE.SNGL
13) Access allows you to import a smaller portion of a worksheet, known as a ________, into a table. A) cell address B) delimiter C) named range D) range address
C) Named Range
4) Which of the following is NOT true about navigating forms? A) A form is an object in Access that you can use to enter, edit, or view records in a table. B) You navigate records in a form the same way you navigate a table, using buttons on the Arrow bar to move from record to record. C) Often seeing one record at a time in a form can eliminate data entry errors and allow the user to focus on the information for that particular record. D) A simple form allows you to see records one at a time rather than as a group in Datasheet view.
C) Often seeing one record at a time in a form can eliminate data errors and allow the user to focus on this information for that particular record.
7) Excel's ________ feature analyzes a selection in a worksheet and suggests chart types that best fit the selected data. A) Chart Wizard B) Chart Maker C) Recommended Charts D) Chart Styles
C) Recommended Charts
41) ________ is a database concept that ensures that relationships between tables remain consistent. A) A junction table B) Normalization C) Referential integrity D) Redundancy
C) Referential Integrity
18) To show the relationship between two numeric variables, you would use a ________ chart. A) Cluster B) Surface C) Scatter D) Radar
C) Scatter
23) To place an object such as a rectangle or circle into a chart, you click ________ in the Illustrations group on the INSERT tab. A) Figures B) Objects C) Shapes D) Forms
C) Shapes
10) The most appropriate data type to use for a Street Address field is the ________ data type, so a street address can contain numbers, letters, and special characters. A) Long Text B) Number C) Short Text D) Calculated
C) Short Text
34) Which of the follow is NOT a worksheet view? A) Normal view B) Page Layout view C) Spreadsheet Preview D) Page Break Preview
C) Spreadsheet Preview
4) Which of the following is NOT contained in a cell? A) Functions B) Formulas C) Subroutines D) Text
C) Subroutines
11) The Themes gallery is displayed by clicking Themes in the: A) Themes group on the HOME tab. B) Styles group on the HOME tab. C) Themes group on the PAGE LAYOUT tab. D) Styles group on the PAGE LAYOUT tab.
C) Themes group on the PAGE LAYOUT tab.
19) Which of the following is NOT a method used to open or switch views? A) To open an object in design view, right-click it in the Navigation Pane, and select Design View. B) To open an object in default view, double-click it in the Navigation bar. C) To switch views for an already open object, on the Home tab, in the Views group, click the View arrow, and then select your preferred view. D) To switch views for an already open object, right-click the object tab, and then select the preferred view.
C) To switch views for an already open object, on the Home Tab, in the Views group, click the View arrow, and then select your preferred view.
21) Which of the following is NOT true regarding table formatting? A) In a table design, you can define a Format field property that customizes how data is displayed and printed in tables, queries, reports, and forms. B) The Format property tells Access how data is to be displayed. C) You can define your own custom formats for Currency and Number fields. D) Formatting does not affect the way the data is stored.
C) You can define your own custom formats for Currency and Number fields
4) To search for a word that starts with "ar" you would enter ________. A) ar? B) ar# C) ar* D) ar!
C) ar*
17) A ________ control is a control whose data source is a calculated expression that you create. A) label B) bound C) calculated D) text box
C) calculated
23) To select several contiguous columns, you: A) click the header of the first column, then double-click the header of the last column. B) click the header of the first column, then right-click the header of the last column. C) click the header of the first column, press and hold Shift, and click the header of the last column. D) click the header of the first column, press and hold Ctrl, and click the header of the last column.
C) click the header of the first column, press and hold Shift, and click the header of the last column.
32) You can copy a worksheet within a workbook, by ________, and then dragging a copy of the worksheet to its new location. A) double-clicking on the worksheet tab B) right-clicking on the worksheet tab C) clicking on the worksheet tab, pressing and holding Ctrl D) clicking on the worksheet tab, pressing and holding Shift
C) clicking on the worksheet tab, pressing and holding Ctrl
3) The related data values used in creating a chart are called ________. A) a legend B) category labels C) data series D) value labels
C) data series
24) The result of =MID("Tallahassee",6,3) is ________. A) Tall B) lahass C) has D) hassee
C) has
37) A ________ relationship is a relationship between tables in which one record in one table has many matching records in a second table, and one record in the related table has many matching records in the first table. A) one-to-many B) one-to-one C) many-to-many D) This doesn't apply to any relationship type.
C) many-to-many
31) PNG, JPEG, and GIF are examples of file extensions used for ________ files. A) template B) dynamic worksheet C) picture D) chart or graph
C) picture
11) A comment is indicated by the presence of a ________ in the upper-right corner of a cell. A) red square B) blue square C) red triangle D) blue triangle
C) red triangle
22) A ________ is a built-in combination of colors and fonts. A) Form Wizard B) template C) theme D) control
C) theme
36) Headers and footers contain ________ section(s). A) one B) two C) three D) four
C) three
25) A(n) ________ is a line that uses current data to display the progress or general direction of the data. A) major gridline B) minor gridline C) trendline D) axis
C) trendline
28) If a numerical value is too narrow to be displayed in a cell, a series of ________ characters is displayed. A) & B) @ C) % D) #
D) #
32) Given the following information: What is the result of =C1/A7? A) #VALUE! B) #REF! C) #N/A D) #DIV/0!
D) #DIV/0!
19) Which of the following is Excel's symbol for multiplication? A) # B) & C) x D) *
D) *
5) The extension for Microsoft Excel 2013 workbooks is ________. A) .xlx B) .xls C) .xlxs D) .xlsx
D) .xlsx
20) The YEAR function returns the year in the range ________. A) 0-9000 B) 1000-9000 C) 1000-9999 D) 1900-9999
D) 1900-9999
20) Following Excel's order of operations, what is the result of the formula =10-4/2*(5-2)? A) 9 B) 13 C) 8.5 D) 4
D) 4
24) Which of the following is NOT used as a comparison operator? A) = B) <= C) > D) <*>
D) <*>
4) When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6, the formula in cell F6 is ________. A) =G7/H8 B) =$G$7/$H$8 C) =B5/C6 D) =$B$5/$C$6
D) =$B$5/$C$6
16) When cell D4 containing the formula =A4*B5 is copied to cell E2, the formula in cell E2 is________. A) =A4*B5 B) =B4*C5 C) =B2*C3 D) =A2*B3
D) =A2*B3
28) Which of the following is NOT a comparison operator symbol? A) = B) ≠ C) < D) >=
D) >=
26) Which of the following is NOT true about adding pictures to a form? A) When a picture is added to a form, then the same picture will appear for every record in the table. B) A picture can be inserted in the header, footer, or the Detail area of the form where the record values are shown. C) Pictures can be added to forms to make them more appealing. D) A different picture can be added for each record.
D) A different picture can be added for each record.
12) Which of the following is NOT true about database templates? A) You can download a wide variety of templates from Microsoft's website Office.com. B) Templates are professionally designed databases that you can either use as is or adapt to suit your needs. C) Microsoft provides sample database templates used for managing assets, contacts, issues, projects, and tasks. D) A template is a sample database that has presupplied data
D) A template is a sample database that has presupplied data
20) An example of a range of cells is ________. A) A1&A3 B) A1+A3 C) A1-A3 D) A1:A3
D) A1:A3
18) Which of the following is NOT an Access file extension? A) ACCDB B) ACCDE C) ACCDT D) ACCTM
D) ACCTM
27) Which of the following is NOT a financial function? A) PMT B) PPMT C) NPV D) APR
D) APR
14) The ________ Query Wizard is used to display fields from one or more tables or queries with the option to choose a detailed or summary query if working with more than one table. A) Find Duplicates B) Crosstab C) Find Unmatched D) Simple
D) Simple
18) Which of the following is NOT a method used to add fields to a query design grid? A) Drag B) Double-click the title bar C) Click, Shift, Click D) Single-click field name
D) Single-click field name
4) Illustrating some of the basic principles of database design, notice that a person's name is split into two fields and the address is ________. A) left as one field B) split into two fields C) split into three fields D) split into four fields
D) Split into four fields
21) The Conditional Formatting button is located in the: A) Cells group on the FORMAT tab. B) Styles group on the FORMAT tab. C) Cells group on the HOME tab. D) Styles group on the HOME tab.
D) Styles group on the HOME tab.
20) Which of the following is NOT true about multiple-table forms? A) The main form will display the first table one record at a time just like a single-table form. B) Access will automatically use the common field between the tables to create the form. C) Before you can use two tables in a form, you must make sure there is a one-to-many relationship between the tables. D) The subform will display "one" record in the one-to-many relationship.
D) The subform will display "one" record in the one-to-many relationship.
34) Which of the following is NOT true about customizing a report? A) Reports created by the wizard can be easily customized after they have been created and saved. B) Themes can be applied to just the report or the whole database to change the colors, fonts, or both. C) Controls, bound and unbound, can be added or modified on the report to make room for more information or to rearrange the information already there. D) To break a report into smaller sections, grand totals or sorts may be added.
D) To break a report into smaller sections, grand totals or sorts may be added.
26) Which of the following is NOT true regarding keys? A) Each table should have a primary key to uniquely identify each of the records in the table. B) A foreign key is a value in a table that is the primary key of another table. C) The primary and foreign keys form the common field between tables that allow you to form a relationship between the two tables. D) To define a foreign key, select the foreign key field and then click the Key button on the Ribbon.
D) To define a foreign key, elect the foreign key field and then click the Key button on the Ribbon.
1) Which of the following is NOT true regarding businesses and databases? A) Records are collected and used for decision making, for sales and marketing, and for reporting purposes. B) Businesses keep records about everything they do. C) The purpose of a database is to store, manage, and provide access to the business records. D) Today's businesses use automated databases to store their records and have completely eliminated paper-based systems.
D) Today's businesses use automated databases to store their records and have completely eliminated paper-based systems.
39) Which of the following is NOT a step in creating a one-to-many relationship? A) Make sure the two tables have a field in common. B) Form the relationship in the Relationships window. C) Populate the foreign key by adding data to the foreign key in the many side table. D) Use the foreign key from the one side, and add it as a primary key in the many side table.
D) Use the foreign key from one side, and add it as a primary key in the many side table.
24) Which of the following is NOT true when resizing and managing controls? A) Controls can be resized to make the form more user friendly. B) When you create a form using the wizard, the order that you choose the fields in the wizard step is the order the fields are added to the form. C) Once the control is selected you can move it or resize it. D) When you click a control in Form view, an orange border appears around the control.
D) When you click a control in Form view, an orange border appears around the control.
15) Which of the following is NOT true when entering data manually? A) If the data does not already exist in another form, you can type the data directly into Access. B) Data can be directly entered into a table. C) Data can be entered in a form. D) When you open a table in Design view, you can type data directly into the table.
D) When you open a table in Design View, you can type data directly into a table.
35) Which of the following is NOT true regarding a backup database? A) The backup copy is as current as your real database, and saves you from having to recreate your database. B) A backup database is an extra copy of your database that you can use to protect yourself from the accidental loss of your database. C) Backups can help in cases of accidental deletion of data. D) You can return to the backup copy if you accidentally delete the real database.
D) You can return to the backup copy if you accidentally delete the real database.
9) Text filters allow you to create a custom filter to match ________ the text in a field that you specify. A) everything except B) part of C) all of D) all or part of
D) all or part of
24) To select noncontiguous rows, you: A) click the header of the first row, then double-click the header of each additional row. B) click the header of the first row, then right-click the header of each additional row. C) click the header of the first row, press and hold Shift, and click the header of each additional row. D) click the header of the first row, press and hold Ctrl, and click the header of each additional row.
D) click the header of the first row, press and hold Ctrl, and click the header of each additional row.
4) You are reading a report that shows Company A generated $2,000 last week. This would be ________. A) knowledge B) a competitive advantage C) data D) information
D) information
29) A ________ provides an easy-to-read format suitable for printing. A) wizard B) macro C) form D) report
D) report
23) To hide a row of information, you place the mouse pointer over the row heading: A) click once, and in the Arrange group, click Hide Row. B) click once, and in the View group, click Hide Row. C) double-click and click Hide from the shortcut menu. D) right-click and click Hide from the shortcut menu.
D) right-click and click Hide from the shortcut menu.
11) A ________ is a form created from one table, but it has a Form view and a Datasheet view in the same window. A) joined form B) main form C) subform D) split form
D) split form
17) The first argument in the SUBTOTAL function identifies the ________. A) number of decimal places in the result B) cell range C) number of significant digits in the result D) statistic to be calculated
D) statistic to be calculated
26) A(n) ________ is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do. A) AutoReport B) form C) AutoForm D) wizard
D) wizard
23) The result of =FIND("is", "Mississippi",3) is ________. A) 2 B) 4 C) 5 D) 6
C) 5
18) Which of the following is NOT a cell range? A) A single cell B) Noncontiguous cells C) A table D) Contiguous cells
C) A table
33) The file extension PDF stands for ________. A) Portable Data File B) Portable Data Format C) Portable Document File D) Portable Document Format
D) Portable Document Format
15) The ________ Bar Open/Close button at the top of the pane opens and closes the pane. A) Navigation B) Property C) Forms D) Shutter
D) Shutter
16) Which of the following is NOT true regarding the Find Unmatched query? A) The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query. B) The wizard uses the primary key from the first table and matches it with the foreign key in the second table in order to determine if there are unmatched records. C) If a one-to-many relationship exists between the two tables, then the wizard will join the two correct fields automatically. D) The wizard will try to match the primary key field and the foreign key field if there is a one-to-many relationship between the two tables.
A) The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query.
27) Which of the following is NOT true regarding primary keys? A) The primary key field is the field that identifies each record in a table. B) When you define a primary key for a table, the field can be left blank until you have the opportunity to enter the data. C) A common way of defining a primary key is to use a field specifically designed to identify the entity. D) A numeric key is often assigned an AutoNumber data type that Access will fill as the data is entered.
A) The primary key field is the field that identifies each record in a table.
7) Which of the following is NOT true about tables? A) The upper pane of Design view has four columns: Field Name, Data Type, Length, and Description. B) Datasheet view shows the values of the data within the table. C) Design view shows the structure of the table with the fields and their definitions. D) The Field Properties pane in Design view gives more information on how the data is stored, entered, and processed.
A) The upper pane of Design View has four columns: Field Name, Data Type, Length, and Description.
12) Which of the following is NOT true when copying and pasting data from Excel into Access? A) There cannot be missing columns or columns in different orders between the two files. B) Copying and pasting requires that the columns be exactly the same in Excel and Access. C) If you have any doubt about the data being compatible, use the Append feature to add the data to the table. D) You cannot paste fields that are nonnumeric into numeric fields.
A) There cannot be missing columns or columns in different orders between lines.
10) To change a table back into a range, you click Convert to Range in the: A) Tools group on the DESIGN tab. B) Styles group on the DESIGN tab. C) Tools group on the VIEW tab. D) Styles group on the VIEW tab.
A) Tools group on the DESIGN tab.
38) There are ________ options for compacting a database. A) two B) three C) four D) five
A) Two
8) Which of the following is an alternative to using a space in a named range? A) Use a hyphen B) Use an equal sign C) Use an underscore D) Capitalize the first letter of each word
A) Use a hyphen
5) Which of the following is NOT true when creating fields and entering data in those fields? A) When you have fields such as name or address that are composed of several smaller fields, you should split them into their component parts. B) Consider whether you might want to report on smaller parts of the field to determine what fields to create. C) Enter first and last names in alphabetical order in case two people have the same last name. D) Splitting fields into smaller parts allows for more flexibility for reporting.
A) When you have fields such as a name or address that are composed of several smaller fields, you should split them into their component parts.
33) Which of the following is NOT true regarding normalization? A) When you normalize a database, you will have larger tables, each representing a different thing. B) If you know the primary key of an entity in a normalized database, each of the attributes will have just one value. C) There will be no redundant data in the tables. D) Normalization is the process of minimizing duplicate data.
A) When you normalize a database, you will have larger tables, each representing a different thing.
33) Which of the following is NOT true about creating totals on reports? A) When you report on textual data, you have the option to ask Access to calculate sums, averages, minimums, and maximums of the data. B) The grand total calculates the total for all records. C) Subtotals calculate totals for smaller groups of records. D) Grand totals and subtotals can be added to a report after it has been created.
A) When you report on textual data, you have the option to ask Access to calculate sums, averages, minimums, and maximums of the data.
18) Which of the following is NOT true when determining the field size? A) Whenever you use a Text data type, you should determine the minimum number of text characters that can exist in the field. B) Limiting the field size will limit errors in the data. C) If you need more than 255 characters, use a Long Text data type. D) You should use the number size that best suits your needs.
A) Whenever you use a Text data type, you should determine the minimum number of text characters that can exist in the field.
3) Which of the following is NOT an advantage that automated databases have over paper databases? A) Without paper databases, a business cannot compete. B) The information in databases is much easier to find in automated form. C) The information in automated databases can be manipulated and processed more rapidly. D) Automated databases can be used to enforce accuracy and other quality standards.
A) Without paper databases, a business cannot compete.
19) Which of the following is NOT true when changing the data type in an existing field? A) You can change the size of a field in Datasheet view and Design view. B) If you decide that a field length needs to be longer, you can change the field without concern. C) If you make a field length shorter and there were data that needed the longer length, you may truncate those values. D) Access will always warn you that data may be lost if you change the length to a smaller size.
A) You can change the size of a field in Datasheet view and Design view.
22) Which of the following is NOT true about sorting query results on multiple fields? A) You can have one field sorted in ascending order and another in descending order. B) The first field you choose to sort by is called the primary sort field. C) The second and subsequent fields are called secondary sort fields. D) In datasheet view, you can sort multiple fields by selecting all the fields at one time and using the Sort & Filter group sorts.
A) You can have one field sorted in ascending order and another in descending order.
12) Which of the following is NOT true regarding split forms? A) You can highlight a different record in the form part and the datasheet part at the same time. B) You can view one record at a time at the top of the window, and see the whole table in Datasheet view at the bottom of the window. C) This kind of form is helpful when you want to work with one record at a time and still see the big picture in the main table. D) In a split form, there are buttons on the Navigation bar to move only from record to record, and each record shown at the top is the record highlighted in the datasheet at the same time.
A) You can highlight a different record in the form part and the datasheet part at the same time.
6) Access is a(n) ________ DBMS. A) automated B) linked C) relational D) form-based
A) automated
2) The intersection of a row and column is called a ________. A) cell B) container C) chamber D) cubicle
A) cell
2) An absolute cell reference is denoted by a(n) ________. A) dollar sign ($) B) asterisk (*) C) number sign (#) D) at sign (@)
A) dollar sign ($)
30) You can rename a worksheet by ________ its tab and then typing the new name. A) double-clicking B) right-clicking C) pressing Ctrl and clicking D) clicking
A) double-clicking
12) COUNT, AVERAGE, MIN, and MAX are examples of Excel ________. A) formulas B) functions C) arguments D) expressions
A) formulas
18) A ________ control may be the name of the field or some other text you manually enter. A) label B) bound C) calculated D) text box
A) label
25) When resizing and managing controls, the ________ allows you to move the whole table at one time. A) layout selector B) subform control C) control selector D) Form Wizard
A) layout selector
7) A named range CANNOT begin with a(n) ________. A) number B) letter C) underscore (_) D) backslash (\)
A) number
17) To help you find ________, Access provides a Search box. A) objects B) Object Type C) data D) file extensions
A) objects
36) A ________ relationship is a relationship between two tables where one record in the first table corresponds to many records in the second table. A) one-to-many B) one-to-one C) many-to-many D) This doesn't apply to any relationship type.
A) one-to-many
25) In Excel, the height of the rows is measured in ________. A) points B) picas C) pixels D) ppm
A) points
24) While Access allows you to leave several tables open at the same time, it is a good idea to get into the habit of ________ a table when you are finished with it. A) saving B) closing C) exporting D) renaming
A) saving
6) To search for a three-letter word that starts with "t" and ends with "p" you would enter ________. A) t?p B) t#p C) t*p D) t!p
A) t?p
11) A ________ is a structure of a database with tables, fields, forms, queries, and reports. A) template B) view C) pattern D) sample
A) template
27) The ________ row of the query design grid is the Field name. A) top B) second C) third D) bottom
A) top
28) Which of the following is NOT a chart background fill option? A) transition B) color C) pattern D) picture
A) transition
16) A(n) ________ control is a control that does not have a source of data such as the title of the form. A) unbound B) bound C) calculated D) text box
A) unbound
8) When navigating a main form, pressing ________ will move the cursor to the last field of the current record. A) $$$Home$$$ B) $$$End$$$ C) $$$Tab$$$ D) $$$Ctrl$$$ + $$$Enter$$$
B) $$$End$$$
1) There are how many different cell references? A) 2 B) 3 C) 4 D) 5
B) 3
5) To search for a three-digit number that starts with "75" you would enter ________. A) 75? B) 75# C) 75* D) 75!
B) 75#
2) Which of the following is NOT true regarding database design? A) An entity is a person, place, item, or event that you want to keep data about. B) A field is an instance of an entity. C) An attribute is information about the entity. D) A relationship is an association between tables based on common fields.
B) A field is information about the entity.
11) Data stored as a(n) ________ file cannot be imported into a table in Access. A) Excel B) Adobe PDF C) Access D) Notepad
B) Adobe PDF
14) ________ is the SUM keyboard shortcut. A) Ctrl + = B) Alt + = C) Ctrl + + D) Alt + +
B) Alt + =
17) If you wanted to determine how many cells in a range are not empty, you would use the ________ function. A) COUNT B) COUNTA C) NOTEMPTY D) HASVALUE
B) COUNTA
17) Which of the following is NOT true about creating queries in Design view? A) In the query window, you can include specific fields, define criteria, sort records, and perform calculations. B) The query window in Design view allows you to specify the data you want to see by building a query by wizard. C) When you use the query window, you have more control and more options available to manage the details of the query design than with the Simple Query Wizard. D) When you open Design view, by default, the Show Table dialog box opens with a list of available tables and queries to add.
B) The query window in Design View allows you to specify the data you want to see by building a query by wizard.
22) ________ is an example of the Long Date format. A) 11/9/2015 10:10:10 PM B) Wednesday, November 9, 2015 C) 9-Nov-15 10:10:10 PM D) Wednesday, November 9, 2015 10:10 PM
B) Wednesday, November 9, 2015
13) Which of the following is NOT true about editing, adding, and deleting records? A) Records can be deleted from a single table without additional steps if the table is not part of a relationship. B) When you add a record to a form, you are actually adding the record to the table it will be stored in. C) Changes to data are saved automatically. D) If the table is part of a relationship, referential integrity has been enforced, and the cascade delete option has been chosen, a record cannot be deleted if there are related records in another table until those records have also been deleted.
B) When you add a record to a form, you are actually adding the record to the table it will be stored automatically.
34) Which of the following is NOT true regarding redundancy? A) Redundancy occurs when data is repeated several times in a database. B) When you normalize a database, you eliminate redundancy. C) Foreign keys are redundant, but no other data about the entity is repeated. D) Normalization is the process of minimizing duplicate data.
B) When you normalize a database, you eliminate redundancy.
2) A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value. A) Replace command B) wildcard character C) Find command D) Find & Replace command
B) Wildcard Character
36) Which of the following is NOT true about enhancing a report with grouping and sorting? A) The Report Wizard gives you the opportunity to sort and group records, but sometimes seeing the report changes your mind about what and how to group and sort. B) You can change the sorting and grouping options from either Layout or Report view. C) Groups are added to a section of the report called the group header. D) Calculations performed on a group in a report are added to a section called the group footer.
B) You ca change the sorting and grouping options from either Layout or Report view.
7) Which of the following is NOT true about applying filters to a datasheet? A) A filter is a condition you apply permanently to a table or query. B) You can choose to save a table with the filter applied so when you open the table later the filter is still available. C) A filter is a simple technique to quickly reduce a large amount of data to a much smaller subset of data. D) All records that do not match the filter criteria are hidden until the filter is removed or the table is closed and reopened.
B) You can choose to save a table with the filter applied so when you open the table later the filter is still available.
13) The inputs used by an Excel function are called ________. A) parameters B) arguments C) dependent variables D) independent variables
B) arguments
15) A(n) ________ control is a control whose data source is a field in the table such as the customer name. A) unbound B) bound C) calculated D) text box
B) bound
22) To remove conditional formatting from a range of cells, after selecting the range of cells: A) click Conditional Formatting, point to Clear Rules, and select Clear Rules from Selected Cells. B) click Conditional Formatting and click Delete Rules. C) press Backspace. D) press Delete.
B) click Conditional Formatting and click Delete Rules.
7) A DBMS is a ________. A) database Microsoft system B) database management system C) data manipulation system D) database management service
B) database management system
28) A ________ provides another interface beyond the table in Datasheet view. A) wizard B) macro C) form D) report
B) macro
38) A ________ relationship is a relationship between tables where a record in one table has only one matching record in the second table. A) one-to-many B) one-to-one C) many-to-many D) This doesn't apply to any relationship type.
B) one-to-one
12) Function arguments are enclosed in a pair of ________. A) braces { } B) parentheses ( ) C) brackets [ ] D) quotes " "
B) parentheses ( )
25) A ________ is used to ask questions about your data. A) table B) query C) form D) report
B) query
9) Which of the following is NOT a main object in an Access database? A) table B) script C) query D) report
B) script
1) A ________ application is a computer program has a user interface comprised of a grid of rows and columns. A) database B) spreadsheet C) matrix D) tabular
B) spreadsheet
19) There are ________ major kinds of form controls. A) two B) three C) four D) five
B) three
9) When editing a main form, pressing ________ will move the cursor to the last character in the field. A) $$$Home$$$ B) $$$Ctrl$$$ + $$$End$$$ C) $$$Enter$$$ D) $$$End$$$
B)$$$Ctrl$$$ + $$$End$$$
31) What is the error message when you attempt to use a cell that has been deleted as a function argument? A) #NPV? B) #NAME? C) #REF! D) #N/A
C) #REF!
6) When navigating a main form, pressing ________ will move the cursor from field to field within a record. A) $$$Home$$$ B) $$$End$$$ C) $$$Tab$$$ D) $$$Ctrl$$$ + $$$Enter$$$
C) $$$Tab$$$
22) The result of =CONCATENATE("12", "34") is ________. A) 45 B) 22 C) 1234 D) #NUM!
C) 1234
35) Which of the following is NOT true about enhancing a report with conditional formatting? A) You can change the fonts and colors of fields only when certain conditions are met in the field. B) If a field value meets the conditions you specify, then the formatting will be applied. C) Conditional formatting is a useful tool to automatically highlight sales numbers on a report if they meet a certain threshold, or to highlight students' grades when they exceed a certain limit. D) Access determines the font color and font effects for the formatting.
D) Access determines the font color and font effects for the formatting.
9) To move right one screen, you would use the keyboard shortcut ________. A) Page Down B) Shift + Page Down C) Ctrl + Page Down D) Alt + Page Down
D) Alt + Page Down
6) Which of the following is NOT true when dealing with international data? A) Not all cultures around the world break names into first and last. B) Design the database in such a way that other naming practices can fit into the database. C) Designing database fields to accommodate all of the different cultures in the world is challenging. D) Because businesses today are global, designing a database sensitive to all global cultures is imperative.
D) Because businesses today are global, designing a database sensitive to all global cultures is imperative.
23) Which of the following is NOT true when changing a form theme? A) Once a theme is applied to the form, the colors and fonts can be changed independently of the theme, so you can combine the colors of one theme and a font of another. B) Changing the theme will not only change the colors of the form but also the font type and size and any border colors or object colors added to the form. C) Because the form is displayed in Form view, once it is created, the first step is to switch to Layout view to make changes to the form itself. D) By default, Access uses the Office theme when you create a form using AutoForm.
D) By default, Access uses the Office theme when you create a form using AutoForm.
37) ________ rearranges objects to use disk space more efficiently, thus releasing the now unused space to be used again. A) Backups B) Reports C) Queries D) Compacting
D) Compacting
23) ________ compare the values in a table or another query to the criteria value you set up in a query. A) Is Null criteria B) Search criteria C) Query operators D) Comparison operators
D) Comparison operators
33) ________ shows the report design but not the data. A) Report view B) Print Preview C) Layout view D) Design view
D) Design View
31) ________ allows you to change more details of the report design or add other controls that are only available in this view. A) Print Preview B) Layout view C) Report view D) Design view
D) Design view
1) Which of the following is NOT one of the three steps in database design? A) Identify your entities. B) Identify the attributes. C) Specify the relationships between the tables. D) Determine the queries you want to create.
D) Determine the queries you want to create.
3) How many options are there for aligning the contents within a cell? A) Two B) Four C) Six D) Eight
D) Eight
13) Which of the following should NOT be done if Access give you a security warning about your database? A) Run a virus scan on any file before you say it should be trusted. B) If you know the database is safe, you can trust a database permanently by storing it in a trusted location. C) Do not click Enable Content in the security warning if you are not sure if the database is safe. D) Enable the content. Nothing bad will happen, even if there is a virus embedded in the file.
D) Enable the content. Nothing bad will happen, even if there is a virus embedded in the file.
29) Given the following information: What is the result of =IF( B4>65, "Passing", "Failing")? A) TRUE B) FALSE C) Passing D) Failing
D) Failing
9) ________ give more information on how the data is stored, entered, and processed. A) Field names B) Description C) Data types D) Field properties
D) Field Properties
14) Which of the following is NOT true about form views? A) Data is not shown while you are in Design view. B) Layout view allows you to make changes to the form while viewing the data at the same time. C) To make any changes to the form you need to switch to either Layout view or Datasheet view. D) Form view is only for viewing and changing data.
D) Form view is only for viewing and changing data.
27) To AutoFit the width of a column, you click Format and then click AutoFit Column Width in the: A) Cells group on the VIEW tab. B) Format group on the VIEW tab. C) Cells group on the HOME tab. D) Format group on the HOME tab.
D) Format group on the HOME tab.
25) The Show Formulas button in located in the: A) Show group on the VIEW tab. B) Formula Auditing group on the VIEW tab. C) Show group on the FORMULAS tab. D) Formula Auditing group on the FORMULAS tab.
D) Formula Auditing group on the FORMULAS tab.
20) Which of the following is NOT true regarding input masks? A) An input mask provides the punctuation so you do not have to type it. B) An input mask defines a consistent template. C) Access has a wizard that creates automatic masks for Social Security numbers, zip codes, passwords, extensions, dates, and times. D) Input masks do not affect how data is stored.
D) Input marks do not affect how data is stored.
1) The ________ allows you to move to the top and bottom of a table or scroll to a specific record. A) Forward and Backward arrows B) Navigation Pane C) Arrows bar D) Navigation bar
D) Navigation Bar
1) ________ allows you to move from record to record and field to field using keystrokes. A) Edit mode B) Design view C) Layout view D) Navigation mode
D) Navigation Mode
3) When the text of a field is selected and highlighted, you are in ________. A) Edit mode B) Design view C) Datasheet mode D) Navigation mode
D) Navigation Mode
32) ________ is the process of minimizing the duplication of information in a relational database through effective database design. A) Formatting B) Defining keys C) Establishing relationships D) Normalization
D) Normalization
15) A(n) ________ is a foreign key in one table that does not have a matching value in the primary key field of a related table. A) duplicate key B) wildcard C) composite key D) orphan
D) Orphan
