MS Access Computer Science Questions - Set 20 - ObjectiveBooks

MS Access Computer Science Questions - Set 20

Practice Test: Question Set - 20

1. It is an association established between common fields of two tables.
    (A) Line
    (B) Relationship
    (C) Primary key
    (D) Records

2. Which of the following is a method to create a new table in MS Access?
    (A) Create table in Design View
    (B) Create Table using wizard
    (C) Create Table by Entering data
    (D) All of above

3. The key uniquely identifies each record in a table.
    (A) Primary key
    (B) Key word
    (C) Filed name
    (D) All of above

4. How can you link a table with another so that a field in current table will display values in drop down box from another table while data:
    (A) Query Wizard
    (B) Look up Wizard
    (C) Form Wizard
    (D) Report Wizard

5. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
    (A) Text
    (B) AutoNumber
    (C) Number
    (D) Currency

6. Which do you click to display the table\’s primary key and indexes in a separate window?
    (A) Indexes button
    (B) Primary key button
    (C) View datasheet button
    (D) View design button

7. In MS Access, Text Data type may contain maximum character of
    (A) 255 Character
    (B) 256 Character
    (C) 1064 Character
    (D) No Limit

8. Query can be use to select data from
    (A) Single Table
    (B) Multiple Tables
    (C) Both A & B
    (D) None of these

9. In a module, the VB Name used to display a warning query icon is _______.
    (A) vbCritical
    (B) vbInformation
    (C) vbExclamation
    (D) vbQuestion

10. In Access 2007, to make changes in the Trust Center, you need to go to the ________.
    (A) Microsoft Office button
    (B) Navigation Pane
    (C) Quick Access toolbar
    (D) Database Tools command tab

11. When adding an image, which size mode will change the height or width of the image fit the control?
    (A) Clip
    (B) Stretch
    (C) Zoom
    (D) Crop

12. Which of the following types of joins displays records with the same value in the common field?
    (A) Inner join
    (B) Left outer join
    (C) Right outer join
    (D) Self join

13. Which of the following views enables users to create and modify the sections of a form?
    (A) Datasheet
    (B) Design
    (C) Form
    (D) Layout

14. Which of the following database objects extracts information from one or more tables or queries?
    (A) Forms
    (B) Queries
    (C) Reports
    (D) Tables

15. Which of the following properties identifies the type of information stored in a field?
    (A) Data type
    (B) Field description
    (C) Field name
    (D) Field properties

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: