Question 1

Each field in a table must have a unique name.

Accepted Answer

Each field in a table must have a unique name to avoid confusion and ensure accurate data storage and retrieval.

Question 2

In Access,the primary object of a database is called a table.

Accepted Answer

In Access, the primary object of a database is indeed called a table. A table is where data is stored and organized in rows and columns.

Question 3

A template provides you with a complete,ready-to-use database application.

Accepted Answer

A template is a pre-designed database application that can be customized for specific needs. It contains tables, forms, reports, and other objects needed for a specific type of database application, such as a customer relationship management system or an inventory management system. Templates are designed to be ready-to-use, but some customization may be needed to fit the specific requirements of a business or organization.

Question 4

The Navigation pane shows each object in your database.

Accepted Answer

The Navigation pane in Access displays all the objects in your database, including tables, queries, forms, reports, macros, and modules.

Question 5

CamelCase notation is the practice of using a prefix to indicate the type of object.

Accepted Answer

CamelCase notation is the practice of capitalizing the first letter of each word in a compound word without spaces or punctuation to indicate separate words. It is commonly used in programming languages for naming variables, functions, and other identifiers. It does not indicate the type of object.

Question 6

In Access,it is not possible to delete fields after you have added data to the field.

Accepted Answer

It is possible to delete fields after data has been added to them in Access. However, deleting a field that contains data will also delete the data in the field.

Question 7

Access is a relational database management system.

Accepted Answer

Access is a popular relational database management system developed and distributed by Microsoft.

Question 8

Each field in your database must be assigned a specific data type.

Accepted Answer

Each field in a database must be assigned a specific data type to ensure data consistency and accuracy. The data type determines the kind of data that can be stored in the field, such as text, numbers, dates, or boolean values. This helps to prevent data entry errors and allows for efficient processing of queries and reports.

Question 9

The Navigation pane displays your objects by categories and groups.

Accepted Answer

The Navigation pane in Microsoft Office displays objects by categories and groups, making it easier to navigate and locate specific items.

Question 10

When you first create an object,Access assigns a generic name,such as Table1 or Form1.

Accepted Answer

When you first create an object in Access, it assigns a generic name such as Table1, Form1, Report1, etc.

Question 11

Form objects are used to find data in a database.

Accepted Answer

Form objects are used to present data to users and receive input, but they are not used to find data in a database. Database queries are used for that purpose.

Question 12

It is important to save a database file before closing it.

Accepted Answer

The answer of It is important to save a database...

Question 13

A primary key is a field that contains a unique value for each record.

Accepted Answer

A primary key is used to uniquely identify each record in a table, so it must be a unique value for each record.

Question 14

It is possible to change a limited number of field properties in Datasheet view.

Accepted Answer

In Datasheet view, it is possible to change field properties such as width, format, caption, and default value for a limited number of fields. However, some properties cannot be changed in Datasheet view and require the use of Design view.

Question 15

Design view allows you to enter,modify,delete,or view the data records.

Accepted Answer

Design view is used to modify the structure of a database, not to enter, modify, delete, or view data records.

Question 16

Access provides many different ways to navigate among the data records stored in your tables.

Accepted Answer

Access provides various navigation tools such as navigation buttons, Go To command, Search feature, and scroll bars to move among records in tables.

Question 17

When working with a new table,you can save it by clicking the File tab and clicking the Save button.

Accepted Answer

This is true. When working with a new table, you can save it by clicking the File tab and then clicking the Save button.

Question 18

The AutoFit feature helps visually frame the rows and columns in a datasheet with a border.

Accepted Answer

The AutoFit feature in Excel automatically adjusts the width of columns or the height of rows in the spreadsheet to fit the content in each cell, rather than adding borders.

Question 19

The Back Up Database option creates a copy of your database.

Accepted Answer

The Back Up Database option is meant to create a copy of your database, so that you can restore it if the original one gets damaged or lost. Therefore, the answer is true - the option does indeed create a backup of your database.

Question 20

Access automatically assigns a generic file name to your database,such as Database1.accdb.

Accepted Answer

This is true, Access does automatically assign a generic file name to a new database, typically starting with "Database1" and followed by the file extension .accdb. However, the user can rename the file to something more descriptive if desired.

Quiz 10: Customizing Access and Using Skydrive and Office Web Apps