Microsoft Access MCQs with answers Page - 1

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

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following store command to retrieve data from database?

  • (A) Tables
  • (B) Queries
  • (C) Reports
  • (D) Forms

R

Ram Sharma • 193.86K Points
Coach 

Q. What do you mean by, one-to-many relationship between Student and Class table?

  • (A) Many students may have many classes
  • (B) Many classes may have many students
  • (C) One class may have many student
  • (D) One student can have many classes

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following term is least related to database?

  • (A) Columns
  • (B) Relationship
  • (C) Tuples
  • (D) Attributes

R

Ram Sharma • 193.86K Points
Coach 

Q. A database object in MS Access that stores a question about the data in database?

  • (A) Report
  • (B) Query
  • (C) Form
  • (D) Table

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following expresses correct order?

  • (A) Files, Databases, Tables, Records, Fields, Characters
  • (B) Databases, Tables, Files, Records, Field, Character
  • (C) Characters, Fields, Records, Tables, Database, Files
  • (D) Characters, Fields, Records, Tables, Files, Databases

R

Ram Sharma • 193.86K Points
Coach 

Q. To create primary key for a table when in design view

  • (A) Type PRIMARY in field type box when creating
  • (B) Click the Primary Key button in Design ribbon when the cursor is in required field
  • (C) Mark the Primary check box in field name of required field
  • (D) None of the above

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following is not a logical database structure?

  • (A) Relational
  • (B) Tree
  • (C) Network
  • (D) Chain

R

Ram Sharma • 193.86K Points
Coach 

Q. Which type of field is incremented automatically?

  • (A) Auto Value
  • (B) Auto Increment
  • (C) AutoNumber
  • (D) Auto Elevate

R

Ram Sharma • 193.86K Points
Coach 

Q. Which tool do you use to create a query object?

  • (A) Table query wizard
  • (B) Simple query wizard
  • (C) Simple filter wizard
  • (D) Database wizard

R

Ram Sharma • 193.86K Points
Coach 

Q. How many relations may exist between tables in databases?

  • (A) 1
  • (B) 2
  • (C) 3
  • (D) 4

Loding content...

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.