Microsoft Access MCQs with answers Page - 11

Dear candidates you will find MCQ questions of Microsoft Access here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 Microsoft Access
Q. In a database table, the category of information is called __________
  • (A) Tuple
  • (B) B) Field
  • (C) Record
  • (D) All of above
💬 Discuss
✅ Correct Answer: (B) B) Field
📊 Microsoft Access
Q. If you write criteria values vertically (one in a row) it will mean
  • (A) Or conditions
  • (B) And conditions
  • (C) Not condition
  • (D) None of above
💬 Discuss
✅ Correct Answer: (A) Or conditions
📊 Microsoft Access
Q. In access, this operation copies a backup file from the storage medium back onto the computer
  • (A) Structure
  • (B) Copy
  • (C) Restore
  • (D) Recreate
💬 Discuss
✅ Correct Answer: (C) Restore
📊 Microsoft Access
Q. In a table, ________(s) are displayed in the order in which they were entered. Most often this order is not useful.
  • (A) Record
  • (B) Layout
  • (C) Format
  • (D) Formula
💬 Discuss
✅ Correct Answer: (A) Record
📊 Microsoft Access
Q. The database language that allows you to access or maintain data in a database
  • (A) Dcl
  • (B) Dml
  • (C) Ddl
  • (D) None of above
💬 Discuss
✅ Correct Answer: (A) Dcl
📊 Microsoft Access
Q. You can move between fields in a form by using any of these keys except
  • (A) Tab
  • (B) Enter
  • (C) Page up
  • (D) Shift + tab
💬 Discuss
✅ Correct Answer: (C) Page up
📊 Microsoft Access
Q. Which of the following terms does not describe a database structure used by a dbms to link data from several files?
  • (A) Relational
  • (B) Structural
  • (C) Network
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (B) Structural
📊 Microsoft Access
Q. The default and maximum size of text field in Access
  • (A) 50 and 255 Characters
  • (B) 8 and 1 GB
  • (C) 266 characters & 64000 characters
  • (D) None of above
💬 Discuss
✅ Correct Answer: (A) 50 and 255 Characters
📊 Microsoft Access
Q. Which tool is used to generate printout of a table\’s structure?
  • (A) Generator
  • (B) Documenter
  • (C) Designer
  • (D) Analyzer
💬 Discuss
✅ Correct Answer: (B) Documenter
📊 Microsoft Access
Q. A disadvantage to a ________file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
  • (A) Text
  • (B) Delimited
  • (C) Fixed
  • (D) Standardized
💬 Discuss
✅ Correct Answer: (A) Text

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play