πŸ“Š Microsoft Access
Q. what is the corresponding text for the <#1/1/95# validation rule setting?
  • (A) Neter a value less or more than 1,195
  • (B) Value must be less than 95 characters
  • (C) Enter a date before 1995
  • (D) All of above
πŸ’¬ Discuss
βœ… Correct Answer: (A) Neter a value less or more than 1,195
πŸ“Š Microsoft Access
Q. which of the following is not a data type
  • (A) Picture/graphic
  • (B) Data/time
  • (C) Texst
  • (D) Number
πŸ’¬ Discuss
βœ… Correct Answer: (A) Picture/graphic
πŸ“Š Microsoft Access
Q. the executive responsible for the data processing function in an organization is
  • (A) Pm
  • (B) Dbms
  • (C) Dp
  • (D) Dpm
πŸ’¬ Discuss
βœ… Correct Answer: (B) Dbms
πŸ“Š Microsoft Access
Q. which of the following is not a type of Microsoft Access database object?
  • (A) Queries
  • (B) Workbooks
  • (C) Forms
  • (D) Tables
πŸ’¬ Discuss
βœ… Correct Answer: (B) Workbooks
πŸ“Š Microsoft Access
Q. a file containing relatively permanent data is
  • (A) Random file
  • (B) Transaction file
  • (C) Master file
  • (D) Sequential file
πŸ’¬ Discuss
βœ… Correct Answer: (C) Master file
πŸ“Š Microsoft Access
Q. the complete picture of data stored in database is known as
  • (A) Record
  • (B) Scheme
  • (C) System flowchart
  • (D) Dbms
πŸ’¬ Discuss
βœ… Correct Answer: (B) Scheme
πŸ“Š Microsoft Access
Q. a subset of characters within a data field is known as
  • (A) Record
  • (B) File
  • (C) Data string
  • (D) Byte
πŸ’¬ Discuss
βœ… Correct Answer: (C) Data string
πŸ“Š Microsoft Access
Q. what is a fast way t adjust the width of a column?
  • (A) Right click the left side of the column heading
  • (B) Double click the left side of the column heading
  • (C) Double click the right side of the column heading
  • (D) Select tools>adjust column width from the menu
πŸ’¬ Discuss
βœ… Correct Answer: (C) Double click the right side of the column heading
πŸ“Š Microsoft Access
Q. what are the columns in a Microsoft Access table called?
  • (A) Rows
  • (B) Fields
  • (C) Cells
  • (D) Records
πŸ’¬ Discuss
βœ… Correct Answer: (B) Fields
πŸ“Š Microsoft Access
Q. how do you update pivot table report data after changes are made to the source data?
  • (A) Save your changes, close the workbook, and then reopen it.
  • (B) Select the pivot table worksheet and press f9 on the keyboard
  • (C) Click the report, and on the pivot table toolbar, click the refresh data button
  • (D) All of the above
πŸ’¬ Discuss
βœ… Correct Answer: (C) Click the report, and on the pivot table toolbar, click the refresh data button