1 To view or modify every part of a table's structure you would go to what view? Datasheet Layout Design Form 2 What two tabs are unique to Access? Mailings and Database Tools Developer and Data External Data and Database Tools External Data and Mailings External Data and Database Tools 3 Which of the following is not one of the three methods for creating a database? Create a blank cloud database Create a blank desktop database Create a database from a template Create a custom web app Create a blank cloud database 4 Backstage view gives you access to which command? Relationships Form Design Clipboard Save As 5 What is SharePoint?An Access alternativeA host serverAn application that lets others in your office share your computer's database A PowerPoint alternative 6 When does Access save a record? When you press the Save icon When you move to a different field When you close the form or table When you move to a different record When you move to a different record 7 What two tabs are unique to Access? Mailings and Database Tools Developer and Data External Data and Database Tools External Data and Mailings External Data and Database Tools 8 A customer's cell phone would be an example of a ________. primary key field table record 9 What are the two ways you can view a table? Design and Datasheet views Datasheet and Form views Design and Layout views Datasheet and Layout views Design and Datasheet views 10 When you click the Enable Content warning, the database is now ________. trusted for any computer trusted on this computer trusted for this session unlocked 11 Which method of creating a database demands the least amount of expertise in Access? Importing unstructured content from an Excel spreadsheet Creating a custom web app Using a template Creating a blank desktop database 12 Most users enter information into a database through the use of a ________.query formmacro table in datasheet view 13 Which of the following is not a valid comparison operator? = <= <> => 14 When you close a table after using a selection filter and then reopen it, what happens to the filter? The filter is not saved. The filter is removed, but Toggle Filter will bring it back. The filter is still operating. The filter is removed permanently. The filter is removed, but Toggle Filter will bring it back. 15 If you want fewer records to display, you should use which operator in your filter? AND NOR NOT OR 16 What produces a subset of your data? Field Table Macro Query 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)VBA (Visual Basic for Applications)VBL (Visual Basic Language) SQL (Structured Query language) HTML (HyperText Markup Language) VBA (Visual Basic for Applications) 18 If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?53It depends on how many of the fields contain exactly the same information. It depends on how many of the fields are blank. 106 19 Which of the following is not a valid criteria in a filter?<>125="Fred" Is Null =>14 20 In datasheet view, what do the rows indicate?FieldsRecordsInformation Tables 21 What is the most important thing you need if you are going to create a Web app? A host server Access Professional The latest version of your favorite Web browser The latest version of Internet Explorer or Microsoft Edge 22 The ACCDE format allows users to ________. view data, but make no changes to the structure or to enter data run the Access database without Access installed enter data, but not add, modify, or delete objects do anything to the structure and data because it is just a format for compressing data enter data, but not add, modify, or delete objects 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?Sort descending Selection filterSort ascending Filter by form 24 In Datasheet view, what does a pencil symbol to the left of a record indicate? Data in that record has a data integrity violation and needs to be changed. Data in that record is about to be deleted. A record has recently been modified and saved. Data in that record has not been saved yet. Data in that record has not been saved yet. 25 What interface element shows you the various objects in your database?The Home menuThe Navigation pane The Database Tools menu The Database Properties pane 26 Which of the following is not one of the three methods for creating a database? Create a blank cloud database Create a blank desktop database Create a database from a template Create a custom web app Create a blank cloud database 27 What database object organizes your data by rows and columns? Macro Report Table Form 28 Which of the following is not a property of a number data type?Validation RequiredCaption Allow zero length 29 What does opening a database in exclusive mode assure?That you are the only person with that database open There is no such thing as exclusive modeThat a password has been set previously That no changes can be made to the structure of the database That you are the only person with that database open 30 To move a field you ________.right-click the column heading and select Move Column right-click the column heading, then drag the field to where you want itleft-click the column heading, then drag the field to where you want it do nothing. You can't move a field left-click the column heading, then drag the field to where you want it 31 How many records do most forms display? 0 (Forms don't display records) 12 All the records at the same time 32 You only need to save an object when ________. you want to avoid renaming the object you make changes to its structure you add or delete fields you make changes to its data you make changes to its structure 33 What type of filter displays records based on a criterion you choose?Selection filterToggle filter Exact Match filter Filter by Report 34 To create a database from a template you would use which view?BackstageCreate database Design Layout 35 To assign a field size of 12 to a field you would ________.type 12 in the Description area of that fieldenter 12 in the Field Size property of that fieldpick Short Text from the Data Type list pick Long Text from the Data Type list enter 12 in the Field Size property of that field 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?Reports FormsTables Macros and Modules 37 The ACCDE format allows users to ________.view data, but make no changes to the structure or to enter data run the Access database without Access installedenter data, but not add, modify, or delete objects do anything to the structure and data because it is just a format for compressing data enter data, but not add, modify, or delete objects 38 What can you not import from one Access database into another Access database? Sheets Reports Tables Forms 39 Which field property helps a user know why an entry error was generated? Expression Validation Text Error Code Validation Rule 40 What is not one of the six guidelines for creating fields? Determine the primary keys Think of what needs you might have in the future Link the tables on related fields Store data in as large of number of parts as possible Store data in as large of number of parts as possible 41 When does the validation rule check the entered data? When the table of form is closed As soon as it is typed into the field When the table or form is saved When the user exits the field When the user exits the field 42 Enforcing referential integrity assures that ________.you cannot enter a value in the foreign key if there is no corresponding value in the primary key you cannot enter invalid or incorrect information you cannot leave that field empty you cannot enter the same value in the foreign key of the same table you cannot enter a value in the foreign key if there is no corresponding value in the primary key 43 How many characters can be stored in a field with a Long Text data type? 1,000 Unlimited 12,256 64,000 44 What field property would you use to automatically enter "PA" in a state field? Caption Format Default Value Start Value 45 What field property would you use to ensure all PhoneNumber values are stored with consistent appearance? Format Input Mask Default Value Caption 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"=January 16, 1957 #January 16, 1957# January 16, 1957 47 What is not true about field names?They can be up to 64 characters in length. They can begin with a space. They should describe the data they will store. They can contain numbers. They can begin with a space. 48 When you run a query, it displays in what view? Print Preview Layout Datasheet Design 49 When you purchase from a store several times this would be an example of what kind of table relationship? Many-to-many (many items purchased - many times) One-to-one (one customer - one store) One-to-many (one customer - many purchases) Many-to-one (many purchases - one customer) One-to-many (one customer - many purchases) 50 What field property would allow the user to enter "" into a field with a Short Text data type?Allow Zero Length Allow Null Length Indexed Required 51 When you import data, where can you not store it?New form Linked table Existing table New table 52 Which of the following is not a way to create a multitable query?Modifying an existing query Just adding tables in the Relationship window Creating a query from scratch Using the Query Wizard Just adding tables in the Relationship window 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?4 10 40 0 (since the tables are not related) 54 The query wizard is best used to create what kind of query?Simple queries Zero table queries Advanced queries Multifaced queries 55 What is the suggested data type for a street address?Short Text OLE Object Long Text Number 56 Which option would this wildcard, "H[!oe]" not display? His Humming House Hat 57 What is not critical when you are first designing a database? What tables you will need What the field names will be What fields you will need What type of data will be stored in each field What the field names will be 58 What is not true about the hyperlink data type? It can store the path to a file It can store the URL for a web page It can store the path to a folder It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work 59 What view offers the most flexibility in setting the properties of a field? SQL view Design View Datasheet view Page Layout view 60 How many characters can be stored in a field with a Short Text data type? 1256 100 500 255 61 What field property increases the speed at which searches can be performed? Result Type Indexed Required Allow Zero Length 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?Short Text Long Text Lookup Wizard List 63 Which logical operator would return the fewest records? NOR AND NOT OR 64 Which of the following comparison operators is not valid? <> <=> >= 65 Which of the following would make a consistently reliable primary key? Number data type Customer number AutoNumber data type Birthday 66 "lastName" is an example of ________. camelCase (camel case) a naming convention that is not recommended because of possible compatibility issuesa typing error PascalCase (pascal case) 67 What field property forces data to follow certain rules of data entry? Format Validation Text (the error message) Required Validation Rule (the logical test) Validation Rule (the logical test) 68 The first step to resizing a column in datasheet view is to move the pointer until it looks like a ________. four-headed arrow and then click thick black line and then click two-headed arrow and then click thick green line and then click two-headed arrow and then click 69 Checking the Cascade Delete Related Records checkbox assures that ________. you cannot delete a primary key record if it has related records you cannot delete related records if they have more than one foreign key recordsall records will be deleted in related tables if you delete the primary key in the primary table all primary keys will be deleted if you delete related records all records will be deleted in related tables if you delete the primary key in the primary table 70 What field property makes up for the limitation of the field naming rules or common practices?Caption Validation Rule Input Mask Format 71 What table property always necessitates an entry? (hint: different than allowing zero length) AutoNumber Date/Time Number Requirements 72 To limit the number of records displayed when a query is run you add ________.less fields sorting criteria less tables 73 Which wildcard character matches a single character in the same position as the wildcard? [] ? * [!] 74 What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?Order of operations Naming convention for cell ranges The various printing options available in Excel How to do date calculations 75 What error will you get if there is something wrong with the formula in a calculated field? #NAME! non-valid expression Invalid syntax #FORMULA! 76 What punctuation do you use to separate the arguments in a function? . , : ; 77 According to the order of operations, what is not calculated after exponentiation? Division Multiplication Parenthesis Addition 78 Which element will you never find in a calculated field? Function Macro Constant Arithmetic operator 79 When you want to add a condition to a Totals query, which option do you select from the Totals row list?Condition Group Where When 80 What type of query will allow you to see statistics by category? Update query Delete query Totals query Statisticized query 81 What result would be generated by the formula =10*2-3*2? -2 14 34 -20 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?180 15 12*15 15*12 83 Where does the Total row of an aggregate function display its results?First row in Datasheet view Only row in Datasheet view Last row in Datasheet view It does not display in Datasheet view. Last row in Datasheet view 84 As what does Access refer to aggregate functions?Totals Sums Whole Column functions Complex functions 85 When you run a query, what is the default view? Design Datasheet Form Layout 86 Which of these is an advantage of using the Expression Builder(rather than zoom, or the criteria field for entry of query criteria)?It will guarantee that you do not mis-type field names.Queries built this way run faster Zoom limits the statements to simple comparison There is no advantage to using Builder, zoom is superior in every way It will guarantee that you do not mis-type field names. 87 Which of the following is not an argument used in the Pmt function?Type Future_value Total_due Rate 88 What are predefined computations that perform complex calculations? Formulated predefined Functions Expression fusion Arguments 89 Which of the following is not an arithmetic operator? (hint: another type of operator is a comparison operator) + - > * 90 What symbol does Access use to express exponentiation?^ () <> * 91 What symbols does Access use to indicate a field name?[] "" {} () 92 What value will Access calculate from the following formula: =1+(2-3)+5/6-6^2?-35.2 16 -.17 26.69 93 What is not an example of a function? =PV =15*21 =PMT =RATE 94 What can help you build more complex expressions in calculated fields? Expressive Creator Property sheet Expression Builder Design view 95 What button do you click to see the results of a query? Query View Go Run 96 What is a type of field that displays the result of an expression rather than the data stored in a field? AutoNumber Lookup Hyperlink Calculated 97 In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first? 1+ (2-3) 6^2 5/6 98 In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate second?6^2 (2-3) 1+ 5/6 99 When you are prompted to enter a value when you run a query which includes a calculated field, you probably ________. forgot to name the new, calculated field used the wrong arithmetic operator in your formula typed a field name incorrectly entered too many arguments in the formula typed a field name incorrectly 100 What allows you to summarize data by the values of a field?Adding a sumarian field Adding an update field Adding the proper calculated field Adding grouping to a query Adding grouping to a query 101 What is not a necessary piece of data needed for the Pmt function?Interest rate Amount of the loan Amount already paid on the loan Number of periods required to pay off the loan Amount already paid on the loan 102 When creating a calculated field in a query, what common error will not give you a direct indication that there is a problem? Misspelling the name of a field within the calculated fieldForgetting the order of operations Misspelling the field name Forgetting the colon Forgetting the order of operations 103 What is a popular label producing company? Okidata Easy Labels Avery MakeIt Labels 104 What is not an option in the Layout Options for Grouped Data in the Report Wizard?Multi-level Block Outline Stepped 105 Which of the following cannot be included on a form?Drop-down list Subliminal report Button Check box 106 Each of the following are compelling reasons for data entry by using a form, except one which is not true:Less likely to edit the wrong record. Data you enter in a form must then be transferred to the table.Forms can created to resemble paper forms. You can show data from more than one table at a time. Data you enter in a form must then be transferred to the table. 107 Which of the following is not a report view? Report view SQL view Design view Layout view 108 Which of the following is not a primary consideration when designing a report?How many pages of results the report generates What information will be needed in the report The purpose of the report Expectations of the intended user of the report How many pages of results the report generates 109 What is the portability advantage of saving a report as a PDF file?It compresses more tightly. It opens more quickly for other Microsoft Office users.It is always a smaller file size. More people can open the file, for example users of a device, or other operating system More people can open the file, for example users of a device, or other operating system 110 How many other forms does the More Forms list (found under the Create Tab) provide? 2 3 4 5 111 What is not a group on the Report Layout Tools Format tab? Font Number Background Fields 112 What can you not easily do using a form?Move data Delete data Enter data Edit data 113 What type of form control is normally used to display data?Text box Button Data check Label 114 Which of the following is not a form view? Form view SQL view Design view Layout view 115 Pressing the Ctrl key plus what other key enables you to select all the controls on a form? Y A C X 116 What is not a valid reason to edit a form's layout?Unused fields need to be deleted. New fields need to be added. The user's needs have changed. Extra fields need to be added (just in case they will be needed later). Extra fields need to be added (just in case they will be needed later). 117 What is not found on the Data Group on Print Preview tab?Text File Excel Portrait 118 What is not true about a report?It is capable of displaying only one record at a time. It can be sorted independently of its data source. It can be previewed before it is printed. Its record sources include one or more tables, or a query. It is capable of displaying only one record at a time. 119 Normally when you Print Preview a report it will generate a report with how many pages? Only the first two pages Only the first page All the pages are shown in print preview All the pages only if they will all fit on the screen at one time All the pages are shown in print preview 120 Which form tools creates a box asking for user input? Navigation Modal Dialog Datasheet Form Wizard 121 What does PDF in Adobe's portable document format stand for? Public Document Format Portable Document File Portable Document Format Public Document File 122 Which tab is not available for modifying a report, when working in Design View? Design Arrange Format Grouped 123 Which of the following is not true of a form? It can contain background images. It can ONLY display ONE record at a time. It is the most common method of entering data. It can be sorted independently of its data source. It can ONLY display ONE record at a time. 124 Which of the following is not recommended as a professional way of styling a form? Separate the primary key from the rest of the form Right-align the labels Use several fonts to indicate different types of data Left-align the text boxes Use several fonts to indicate different types of data 125 What is not a common format for a number control? Currency Percent Accounted format Comma 126 When running a report, which sort order takes precedence? Underlying table Underlying query Report Underlying form 127 What can you not do with an Access report? View report on screen Print report Save report as a Word document Edit data 128 When modifying a report, on which tab would you find the commands for changing what fields appear on the report?Design Arrange Format Group 129 When modifying a report, on which tab would you find the commands for changing the margins of the report? Design Arrange Format Group 130 Which view of a form is used for data entry?Form view SQL view Design view Layout view 131 What is not found on the Report Layout Tools Arrange tab? Insert Left Insert Existing Field Move Up Insert Right 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?Layout view Form view Design view SQL view 133 Which form (which will include the existing fields from the data source) can be created with just one click?Tabulary layout Formed Wizard Stacked layout Blank Form 134 What does PDF in Adobe's portable document format stand for? Public Document Format Portable Document File Portable Document Format Public Document File 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?Layout view Form view Design view SQL view 136 Which of the following is not true of a form? It can contain background images. It can ONLY display ONE record at a time. It is the most common method of entering data. It can be sorted independently of its data source. It can ONLY display ONE record at a time. |