Microsoft Access Quiz

Which of the following is a database management system software?

• Firefox

• MS Access

• MS PowerPoint

• MS Word

Suppose that you are the data entry officer of ABC company and the manager of your department has asked you to design a database , using Microsoft Access, to hold basic information about the employees. The database should contain the employees' name, address, date of birth, gender and salary.

Identify the entity and attributes to create an employee database for your company based on the above information.

• Entity – Name , Attributes – Employee, Address, Date of Birth, Gender and Salary

• Entity – Gender, Attributes – Employee, Address, Date of Birth, Name and Salary

• Entity –Employee, Attributes – Name, Address, Date of Birth, Gender and Salary

• Entity – Address, Attributes – Employee, Name , Date of Birth, Gender and Salary

What is Database ? (select all correct answers)

• A collection of logically related data stored in a manner so it can be retrieved as needed.

• Data is organized into rows, columns and tables, and it is indexed to make it easier to find relevant information.

• Data gets updated, expanded and deleted as new information is added.

• Databases process workloads to create and update themselves, querying the data they contain and running applications against it.

The columns in a Microsoft access table are also called _______ 

• Rows

• Records

• Fields

• Columns

When one occurrence of an entity is linked with more than one occurrence of another entity, it is called a _______ relationship

• One to One

• Many to Many

• One to Many

  _____ enables the user to automatically insert numbers in a sequential or random number.

• Auto Number

• Look up Wizard

• Hyperlink

• Ole object

The columns in a Microsoft Access table are called as ____

• Record

• Tuple

• Field

• All of above

Which of the following is not a valid Data Type in MS Access?

• AutoNumber

• Currency

• Picture

• Memo

A part of database that stores complete information about an entity such as employee, sales, orders etc.

• Record

• File

• Field

• Query

Which of the following creates a drop down list of values to choose from?

• ID

• Hyperlink

• Lookup wizard

• Clip object