Q. COPY STRUCTURE command is used to

  • (A) Copy contents of an active database to a new file
  • (B) Copy all records of an active database to disk
  • (C) Copy contents of an active database to disk
  • (D) Copy structure of an active database to a new file
πŸ’¬ Discuss
βœ… Correct Answer: (D) Copy structure of an active database to a new file

Q. DBMS is

  • (A) Collection of data
  • (B) Set of programs to access those data
  • (C) Set of programs to update those data
  • (D) All of the above
πŸ’¬ Discuss
βœ… Correct Answer: (D) All of the above

Q. If you are entering data in a form, a quick way to copy a value from the previous record is to press

  • (A) Ctrl+’
  • (B) F6
  • (C) Ctrl+D
  • (D) None of the above
πŸ’¬ Discuss
βœ… Correct Answer: (A) Ctrl+’

Q. Sub-schema can be used to

  • (A) Create very different, personalized views of the same data
  • (B) Present information in different formats
  • (C) Hide sensitive information by omitting fields from the subschema’s description
  • (D) All of the above
πŸ’¬ Discuss
βœ… Correct Answer: (D) All of the above

Q. The purpose of the Add-in Manager is to

  • (A) Create macros and automate data processing
  • (B) Add or remove data in an existing database
  • (C) Add or remove templates, macros, and wizards
  • (D) All of above
πŸ’¬ Discuss
βœ… Correct Answer: (C) Add or remove templates, macros, and wizards

Q. Which of the following are common ways to enforce data validation when entering data into an Access form?

  • (A) Create an input mask to restrict the kind of value that can be entered in positions across the field.
  • (B) Define a validation rule for that field
  • (C) A and B
  • (D) none of the above
πŸ’¬ Discuss
βœ… Correct Answer: (C) A and B

Q. Pivot Table reports are good for

  • (A) Analyzing large amounts of data
  • (B) Turning tables upside down
  • (C) Breaking spreadsheet data into multiple worksheet
  • (D) None of above
πŸ’¬ Discuss
βœ… Correct Answer: (A) Analyzing large amounts of data

Q. What did the first Table Analyzer do?

  • (A) Analyze the data in a set of flat files and automatically create a relational database system from that information
  • (B) Provide a graphic way to design relational databases
  • (C) Automate process of connecting tables to SQL Server
  • (D) None
πŸ’¬ Discuss
βœ… Correct Answer: (A) Analyze the data in a set of flat files and automatically create a relational database system from that information

Q. Which field allow to select items from drop down list?

  • (A) An OLE field
  • (B) A Memo Field
  • (C) A lookup Field
  • (D) A hyperlink field
πŸ’¬ Discuss
βœ… Correct Answer: (C) A lookup Field

Q. What is a Grouped Report?

  • (A) A type of report that can be generated by the Report Wizard
  • (B) A report that displays data that has been sorted in ascending or descending order
  • (C) A report that displays data grouped by fields you specify
  • (D) None
πŸ’¬ Discuss
βœ… Correct Answer: (C) A report that displays data grouped by fields you specify

Jump to