Question

• 1

You're entering records into a database, and you realize you don't have the information for one of the fields. What do you do?

Use letters in alphabetical order to select options

1. A

In the Field Properties section, change the Required field to Blank so users can skip the field during data entry.

2. B

Unless a field's set up to require an entry, you can skip the fields for which you don't have any data.

3. C

In order for a user to leave a field blank, you'd have to set its data type to Optional so that data entry personnel can skip it.

4. D

Access doesn't allow blank fields, so you have to wait until you have all the fields' data before you can enter that record.

2

Which data type would you use for a field that will contain phone numbers?

Use letters in alphabetical order to select options

1. A

Number.

2. B

Hyperlink.

3. C

Short Text.

4. D

AutoNumber.

3

On which Ribbon tab will you find tools for starting a new table?

Use letters in alphabetical order to select options

1. A

The Database Tools tab contains the Create Table button.

2. B

The Create tab contains the Table and Table Design buttons.

3. C

The Design tab contains the Design Table button.

4. D

The File tab contains the New Table command.

4

What are the benefits of using validation rules?

Use letters in alphabetical order to select options

1. A

They reduce typos, create a consistent look for reports, and make searching easier.

2. B

They make data entry go faster by inserting a value automatically into the field, and they make it easier to set up reports that must include a lot of information on a single sheet of paper.

3. C

They eliminate duplicate entries in records that must remain unique, and they speed up the data entry process.

4. D

They prevent duplicate values in more than one field in the table, which makes it easier for Access to sort your records.

5

How do you control the way Access stores and displays a date in a table field?

Use letters in alphabetical order to select options

1. A

Type MMDDYYYY into the Validation Rule row under Field Properties.

2. B

Use the Format setting under Field Properties, and choose a format from the drop-down menu.

3. C

Type Short or Long, the two date format options, into the Format row under Field Properties.

4. D

Type Short Date in the Field Size setting under Field Properties.

6

When you're ready to go back to work on a database you used earlier in the day, what's the quickest way to find and reopen it?

Use letters in alphabetical order to select options

1. A

Click the File tab, and click the Open command to display your most recently used database files.

2. B

Click the Home tab, click the View button's drop-down menu, and choose View Recent Files.

3. C

Click the Open button on the Quick Access Toolbar.

4. D

Click the File tab and see the file listed in the menu, or click Recent to display a list of recently used databases.

7

Which data types can you apply to the primary key in your Access tables?

Use letters in alphabetical order to select options

1. A

Primary key fields can use AutoNumber or Text data types, but they can't use Memo data types.

2. B

Any data type other than Memo is acceptable for a primary key.

3. C

The default is AutoNumber, but any data type that allows a user to enter unique data into that field is acceptable.

4. D

All primary keys use the AutoNumber data type because it's the only one that allows unique data entry.

8

How do you display your tables' fields so you can establish relationships between tables in your database?

Use letters in alphabetical order to select options

1. A

On the Database Tools tab, click the Object Dependencies button to display a list of all the table fields in your database.

2. B

On the Create tab, click the Relationships button. From there, you can select the tables in your database from the drop menu and view their fields.

3. C

On the Database Tools tab, click the Relationships button, and use the resulting Show Table dialog box to display a field list box for each table in your database.

4. D

Open all your tables in datasheet view, and use your mouse to drag the field names from one table to another.

9

What's the easiest way to rename a field?

Use letters in alphabetical order to select options

1. A

Open the table in design view, click the current name in the Field Name column, and edit it there.

2. B

The only field you can rename is the default ID field by adding text in front of the letters "ID" to customize the primary key.

3. C

In the Table Tools tab, click the Insert Rows button, enter the desired field name into the new row, and then use the Delete Row button to remove the one with the incorrect name.

4. D

You can't rename fields once you've created them. All you can do is delete them and create a new field with the name you wanted to use.

10

When you work with a form, as many as five arrow buttons may appear near the bottom left corner of your form. Which of these buttons can you always use to go to the last record in your table?

Use letters in alphabetical order to select options

1. A

The second button, which looks like a left arrow.

2. B

The fourth button, which looks like a right arrow pointing to a vertical line.

3. C

The first button, which looks like a left arrow pointing at a line.

4. D

The third button, which looks like a right arrow.

Answer 1

Q1. You're entering records into a database, and you realize you don't have the information for one of the fields. What do you do?

Answer

B Unless a field's set up to require an entry, you can skip the fields for which you don't have any data.

Explanation: In Access db , if any field is required it is mandatory and it is necessary to add details in that field, optional field can be skip.

2 Which data type would you use for a field that will contain phone numbers?

Answer

A Number.

Explanation: Phone number is always a number field as per industry and world standard.

3 On which Ribbon tab will you find tools for starting a new table?

Answer:

A The Database Tools tab contains the Create Table button.

Explanation : There is design and create table query option in database tools tab

4 What are the benefits of using validation rules?

Answers

A They reduce typos, create a consistent look for reports, and make searching easier.

C They eliminate duplicate entries in records that must remain unique, and they speed up the data entry process.

Explanation: The validation rules allows right and consistent data entry. For e.g validation for phone number as data type number will only allow numbers no text. Otherwise phone number field may have erroneous data in it. It is also help keeping integrity of data.

5 How do you control the way Access stores and displays a date in a table field?

Answer

C Type Short or Long, the two date format options, into the Format row under Field Properties.

Explanation :Choosing format from field properties is the best way to use out of box functionality.

6 When you're ready to go back to work on a database you used earlier in the day, what's the quickest way to find and reopen it?

Answer

D. Click the File tab and see the file listed in the menu, or click Recent to display a list of recently used databases.

Explanation: Mostly the file and view has recently used database location .

7 Which data types can you apply to the primary key in your Access tables?

Answer

3. C The default is AutoNumber, but any data type that allows a user to enter unique data into that field is acceptable.

Explanation: Auto number is always used as primary key. Primary key can be used for non auto number as well provided the unique data is used for this field.Like StudendId, PatientId or SocialSecurityNumber. etc.

8 How do you display your tables' fields so you can establish relationships between tables in your database?

Answer

1. A On the Database Tools tab, click the Object Dependencies button to display a list of all the table fields in your database.

Explanation: Most of the database ide have this object dependencies feature which not only shows table relationship but also constraint, foreign key etc.

9 What's the easiest way to rename a field?

Use letters in alphabetical order to select options

1. A Open the table in design view, click the current name in the Field Name column, and edit it there.

Explanation: You can also rename using query.

10 When you work with a form, as many as five arrow buttons may appear near the bottom left corner of your form. Which of these buttons can you always use to go to the last record in your table?

Answer

2. B The fourth button, which looks like a right arrow pointing to a vertical line.

Explanation: Usually first button takes you to previous or first and last button takes you to next or last.