ICC Access Exam Questions With Detailed Answers

/. ICC Access Exam Questions With Detailed Answers ________ are objects on a form that display data or text, perform actions, and let users view and work with information. - Answer-Controls /.________ are the conditions that users can set in a query to identify the specific records they want to return. - Answer-Criteria /.________ data in a report helps to organize and summarize the data. - Answer-Grouping /.________ is the process of arranging data in a specific order based on the value in a field. - Answer-Sorting /.________ records in a form displays only a portion of the total records based on matching specific values. - Answer-Filtering /.A ________ is an organized collection of data. - Answer-database /.A Report Header displays information ________. - Answer-at the top of all pages of the report /.A user can add ________ to the criteria for a field in the Query Design Grid to return results where there is nothing in that field. - Answer-Is Null /.A user can close the existing database and leave Access open to continue working on anther database by clicking close from the ________ tab. - Answer-File /.A user can delete multiple columns from Layout view of a Form by holding down the ________ key and clicking on the range of columns to delete. - Answer-SHIFT /.A user can search for a specific record by clicking on the field within the form they want to search and then clicking ________ from the Home tab. - Answer-Find /.A user can select two different Page Layouts; Portrait that has a vertical orientation and ________ that has a horizontal orientation. - Answer-landscape /.A user can use ________ to view how a table will print before committing. - Answer-Print Preview /.After a user creates a new query or edits an existing query they must ________ the query to display the corresponding results - Answer-run /.All of the following are comparison operators EXCEPT ________. - Answer-/ /.By using a single-record form to add, modify, and delete records, a user can reduce the number of ________ because the individual performing the changes is only looking at one record at a time. - Answer-entry errors /.Database designers typically do not add spaces in field names (LName), but can add details in the ________ field of the field properties to provide additional context to the field that is not displayed (Last Name). - Answer-caption /.Databases that not related or linked to other data are called ________ databases. - Answer-flat /.Fields that contain numbers that are not used in calculations should be set to ________. - Answer-short text /.Filtered is displayed in the ________ bar of a form letting the user know that there is an active filter. - Answer-status /.If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as ________. - Answer-= 500 /.It is not common for a user to need to see all data in all tables which is why creating a ________ allowing a user to get a subset of data is so beneficial. - Answer-query /.Pressing Enter three times at the end of a multiple-items form will open ________. - Answer-a single record form /.Relationships where the join line display 1 and ∞ are displayed indicate that ________ is selected. - Answer-Enforce Referential Integrity /.Single record forms are helpful to users who ________. - Answer-perform data entry /.The ________ key refers to the unique field that identifies each record. - Answer-primary /.The ________ view enables users to see the data in the report as they modify the report. - Answer-Layout /.The ________ view of a form allows a user to view the data while making changes to the elements of the form. - Answer-layout /.The Form ________ walks you step-by-step through the creation of a form and gives you more flexibility in the design, layout and fields in a form. - Answer-Form wizard /.The form does not display data in text box controls in ________ View. - Answer-Design /.The most common type of relationship in Access is ________. - Answer-one-to-many /.The Query window is broken into two parts, the table area and the ________. - Answer-query design grid /.There are times that users need to use a field as part of their select, but do not want to display it on their query results. They can accomplish this by unchecking the ________ box on the Query Design Grid for that field. - Answer-show /.There are two views for tables in Access: Datasheet view and ________ view. - Answer-design /.To edit an existing relationship, a user will need to right-click on the ________ line. - Answer-join /.To establish table relationships, a user needs to click on Relationships from the Relationship Group on the ________ tab. - Answer-External Data /.To establish table relationships, a user will link the primary key of one table to the ________ key of the connected table. - Answer-foreign /.To get the results of a Select Query, the user needs to click ________ from the Results Group in the Design Tab - Answer-Run /.To improve accuracy during user input, a designer can add context to the ________ from the properties screen which will be displayed in the status bar to provide additional information to users who are entering data - Answer-description /.To improve accuracy during user input, a designer can limit the number of characters a user can enter by adjusting the ________ from the properties screen. - Answer-field size /.To open a saved database, a user needs to start Access and click on Open Other Files, then click on the ________ button to locate the saved database. - Answer-browse /.To publish a new database that you want to share with others, you should select a template that has an image of a ________. - Answer-globe /.To quickly rename a table, a user can ________ on the table name from the Navigation Pane and select Rename. - Answer-right-click true or false A user must apply grouping to get totals in a Report. - Answer-false