CGS1060

Card Set Information

Author:
aly2490
ID:
142411
Filename:
CGS1060
Updated:
2012-04-19 12:44:51
Tags:
ACCESS
Folders:

Description:
2nd Exam Access
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user aly2490 on FreezingBlue Flashcards. What would you like to do?


  1. access is a _______.
    A) word processing software
    B) workbook management system
    C) database management system
    D) file management system
    C) database management system
    (this multiple choice question has been scrambled)
  2. A(n) ___ contasins information about a given person, nproduct, or event.
    A) attribute
    B) record
    C) field
    D) column
    B) record
    (this multiple choice question has been scrambled)
  3. ____words are words that have a speciaal meaning to Access and cannot be used for names of fields.
    A) Special
    B) Significant
    C) Restricted
    D) Reserved
    D) Reserved
    (this multiple choice question has been scrambled)
  4. In Access, table and field names can be up to ____ characters in lenght.
    64
  5. A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exeed 255'
    Memo
  6. A field with the _____ data type can store a unique sequential number that access assigns to a record. Access will increment the number by 1 as each new record is added.
    A) sequential
    B) AutoNumber
    C) Incremental
    D) AutoSequence
    B) AutoNumber
    (this multiple choice question has been scrambled)
  7. A field whose data type is ___ can store an OLE object, which is an object linked to or embedded in the table.
    A) OLE object
    B) picture
    C) Image
    D) Bitmap
    A) OLE object
    (this multiple choice question has been scrambled)
  8. One way to create a table, is to click _____ on the Ribbon and then click the Table button,
    A) Create
    B) insert table
    C) New
    D) Add
    A) Create
    (this multiple choice question has been scrambled)
  9. when you create a table in Datasheet view, Access automatically adds a field called _____ as the first field in the table.
    A) AutoCode
    B) field 1
    C) ID
    D) TableCode
    C) ID
    (this multiple choice question has been scrambled)
  10. To define an additional field in Datasheet view, click the ____ column heading.
    A) click to add
    B) insert field
    C) new field
    D) blank field
    A) click to add
    (this multiple choice question has been scrambled)
  11. to undo the most recent change to a table structure, click the ____ button on the Quick Acces Toolbar.
    A) escape
    B) cancl
    C) undo
    D) back
    C) undo
    (this multiple choice question has been scrambled)
  12. to delete a field in a table, right click the column heading for the field and then click ____ on the shortcut menu
    A) delete field
    B) delete column
    C) remove field
    D) remove column
    A) delete field
    (this multiple choice question has been scrambled)
  13. to change the name of a field, right click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name
    rename field
  14. to insert a field between existing fields, right click the column heading for the field that will follow the new field and the click ____ on the shortcut menu
    A) add column
    B) insert column
    C) insert field
    D) add field
    C) insert field
    (this multiple choice question has been scrambled)
  15. in the accompanying figure, the key symbol that apears in the row selector for the Business Analyst Number Field indicated that Business Analyst Number is the _____ for the table
    a_ principal key
    b) foreign key
    c) primary key
    d) main key
    c) primary key
  16. to open a table in Design view, right click the table in the navigation pane and then click ____ on the shortcut menu
    A) design view
    B) table design
    C) structure view
    D) layout view
    A) design view
    (this multiple choice question has been scrambled)
  17. to add a record to a table, click the ____ record button
    New ( blank )
  18. you can place an insertion point by clicking in the field or by pressing _____
    F2
  19. to delete a record, click the record selector for th record and the press the ___ key
    delete
  20. to change the orint orientation, click the ____ button on the Print View
    Landscape
  21. to specify Autocorrect rules and excptions to the rules, click File to open a backstage view, click ____ and then click Proofing in the dialog box that displays.
    obtions
  22. to import data to a table, click the _____ tab on the ribbon
    A) database tools
    B) Import
    C) file
    D) external data
    D) external data
    (this multiple choice question has been scrambled)
  23. to save the changes to the layout of the table, click the Save button on the _____
    A) quick access toolbar
    B) navigation pane
    C) status bar
    D) table toolds tab
    A) quick access toolbar
    (this multiple choice question has been scrambled)
  24. to open the navigation pane, click the ____ button
    A) navigation bar show/hide
    B) Shutter bar open/close
    C) open ane
    D) open navigation button
    B) Shutter bar open/close
    (this multiple choice question has been scrambled)
  25. to view the results of a save query, right click the query in the navigation pane and click ____ on the shortcut menu
    open
  26. to create an initial report that can be modified in layout view, click _____ on the create tab.
    report
  27. to quit Access, click the ____ button on the right side of the title bar
    close
  28. to compact and repair a database, click the ___ button in the information gallery in the backstage view
    compact and repair
  29. to back up a database use the Back Up command on the ____ tab in the backstage view
    A) obtions
    B) save and publish
    C) tools
    D) save object as
    B)save and publish
    (this multiple choice question has been scrambled)
  30. to rename a database objectm right click the object in the navigation pane and then click ___ on the shortcut menu
    rename
  31. In access, the rows in the table are called recordsz
    True
  32. A unique identifier also is called a record key
    False
  33. redundancy is the storing of a piece of data in more than one place
    true
  34. in access, table names cannot contain digits
    false
  35. the maximum number of characters allowed in a field whose data type is text is 255 characters.
    true
  36. in one to many relationship, each row in the first table may be associated with many rows in the second table
    true
  37. fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo
    false
  38. The status bar contains a list of all the objects in the database
    False
  39. when access first create a database, it automatically creates a table
    true
  40. in datasheet view, a table is represented as a collection of rows and columns called a list
    false
  41. one way to undo changes to a field is to click the undo button on the Quick Access Toolbar
    true
  42. As shown on the accompanying figure, you can uuse the End record button to move to the last record in the table
    false
  43. A soft copy is information that exists on a physical medium such as paper
    false
  44. green computer involves reducing the environmental waste generaqted when using a computer
    T
  45. landscape orientation means the printout is accross the length (height) of the page
    T
  46. to print a wide database tablem a table whose contents do not fit on the screen, you will need portrait orientation
    F
  47. the textcheck feature of Access corrects common mistakes when entering text in a cell
    F
  48. Form view displays a single record at a time
    T
  49. report view shows a report on the screen and allows the user to make changes to the report
    F
  50. standard properties are associated with all Microsoft Office documents and include author, title, and subject.
    T
  51. the database Tools tab provides commands to compact repair a database
    F
  52. A (n) _________ is a software tool that can be used to create a database; add, change, abd delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data in the database.
    • database management system
    • dbms
  53. the rows in the tables are called _____
    records
  54. A (n) _________ contains a specific piece of information within a record.
    field
  55. A unique identifier also is called a (n) _________.
    primary key
  56. _______ is the storing of a piece of data in more than one place
    redundancy
  57. ______ refers to the arrangement of data into tables and fields
    database design
  58. in the accompanying figure, the _____ Pane contains a list of all the objects in the database.
    Navigation
  59. in the accompanying figure, ______ for the opeb objects appear at the top of the work area.
    object tabs
  60. ________ view has more functionality for creating a table than Database view
    Design
  61. If it is desirable to have a name other than the field name that appear on thr top of the column in Datasheet view, change the field's _______ to a different name
    caption
  62. for the currency data type, access automatically sets the _____ to currency
    format
  63. to move a field, click the column heading for the field to be moved to select the field, and then ________ the field to the desired position.
    drag
  64. in _______, the table is represented as a collection of rows and colums also called a datasheet.
    Database sheet
  65. to move between the upper pane and the lower pane in the Table Design window, press ______ on the keyboard
    F6
  66. the _____ feature of Access corrects common mistakes when you complete a text entry in a cell
    Auto Correct
  67. to create a new query in Design view, click create on the Ribbon to display the Create tab and then click the ____ button to create a new query
    A) query design
    B) select query
    C) query
    D) design view
    A) query design
    (this multiple choice question has been scrambled)
  68. in the accompanying figure, the lower pane in the window where you enter criteria is called the ______
    A) criteria grid
    B) column grid
    C) design grid
    D) query grid
    C) design grid
    (this multiple choice question has been scrambled)
  69. in the accompanying figure, you can delete the table by right clickng the field list and clicking ______ on the shortcut menu.
    A) hide table
    B) remove table
    C) delete table
    D) erase table
    B) remove table
    (this multiple choice question has been scrambled)
  70. in the accompanying figure, the client table was added to query by selecting the table and clicking the add button in the _____ dialog box
    A) select table
    B) add table
    C) field list
    D) show table
    D) show table
    (this multiple choice question has been scrambled)
  71. in the accompanying figure, you can enter BC76 in the _____ row of the client number field to find all clients whose client number is BC76
    A) or
    B)show
    C) Criteria
    D) sort
    C) Criteria
    (this multiple choice question has been scrambled)
  72. in the accompanying figure, you can remove a clumn by clicking just above the field name to select the column and then clicking the ___ key(s)
    A) ctrl + dlete
    B) ctrl + alt
    C) delete
    D) ctrl + Y
    C) delete
    (this multiple choice question has been scrambled)
  73. to save a query, click the Save button on the _____
    quick access toolbar
  74. to change the design of a query, right click the query and then click ____ on the shortcut menu
    A) change
    B) open
    C) database view
    D) design view
    D) design view
    (this multiple choice question has been scrambled)
  75. to print the results of a query that is open, click file on the ribbon, click the ____ tab in the backstage view, and the click quick print
    d) print
  76. to use a parameter query, right click the query in the navigation panr and then click ______ on the shortcut menu
    A) run
    B) enter values
    C) use parameter
    D) open
    D) open
    (this multiple choice question has been scrambled)
  77. in the accompanying figurem the criterion for curent due is 0. The query results for this query will display _____ in the current due field
    $0.00
  78. in the accompanying figure, the criterion for current due is 0. To find all clients whose current due amount is greater than 1,000.00, erase the 0 and enter ____ in the criteria row of the current due column.
    > 1000
  79. in the ccompanying figure, the criterion for current due is 0. to find all clients whose current due amount is $2,000,00, erase the 0 and enter ____ in the criteria row of the Amount paid column
    2000
  80. less than (<), greater than (>) and NOT (not equal) are examples of ____
    A) comparison operators
    B) conditions
    C) compound conditions
    D) compound values
    A) comparison operators
    (this multiple choice question has been scrambled)
  81. to order the records in the answer to a query in a particular way, you ____ the records
    sort
  82. to sort the records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key,
    sort
  83. use a query to ___ tables; that is, to find records in two tables that have identical values in matching fields.
    A) join
    B) concatenate
    C) interleave
    D) combine
    A) join
    (this multiple choice question has been scrambled)
  84. to use the report wizard to create a report for a query, select the query in the navigation pane, click ____ on the ribbon and then click the report wizard button
    A) new report
    B) create
    C) query report
    D) save as report
    B) create
    (this multiple choice question has been scrambled)
  85. to export data from a query to Exel, selet the query in the navigation pane, click ____ on the ribbon, and then click the Exel button
    A) database tools
    B) office export
    C) external data
    D) create
    C) external data
    (this multiple choice question has been scrambled)
  86. to use the expression builder to create a calculated field, select the column in the field row, right click to display the shortcut menu, and then click ______
    A)builder box
    B) build
    C) expression builder
    D) field builder
    B) build
    (this multiple choice question has been scrambled)
  87. to cinclude calculated fields in queries, enter a name for the calculated field, a (n) ________ and then the expression in one of the columns in the fild row
    colon (:)
  88. to display the entire query for a calculated field, select the column in the field row, right click to display the shortcut menu, and the click_____
    A) enlarge
    B) resize
    C) magnify
    D) zoom
    D) zoom
    (this multiple choice question has been scrambled)
  89. you can include ______ in calculations to indicate which calculation should be done first.
    parenthesis ( )
  90. to include the total row in the design grid, click the ____ button on the design tab.
    A) statistics
    B) calculations
    C) totals
    D) aggregate
    C) totals
    (this multiple choice question has been scrambled)
  91. to calculate statistics for only those records that satisfy certain criteria, select ______ as the entry in the total row fo the field, and then enter the criterion in the criteria row
    where
  92. to indicate grouping, in access, select ____ as the entry in the total row for the field to be used for grouping
    group by
  93. to create a crosstap, click the ___ button on the create tab
    A) statistics
    B) chart
    C) query qizard
    D) crosstab wizard
    C) query qizard
    (this multiple choice question has been scrambled)
  94. when you enter text data in the criterion, you must enclose the text in quotation marks.
    false
  95. the asterisk (*) wildcard represents any individual character
    false
  96. the question mark (?) wildcard represents any invidual character
    T
  97. to find all clients whose names begin with Gr, enter Gr* in the criteria row of the design grid
    T
  98. to enter a criterion for a particular field without displaying the field in the results of the query, include the fild in the design grid, enter the criterion, and remove the check mark from its Show cehck box
    T
  99. the query that prompts for input whenever it is run is a run-time query
    F
  100. to create a parameter query that will prompt users to a city name as input, place [ Enter City] as the criterion in the City field
    T
  101. to enter a number in the criterion, type the number without any dollar signs or commas
    T
  102. unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches)
    T
  103. to find all clients whose amount paid is greater than $1,000.00and whose business analyst is analys 11, enter each criterion on different lines
    F
  104. to find all clients whose amount paid is greater than $1,000.00 or whose analyst is analyst 11, enter each criterion on the same line
    F
  105. the field or fields on which records are sorted is called the sort key
    T
  106. if you specify more than one sort key, the sort key on the left will be the minor sort key and the one on the right will be the major sort key
    F
  107. when you sort data in a query, the records in the undrlaying table are actually rearranged
    F
  108. to create a top values query, use the top values box on the design tab to change the n umber of records to be included from All to the desired number
    F
  109. you cannot create a form for a query
    F
  110. the only calculated fields you can create in Access are whose involving addition
    F
  111. grouping means creating groups of records that share common characteristic
    T
  112. to include all fields for a table in the design grid, click the ______ in the field list
    asterisk (*)
  113. to change the design of a query that is not currently open, right click the query in the navigation ane and then click _____ on the shortcut menu
    design view
  114. ________ are symbols that represent any character or combination of characters
    wildcards
  115. the ______ wildcard represents any individual character
    question mark (?)
  116. A (n) ______ query is a query that prompts for input whenever it is used
    parameter
  117. to combine criteria with ______, place the criteria on the same line.
    AND

What would you like to do?

Home > Flashcards > Print Preview