front 1 To view or modify every part of a table's structure you would go to
what view? | back 1 Design |
front 2 What two tabs are unique to Access? | back 2 External Data and Database Tools |
front 3 Which of the following is not one of the three methods for creating a
database? | back 3 Create a blank cloud database |
front 4 Backstage view gives you access to which command? | back 4 Save As |
front 5 What is SharePoint? | back 5 A host server |
front 6 When does Access save a record? | back 6 When you move to a different record |
front 7 What two tabs are unique to Access? | back 7 External Data and Database Tools |
front 8 A customer's cell phone would be an example of a ________. | back 8 field |
front 9 What are the two ways you can view a table? | back 9 Design and Datasheet views |
front 10 When you click the Enable Content warning, the database is now
________. | back 10 trusted on this computer |
front 11 Which method of creating a database demands the least amount of
expertise in Access? | back 11 Using a template |
front 12 Most users enter information into a database through the use of a
________. | back 12 form |
front 13 Which of the following is not a valid comparison operator? | back 13 => |
front 14 When you close a table after using a selection filter and then reopen
it, what happens to the filter? | back 14 The filter is removed, but Toggle Filter will bring it back. |
front 15 If you want fewer records to display, you should use which operator
in your filter? | back 15 AND |
front 16 What produces a subset of your data? | back 16 Query |
front 17 In order to program a custom application module, you have the option
to build with code using which programming language? (This is not to
be confused with the language used for coding queries) | back 17 VBA (Visual Basic for Applications) |
front 18 If you sorted a table which had 53 records by two fields, one
ascending and the other descending, how many records would
display? | back 18 53 |
front 19 Which of the following is not a valid criteria in a
filter? | back 19 =>14 |
front 20 In datasheet view, what do the rows
indicate? | back 20 Records |
front 21 What is the most important thing you need if you are going to create
a Web app? | back 21 A host server |
front 22 The ACCDE format allows users to ________. | back 22 enter data, but not add, modify, or delete objects |
front 23 How would you sort or filter records in a field that begins with both
numbers and letters so that the records which begin with numbers
appear before the records that begin with letters? | back 23 Sort ascending |
front 24 In Datasheet view, what does a pencil symbol to the left of a record
indicate? | back 24 Data in that record has not been saved yet. |
front 25 What interface element shows you the various objects in your
database? | back 25 The Navigation pane |
front 26 Which of the following is not one of the three methods for creating a
database? | back 26 Create a blank cloud database |
front 27 What database object organizes your data by rows and columns? | back 27 Table |
front 28 Which of the following is not a property of a number data
type? | back 28 Allow zero length |
front 29 What does opening a database in exclusive mode assure? | back 29 That you are the only person with that database open |
front 30 To move a field you ________. | back 30 left-click the column heading, then drag the field to where you want it |
front 31 How many records do most forms display? | back 31 1 |
front 32 You only need to save an object when ________. | back 32 you make changes to its structure |
front 33 What type of filter displays records based on a criterion you
choose? | back 33 Selection filter |
front 34 To create a database from a template you would use which
view? | back 34 Backstage |
front 35 To assign a field size of 12 to a field you would ________. | back 35 enter 12 in the Field Size property of that field |
front 36 When you split a database (separating the stored data into what's
called the 'backend', from the user interface in the 'frontend'), what
object type is put in the back end? | back 36 Tables |
front 37 The ACCDE format allows users to ________. | back 37 enter data, but not add, modify, or delete objects |
front 38 What can you not import from one Access database into another Access
database? | back 38 Sheets |
front 39 Which field property helps a user know why an entry error was
generated? | back 39 Validation Text |
front 40 What is not one of the six guidelines for creating fields? | back 40 Store data in as large of number of parts as possible |
front 41 When does the validation rule check the entered data? | back 41 When the user exits the field |
front 42 Enforcing referential integrity assures that ________. | back 42 you cannot enter a value in the foreign key if there is no corresponding value in the primary key |
front 43 How many characters can be stored in a field with a Long Text data
type? | back 43 64,000 |
front 44 What field property would you use to automatically enter
"PA" in a state field? | back 44 Default Value |
front 45 What field property would you use to ensure all PhoneNumber values
are stored with consistent appearance? | back 45 Input Mask |
front 46 If you wanted to add January 16, 1957 as text criteria, how would you enter it? *remember that a date criteria makes use of # as the surrounding character(bookends) for the criteria value, while plain text gets surrounded with (using bookends of) quotation marks "January 16, 1957" | back 46 "January 16, 1957" |
front 47 What is not true about field names? | back 47 They can begin with a space. |
front 48 When you run a query, it displays in what view? | back 48 Datasheet |
front 49 When you purchase from a store several times this would be an example
of what kind of table relationship? | back 49 One-to-many (one customer - many purchases) |
front 50 What field property would allow the user to enter "" into a
field with a Short Text data type? | back 50 Allow Zero Length |
front 51 When you import data, where can you not store it? | back 51 New form |
front 52 Which of the following is not a way to create a multitable
query? | back 52 Just adding tables in the Relationship window |
front 53 If you add a table with 10 records to a query and add an unrelated
table with 4 records to the same query, since this performs a positive
match for each of the 10 records multiplied by the number of records
in the unrelated table, how many records will display when you run the
query? | back 53 40 |
front 54 The query wizard is best used to create what kind of
query? | back 54 Simple queries |
front 55 What is the suggested data type for a street address? | back 55 Short Text |
front 56 Which option would this wildcard, "H[!oe]" not
display? | back 56 House |
front 57 What is not critical when you are first designing a database? | back 57 What the field names will be |
front 58 What is not true about the hyperlink data type? | back 58 It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work |
front 59 What view offers the most flexibility in setting the properties of a
field? | back 59 Design View |
front 60 How many characters can be stored in a field with a Short Text data
type? | back 60 255 |
front 61 What field property increases the speed at which searches can be
performed? | back 61 Indexed |
front 62 If you wanted the user to pick from a particular list generated by
looking into your existing data, what would you pick from the data
type drop down list for that field? | back 62 Lookup Wizard |
front 63 Which logical operator would return the fewest records? | back 63 AND |
front 64 Which of the following comparison operators is not valid? | back 64 => |
front 65 Which of the following would make a consistently reliable primary
key? | back 65 AutoNumber data type |
front 66 "lastName" is an example of ________. camelCase (camel case) | back 66 camelCase (camel case) |
front 67 What field property forces data to follow certain rules of data
entry? | back 67 Validation Rule (the logical test) |
front 68 The first step to resizing a column in datasheet view is to move the
pointer until it looks like a ________. | back 68 two-headed arrow and then click |
front 69 Checking the Cascade Delete Related Records checkbox assures that
________. | back 69 all records will be deleted in related tables if you delete the primary key in the primary table |
front 70 What field property makes up for the limitation of the field naming
rules or common practices? | back 70 Caption |
front 71 What table property always necessitates an entry? (hint: different than allowing zero length) AutoNumber | back 71 AutoNumber |
front 72 To limit the number of records displayed when a query is run you add
________. | back 72 criteria |
front 73 Which wildcard character matches a single character in the same
position as the wildcard? | back 73 ? |
front 74 What can the phrase "Please Excuse My Dear Aunt Sally" help
you remember? | back 74 Order of operations |
front 75 What error will you get if there is something wrong with the formula
in a calculated field? | back 75 Invalid syntax |
front 76 What punctuation do you use to separate the arguments in a
function? | back 76 , |
front 77 According to the order of operations, what is not calculated after
exponentiation? | back 77 Parenthesis |
front 78 Which element will you never find in a calculated field? | back 78 Macro |
front 79 When you want to add a condition to a Totals query, which option do
you select from the Totals row list? | back 79 Where |
front 80 What type of query will allow you to see statistics by
category? | back 80 Totals query |
front 81 What result would be generated by the formula =10*2-3*2? | back 81 14 |
front 82 For a 15-year loan paid monthly, which of the following would not be
correct for the num_periods argument in the Pmt function? | back 82 15 |
front 83 Where does the Total row of an aggregate function display its
results? | back 83 Last row in Datasheet view |
front 84 As what does Access refer to aggregate functions? | back 84 Totals |
front 85 When you run a query, what is the default view? | back 85 Datasheet |
front 86 Which of these is an advantage of using the Expression Builder(rather
than zoom, or the criteria field for entry of query criteria)? | back 86 It will guarantee that you do not mis-type field names. |
front 87 Which of the following is not an argument used in the Pmt
function? | back 87 Total_due |
front 88 What are predefined computations that perform complex
calculations? | back 88 predefined Functions |
front 89 Which of the following is not an arithmetic operator? (hint: another
type of operator is a comparison operator) | back 89 > |
front 90 What symbol does Access use to express exponentiation? | back 90 ^ |
front 91 What symbols does Access use to indicate a field name? | back 91 [] |
front 92 What value will Access calculate from the following formula:
=1+(2-3)+5/6-6^2? | back 92 -35.2 |
front 93 What is not an example of a function? | back 93 =15*21 |
front 94 What can help you build more complex expressions in calculated
fields? | back 94 Expression Builder |
front 95 What button do you click to see the results of a query? | back 95 Run |
front 96 What is a type of field that displays the result of an expression
rather than the data stored in a field? | back 96 Calculated |
front 97 In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate
first? | back 97 (2-3) |
front 98 In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate
second? | back 98 6^2 |
front 99 When you are prompted to enter a value when you run a query which
includes a calculated field, you probably ________. | back 99 typed a field name incorrectly |
front 100 What allows you to summarize data by the values of a
field? | back 100 Adding grouping to a query |
front 101 What is not a necessary piece of data needed for the Pmt
function? | back 101 Amount already paid on the loan |
front 102 When creating a calculated field in a query, what common error will
not give you a direct indication that there is a problem? | back 102 Forgetting the order of operations |
front 103 What is a popular label producing company? | back 103 Avery |
front 104 What is not an option in the Layout Options for Grouped Data in the
Report Wizard? | back 104 Multi-level |
front 105 Which of the following cannot be included on a form? | back 105 Subliminal report |
front 106 Each of the following are compelling reasons for data entry by using
a form, except one which is not true: | back 106 Data you enter in a form must then be transferred to the table. |
front 107 Which of the following is not a report view? | back 107 SQL view |
front 108 Which of the following is not a primary consideration when designing
a report? | back 108 How many pages of results the report generates |
front 109 What is the portability advantage of saving a report as a PDF
file? | back 109 More people can open the file, for example users of a device, or other operating system |
front 110 How many other forms does the More Forms list (found under the Create
Tab) provide? | back 110 4 |
front 111 What is not a group on the Report Layout Tools Format tab? | back 111 Fields |
front 112 What can you not easily do using a form? | back 112 Move data |
front 113 What type of form control is normally used to display data? | back 113 Text box |
front 114 Which of the following is not a form view? | back 114 SQL view |
front 115 Pressing the Ctrl key plus what other key enables you to select all
the controls on a form? | back 115 A |
front 116 What is not a valid reason to edit a form's layout? | back 116 Extra fields need to be added (just in case they will be needed later). |
front 117 What is not found on the Data Group on Print Preview tab? | back 117 Portrait |
front 118 What is not true about a report? | back 118 It is capable of displaying only one record at a time. |
front 119 Normally when you Print Preview a report it will generate a report
with how many pages? | back 119 All the pages are shown in print preview |
front 120 Which form tools creates a box asking for user input? | back 120 Modal Dialog |
front 121 What does PDF in Adobe's portable document format stand for? | back 121 Portable Document Format |
front 122 Which tab is not available for modifying a report, when working in
Design View? | back 122 Grouped |
front 123 Which of the following is not true of a form? | back 123 It can ONLY display ONE record at a time. |
front 124 Which of the following is not recommended as a professional way of
styling a form? | back 124 Use several fonts to indicate different types of data |
front 125 What is not a common format for a number control? | back 125 Accounted format |
front 126 When running a report, which sort order takes precedence? | back 126 Report |
front 127 What can you not do with an Access report? | back 127 Edit data |
front 128 When modifying a report, on which tab would you find the commands for
changing what fields appear on the report? | back 128 Design |
front 129 When modifying a report, on which tab would you find the commands for
changing the margins of the report? | back 129 Arrange |
front 130 Which view of a form is used for data entry? | back 130 Form view |
front 131 What is not found on the Report Layout Tools Arrange tab? | back 131 Insert Existing Field |
front 132 Which form view enables you to make changes to how the form looks at
the same time that you are looking at actual data? | back 132 Layout view |
front 133 Which form (which will include the existing fields from the data
source) can be created with just one click? | back 133 Stacked layout |
front 134 What does PDF in Adobe's portable document format stand for? | back 134 Portable Document Format |
front 135 Which form view enables you to make changes to how the form looks at
the same time that you are looking at actual data? | back 135 Layout view |
front 136 Which of the following is not true of a form? | back 136 It can ONLY display ONE record at a time. |