You're entering records into adatabase, and you realize you don't have the information for one ofthe fields. What do you do?
Use letters in alphabetical order toselect options
- A
In the Field Properties section,change the Required field to Blank so users can skip the fieldduring data entry.
- B
Unless a field's set up to require anentry, you can skip the fields for which you don't have anydata.
- C
In order for a user to leave a fieldblank, you'd have to set its data type to Optional so that dataentry personnel can skip it.
- D
Access doesn't allow blank fields, soyou have to wait until you have all the fields' data before you canenter that record.
2
Which data type would you use for afield that will contain phone numbers?
Use letters in alphabetical order toselect options
- A
Number.
- B
Hyperlink.
- C
Short Text.
- D
AutoNumber.
3
On which Ribbon tab will you findtools for starting a new table?
Use letters in alphabetical order toselect options
- A
The Database Tools tab contains theCreate Table button.
- B
The Create tab contains the Table andTable Design buttons.
- C
The Design tab contains the DesignTable button.
- D
The File tab contains the New Tablecommand.
4
What are the benefits of usingvalidation rules?
Use letters in alphabetical order toselect options
- A
They reduce typos, create a consistentlook for reports, and make searching easier.
- B
They make data entry go faster byinserting a value automatically into the field, and they make iteasier to set up reports that must include a lot of information ona single sheet of paper.
- C
They eliminate duplicate entries inrecords that must remain unique, and they speed up the data entryprocess.
- D
They prevent duplicate values in morethan one field in the table, which makes it easier for Access tosort your records.
5
How do you control the way Accessstores and displays a date in a table field?
Use letters in alphabetical order toselect options
- A
Type MMDDYYYY into the Validation Rulerow under Field Properties.
- B
Use the Format setting under FieldProperties, and choose a format from the drop-down menu.
- C
Type Short or Long, the two dateformat options, into the Format row under Field Properties.
- D
Type Short Date in the FieldSize setting under Field Properties.
6
When you're ready to go back to workon a database you used earlier in the day, what's the quickest wayto find and reopen it?
Use letters in alphabetical order toselect options
- A
Click the File tab, and click the Opencommand to display your most recently used database files.
- B
Click the Home tab, click the Viewbutton's drop-down menu, and choose View Recent Files.
- C
Click the Open button on the QuickAccess Toolbar.
- D
Click the File tab and see the filelisted in the menu, or click Recent to display a list of recentlyused databases.
7
Which data types can you apply to theprimary key in your Access tables?
Use letters in alphabetical order toselect options
- A
Primary key fields can use AutoNumberor Text data types, but they can't use Memo data types.
- B
Any data type other than Memo isacceptable for a primary key.
- C
The default is AutoNumber, but anydata type that allows a user to enter unique data into that fieldis acceptable.
- D
All primary keys use the AutoNumberdata type because it's the only one that allows unique dataentry.
8
How do you display your tables' fieldsso you can establish relationships between tables in yourdatabase?
Use letters in alphabetical order toselect options
- A
On the Database Tools tab, click theObject Dependencies button to display a list of all the tablefields in your database.
- B
On the Create tab, click theRelationships button. From there, you can select the tables in yourdatabase from the drop menu and view their fields.
- C
On the Database Tools tab, click theRelationships button, and use the resulting Show Table dialog boxto display a field list box for each table in your database.
- D
Open all your tables in datasheetview, and use your mouse to drag the field names from one table toanother.
9
What's the easiest way to rename afield?
Use letters in alphabetical order toselect options
- A
Open the table in design view, clickthe current name in the Field Name column, and edit it there.
- B
The only field you can rename is thedefault ID field by adding text in front of the letters \"ID\" tocustomize the primary key.
- C
In the Table Tools tab, click theInsert Rows button, enter the desired field name into the new row,and then use the Delete Row button to remove the one with theincorrect name.
- D
You can't rename fields once you'vecreated them. All you can do is delete them and create a new fieldwith the name you wanted to use.
10
When you work with a form, as many asfive arrow buttons may appear near the bottom left corner of yourform. Which of these buttons can you always use to go to the lastrecord in your table?
Use letters in alphabetical order toselect options
- A
The second button, which looks like aleft arrow.
- B
The fourth button, which looks like aright arrow pointing to a vertical line.
- C
The first button, which looks like aleft arrow pointing at a line.
- D
The third button, which looks like aright arrow.
