Top Frame TabsTab List tableHomeTab 1 of 3 (active tab)My CoursesTab 2 of 3How to VideosTab 3 of 3 Current Location Introduction to ComputersCGS1000CG3-A10262015 Week 3 Take Test: 2013 Access test Menu Management Options Course Menu: Introduction to Computers (CGS1000CG3-A10262015) Meet Your InstructorHomepageSyllabusStudent ResourcesProgram ResourcesDiscussionKeiser Live!EmailStart HereWeek 1Week 2Week 3Week 4GradebookGroupsToolsHelp Take SurveySurvey Keiser University Survey Undergrad C15FC-1M has been made available to this course. Only one submission will be accepted per respondent. Take Test: 2013 Access test ContentAssistive Technology Tips [opens in new window] Test Information InstructionsDescriptionInstructionsTimed TestThis test has a time limit of 1 hour.This test will save and submit automatically when the time expires. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain.Multiple AttemptsNot allowed. This test can only be taken once. Remaining Time: 58 minutes, 57 seconds. Question Completion Status: Question 1 Which view does not display the data, but allows you to change the field properties? Datasheet view Form view Design view Layout view Question 2 Constants, functions, operators, and identifiers are combined to create this. Formula Action query Expression Control Question 3 This view displays exactly how a report will look when printed and can be used to modify the page layout. Layout view Design view Print Preview Reading view Question 4 The 348 area code has been changed to a new 704 area code. To quickly update all your records, use this feature. Drag and Drop de and Seek Cut and Paste Find and Replace Question 5 A symbol or word in an expression that indicates the operation to be performed is called a: variable operator value symbol Question 6 You can change the column order in a query datasheet by: choosing Edit/Columns/Order choosing Format/Display Order using drag and drop right-clicking the column header and choosing Move Question 7 The smallest unit of information about a record in a database is called a: query field cell record Question 8 If you want your database to perform optimally, you should do this on a regular basis. Restart it Re-format it Clean it Compact it Question 9 Which of the following is NOT an example of a comparison operator? * = > <> Question 10 The Page Up and Page Down keys can be used to move between ________ in a form. fields New (blank) records records controls Question 11 This data type is a unique, sequential number that is automatically incremented by one whenever a new record is added to a table Number Linked Number Field Number AutoNumber Question 12 A _____ establishes the association between common fields in two tables. line hyperlink relationship ScreenTip Question 13 Which of the following CANNOT be accomplished using a query? viewing data in different ways creating new data analyzing data changing existing data Question 14 Which of the following report-building methods guides you through step-by-step? Report Tool Blank report Tool Report Design Report Wizard Question 15 A request for specific data contained in a database is called: Sort Filter Criteria Query Question 16 This database object is used to make displaying and changing records easier. Query Report Table Form Question 17 The Sales Person table contains one record for each sales person. The related Client table contains one record for each client. A particular sales person is assigned to several clients records but each of the clients only have one sales person. This is an example of a ________ relationship. one-to-many many-to-many one-to-one parent-to-child Question 18 This object must be created first, before any other types of objects are created, since it is the basic unit of a database. Table Query Report Form Question 19 The professional-appearing output generated from tables or queries is called: Record File Report Form Question 20 A field name can be up to ___ characters. 16 32 64 128
