ACCESS CHAPTER 1 SIMULATION
EXAM QUESTIONS AND ANSWERS
From the current view, add a new Short Text field to the far right side of the table. Name
the field: Description - Correct Answers -Click the arrow at the top of the Click To Add
column. In the Drop-Down Menu, click the Short Text menu item.
Replace all instances of the first name julie with Julie. Be sure to match the case
exactly. - Correct Answers -On the Home tab, in the Find group, click the Replace
button to open the Find and Replace dialog. Type julie in the Find What box. Type Julie
in the Replace with box. Click the Match Case check box. Click Replace All. Click Yes.
Clear the filter from the Department field. - Correct Answers -Click the arrow at the top
of the Department column. In the Table Column Filter Right-Click menu, click the Clear
Filter button.
Modify the width of the CourseDescription column to best fit the data. - Correct Answers
-Double-click the border next to the CourseDescription column header.
Open the Navigation Pane. - Correct Answers -Click the Shutter Bar Open/Close button.
Create a new database from the Students template. Do not change the location. Name
the database: Students. - Correct Answers -Click File, click New, click the Students
template, type Students in the File Name box, and click Create.
Open the Course table. - Correct Answers -Double-click the Course table.
Change the Navigation Pane grouping option so all database objects of the same type
are grouped together (all tables together, all forms together, etc.) - Correct Answers -
Click the Navigation Pane Header. In the Category/Group menu, click the Object Type
button.
Close the Course table. - Correct Answers -Click the Course table tab (the one at the
left). Click the X at right side of the tab.
From the current view, rename the ID field to: DegreeName - Correct Answers -Double-
click the ID column header, type DegreeName and press Enter.
Change the Navigation Pane grouping option so tables and dependent database
objects are grouped together. - Correct Answers -Click the Navigation Pane Header. In
the Category/Group menu, click the Tables and Related Views button.
EXAM QUESTIONS AND ANSWERS
From the current view, add a new Short Text field to the far right side of the table. Name
the field: Description - Correct Answers -Click the arrow at the top of the Click To Add
column. In the Drop-Down Menu, click the Short Text menu item.
Replace all instances of the first name julie with Julie. Be sure to match the case
exactly. - Correct Answers -On the Home tab, in the Find group, click the Replace
button to open the Find and Replace dialog. Type julie in the Find What box. Type Julie
in the Replace with box. Click the Match Case check box. Click Replace All. Click Yes.
Clear the filter from the Department field. - Correct Answers -Click the arrow at the top
of the Department column. In the Table Column Filter Right-Click menu, click the Clear
Filter button.
Modify the width of the CourseDescription column to best fit the data. - Correct Answers
-Double-click the border next to the CourseDescription column header.
Open the Navigation Pane. - Correct Answers -Click the Shutter Bar Open/Close button.
Create a new database from the Students template. Do not change the location. Name
the database: Students. - Correct Answers -Click File, click New, click the Students
template, type Students in the File Name box, and click Create.
Open the Course table. - Correct Answers -Double-click the Course table.
Change the Navigation Pane grouping option so all database objects of the same type
are grouped together (all tables together, all forms together, etc.) - Correct Answers -
Click the Navigation Pane Header. In the Category/Group menu, click the Object Type
button.
Close the Course table. - Correct Answers -Click the Course table tab (the one at the
left). Click the X at right side of the tab.
From the current view, rename the ID field to: DegreeName - Correct Answers -Double-
click the ID column header, type DegreeName and press Enter.
Change the Navigation Pane grouping option so tables and dependent database
objects are grouped together. - Correct Answers -Click the Navigation Pane Header. In
the Category/Group menu, click the Tables and Related Views button.
