Question 1

What is Microsoft Access 2007 program?

Accepted Answer

It is a program that allows you to create and manage databases.

Answer

It is a program that allows you to calculate and manage numbers and values.

Answer

It is a program that allows you to type, save and print letters, novels, and labels.

Answer

It is a program that allows you to create and manage presentations and slides.

Question 2

Which of the followings are  objects of MS Access database?

Accepted Answer

Tables, Queries​, Reports, and Forms

Answer

Data type, Fields, Records, and design.

Answer

Fields, Datasheet view, data type, and variables.

Answer

Design View, Datasheet view, Table, and Fields.

Question 3

What are Form objects in Access used for? What do they provide?

Accepted Answer

Forms are used to rearrange the fields.  forms provide a better and flexible screen format for entering editing, deleting and viewing a record from a table.

Answer

Forms are used to rearrange the primary key.  forms provide a better and records format for entering editing, deleting and viewing a record from a field.

Answer

Forms are used to rearrange the datasheet.  forms provide a better and design view format for entering editing, and viewing a record from a table.

Answer

Forms are used to rearrange the records.  forms provide a data types format for entering editing, deleting and viewing a record from a field.

Question 4

What is a Table in an Access database?

Accepted Answer

It is the fundamental building block of an Access database.  All data are stored in tables.

Answer

It is the fundamental building Field of an Access database.  All design are stored in tables.

Answer

It is the fundamental building records  of an Access database.  All data are stored in records.

Answer

It is the fundamental building forms of an Access table.  All data are stored in forms.

Question 5

What are the two ways of creating a table​ in Access program?

Accepted Answer

1-  using the Table template.  2-  using the "Design View" from the "View" toolbar.

Answer

1-  using the Table Field.  2-  using the "Design table" from the "View" toolbar.

Answer

1-  using the record template. 2-  using the "Design Field" from the "Insert" toolbar.

Answer

1-  using the Field template.  2-  using the "Sheet View" from the "Edit" toolbar.

Question 6

What type of data does the Memo data type store?

Accepted Answer

Memo data type stores Alphanumeric.

Answer

Memo data type stores numeric value  only.

Answer

Memo data type stores data and times only.

Answer

Memo data type stores Alpha texts only.

Question 7

How do you delete a record​ from a database in Access program?

Accepted Answer

1.  Right click on the record you want to delete 2.  from the drop-down menu select "Delete Record" option.

Answer

1.  One click on the field you want to delete 2.  from the drop-down menu select "Edit Record" option.

Answer

1.  Left  click on the record you want to delete 2.  from the drop-down menu select "back Record" option.

Answer

1.  One click on the table you want to delete 2.  from the drop-down menu select "View Record" option.

Question 8

What is a primary Key?

Accepted Answer

It is that field that uniquely identifies a record.

Answer

It is that field that uniquely identifies a Form.

Answer

It is that field that uniquely identifies a table.

Answer

It is that field that uniquely identifies a data type.

Question 9

How do you run MS Access 2007 Program?

Accepted Answer

1.  click on the START menu.  2.  click on the "All Programs". 3.   select Microsoft Office folder.  4.  click on the Microsoft Office Access 2007.

Answer

1.  click on the Access Button.  2.  click on the "All Access ". 3.   select Accessories folder.  4.  click on the Microsoft Office Paint 2007.

Answer

1.  click on the Office menu.  2.  click on the "All Prompts". 3.   select Microsoft Office folder.  4.  click on the Microsoft Office Access 2003.

Answer

1.  click on the Office Button.  2.  click on the "All Office". 3.   select Any Office folder.  4.  click on the Microsoft Office Excel 2007.

Question 10

What is a record in an Access database?

Accepted Answer

It is the related data of a particular entity.

Answer

It is the related record of a particular form.

Answer

It is the related form of a particular report.

Answer

It is the related field of a particular table.

Related quizzes

Related quizzes