M.S. Access important questions
1. Which object is used to
create a form?
A. Tables and Queries B.
Tables only
C. Tables and reports D. Queries and reports
Answer: A
2. What determines a table's sort order?
A. AutoNumber field B. Index field
C. Field order D. Primary key
Answer: B
3. What is an intersection of a row and a column?
A. Form B.
Cursor
C. Cell D. Record
Answer: C
4. Which tool do you use to create a query object?
A. Database wizard
B. Simple filter wizard
C. Simple query wizard D. Table query wizard
Answer: C
5. What is the purpose of indexing?
A. To reduce table size B.
To speedup data search
C. both A and B D. none of the above
Answer:
B
6. Which is the valid data type in Access?
A. Number B.
Text
C. Currency D. All of the above
Answer: D
7. How do you describe a property in MS Access?
A. a Characteristic or attribute B.
a method or procedure
C. a function or expression D. a macro or module
Answer: A
8. How many relations exist between two tables in databases?
A. 4 B.
3
C. 2 D. 1
Answer: B
9. What is the full form of SQL?
A. Sophisticated Question List B.
Structured Question List
C. Structured Query Language D. Small Query Length
Answer:
C
10. In a datasheet, which icon appears at the left side of a record
while it is being edited?
A. pencil B.
asterisk
C. selector D. pointer
Answer: A
11. When editing a record, which keystroke allows you to save the
changes without leaving the current record?
A. ctrl+alt B.
ctrl+enter
C. alt+enter D. shift+enter
Answer: D
12. Which of the following will not reverse the last action performed?
A. choose edit, undo command B.
click undo button
C. press ctrl+x D. press esc
Answer:
C
13. The row selector buttons in a datasheet are located in the:
A. table selection area B.
row selection area
C. field selection area D. record selection area
Answer: D
14. Which of the following is not a type of action query?
A. modify query B. append query
C. make table query D. delete query
Answer: A
15. Which query do you use to answer the question “Which employees earn
more than $5000 a month”?
A. search query B.
cross tab query
C. select query D. update query
Answer: D
16. Before printing a datasheet, you can use _______________ to determine
whether to change the page orientation from portrait to vertical orientation.
A) Design View B)
Datasheet View
C) Office View D)
Print Preview
Answer: D
17. What is the keyboard shortcut to move to the last records in a table?
A) [Tab] B)
[Shift]+[Tab]
C) [Ctrl]+Home] D)
[Ctrl]+[End]
Answer: A
18. A _______________ is a major database object used to display
information in an attractive, easy-to-read screen format.
A) form B)
query
C) report D) table
Answer: A
19. Print options can be changed in the Print _______________.
A) tab B)
layout mode
C) setup routine D)
dialog box
Answer: D
20. Which major database object stores all data?
A) Field B)
Query
C) Record D)
Table
Answer: D
21. The insertion point looks like a(n) _______________.
A) H-pointer B)
I-pointer
C) H-beam D)
I-beam
Answer: D
22. Access file operations can be found by clicking the _______________.
A) Access Button B)
Database Button
C) Office Button D)
Window Button
Answer: C
23. A _______________ is a major database object used to display
information in a printable page format.
A) form B)
query
C) report D)
table
Answer: C
24. In Datasheet View, new records are added to a table _______________.
A) in alphabetical order B) at the end of the table
C) at the beginning of the table D)
in numerical order
25. What happens when a user selects a record in a form and presses [Delete]?
A) The record is deleted in the form and from its source table.
B) The record is deleted in the form, but not from its source table.
C) The record is neither deleted in the form, nor from its source table.
D) The record is not deleted in the form, but is deleted from its source
table.
Answer: A
26. Which of the following CANNOT be done to data using a Form?
A) Store B)
Sort
C) Edit D)
Print
27. What is one of the advantages for using a form over other Access
objects?
A) Utilizes field placement to improve the efficiency of data entry.
B) Forms store information more efficiently.
C) Forms show the summary of all the records.
D) Forms cannot be edited.
Answer: A
28. Which of the following methods CANNOT be used to copy a block of
text from one part of a table to another?
A) Press [Ctrl]+[C] and [Ctrl]+[V].
B) Right-click, choose from the shortcut menu Copy and Paste.
C) Press [Ctrl]+[+] and [Ctrl]+[-].
D) From the ribbon, select Copy and Paste.
Answer: C
29. A(n) _______________ in the Record Selector indicates a new record.
A) check mark B)
pencil
C) asterisk D)
arrow
Answer: C
30. All attachment fields display as a(n) _______________ in Datasheet
View.
A) icon B)
button
C) thumb tack D) paperclip
31. Which of the following methods CANNOT be used to delete records from
a table?
A) Selecting records and pressing [Delete]
B) Pressing [Ctrl]+[']
C) Clicking the Delete Record button
D) From the ribbon, selecting Delete Record
Answer: B
32. The undo command is found where in Access?
A) Office button B)
Home command tab
C) Status bar D)
Quick Access toolbar
Answer: D
33. How do you select an entire column in the query design grid?
A. click the field header area for the desired column
B. click the field name in the field row
C. Choose edit, select column
D. none of the abov
Answer:
A
34. Which criteria would be appropriate to list all the records having
address “kathmandu”?
A. like “kathmandu”
B. =“kathmandu”
C. “kathmandu” D. all of the above
Answer: D
35. In which order do you place the field to sort a dynaset first by
zipcode, then by lastname and then by firstname?
A. zipcode, firstname, lastname B.
firstname, lastname, zipcode
C. zipcode, lastname, firstname D.
can’t sort by multiple fields
Answer: C
36. What does the expression [detail] ! [product] * 1.30 do?
A. multiplies the contents of detail and product fields by 1.3
B. First divides detail by product and then multiplies by 1.3
C. multiplies the contents of detail in the product table by 1.3
D. multiplies the contents of product in the detail table by 1.3
Answer: D
37. In an application created using the database wizard, the main menu is
presented as a:
A. form, called a switchboard B. report, called a menu
C. table, called a switchboard D. query, called a menu
Answer: A
38. Which leads you through the process of creating a table?
A. wizard
B. assistant
C. relation D. coach
Answer:
A
39. Which data type is better to use for storing the price of an item?
A. Text B.
AutoNumber
C. Number D. Currency
Answer: D
40. Which data type is better to use for storing phone number in the
following format “977-1-4123456”?
A. Text B.
AutoNumber
C. Number D. Currency
Answer:
A
41. 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
Answer: A
42. After right click the field selector button, which do you choose to delete a field in design view?
A. Delete field
B. delete rows
C. remove field D. remove rows
Answer:
B
43. Which tool is used to generate printout of a table’s structure?
A. Analyzer B.
Designer
C. Documenter D. Generator
Answer:
C
44. Which of the following is not a view for interacting with a form
object?
A. Datasheet view B.
Design view
C. Form view D. Layout view
Answer:
D
45. Which of the following is not a legitimate section for form objects?
A. Form detail B. Group header
C. Form header D. Page footer
Answer:
B
46. The basic elements of a form or a report are called:
A. Controls B.
Objects
C. Windows D. Properties
Answer:
A
47. Which Of The Following Creates A Drop Down
List Of Values To Choose From?
A) Ole Object B)
Hyperlink
C) Memo D)
Lookup Wizard
Answer: D
48. The Command Center Of Access File That Appears When You Create Or Open The Ms Access Database File.
A) Database Window B)
Query Window
C) Design View Window D)
Switchboard
Answer :A
49. The Third Stage In Designing A Database Is When We Analyze Our Tables More
Closely And Create A ___________ Between Tables
A) Relationship B)
Join
C) Query D) None Of
These
Answer: A
50. In A Database Table, The Category Of Information Is Called __________
A) Tuple B)
Field
C) Record D)
All Of Above
Answer : B
0 टिप्पणियाँ
please do not enter any spam link in the comment box.