Microsoft Access Computer Science Questions & Answers - Set 26 - ObjectiveBooks

Microsoft Access Computer Science Questions & Answers - Set 26

Practice Test: Question Set - 26

1. The database language that allows you to access or maintain data in a database
    (A) DCL
    (B) DML
    (C) DDL
    (D) None of above

2. It is most common type of query. It retrieves records from one or more tables and then displays the
    (A) Parameter
    (B) Select
    (C) Crosstab
    (D) All of above

3. An Access database object that is used to enter, view or edit records
    (A) Table
    (B) Form
    (C) Query
    (D) Report

4. What is the full form of SQL?
    (A) Sophisticated Question List
    (B) Structured Question List
    (C) Structured Query Language
    (D) Small Query Length

5. Which of the following data type is used to store logical value in MS Access?
    (A) True/False
    (B) On/Off
    (C) Yes/No
    (D) All of Above

6. In a module, a(n) _______ is a series of commands and properties that perform a specific task.
    (A) Event
    (B) Property
    (C) Procedure
    (D) Macro

7. If a color property contains “#336699”, how many blue units are in the color?
    (A) 33
    (B) 66
    (C) 99
    (D) 255

8. Which function extracts the name of the month from a date/time value?
    (A) Month
    (B) MonthName
    (C) MonthLabel
    (D) MonthValue

9. In a junction table, the ________ field consists of the foreign key from both the linked tables.
    (A) First defined
    (B) Last defined
    (C) Foreign key
    (D) Primary key

10. Which of the following views is used to graphically summarize and analyze data in a recordset?
    (A) Datasheet
    (B) Form
    (C) PivotChart
    (D) PivotTable

11. The content and application of the Search tool CANNOT be retained when you ________.
    (A) Format an object
    (B) Resize a column
    (C) Use Datasheet View
    (D) Close an object

12. Search engines use a(n) ________ to automatically index sites.
    (A) Crawler
    (B) Query
    (C) Enterprise
    (D) Site builder

13. To store your picture in a database requires a(n) ________ field.
    (A) BLOB
    (B) Text
    (C) Image
    (D) Logical

14. What is the maximum length a text field can be?
    (A) 120
    (B) 255
    (C) 265
    (D) 75

15. When a picture or other graphic image is placed in the report header section it will appear________
    (A) Once in the bugging of the report
    (B) At the top of every page
    (C) Every after record break
    (D) On the 1st and last pages of the report

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: