From the current view, add a new Short Text field to the far right side of the table. Name the field: Description
answer
Click the arrow at the top of the Click To Add column. In the Drop-Down Menu, click the Short Text menu item.
question
Replace all instances of the first name julie with Julie. Be sure to match the case exactly.
answer
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.
question
Clear the filter from the Department field.
answer
Click the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, click the Clear Filter button.
question
Modify the width of the CourseDescription column to best fit the data.
answer
Double-click the border next to the CourseDescription column header.
question
Open the Navigation Pane.
answer
Click the Shutter Bar Open/Close button.
question
Close the Course table.
answer
Click the Course table tab (the one at the left). Click the X at right side of the tab.
question
From the current view, rename the ID field to: DegreeName
answer
Double-click the ID column header, type DegreeName and press Enter.
question
Change the Navigation Pane grouping option so tables and dependent database objects are grouped together.
answer
Click the Navigation Pane Header. In the Category/Group menu, click the Tables and Related Views button.
question
Close the Navigation Pane.
answer
Click the Nav Pan Open/Close button.
question
Go to the next record.
answer
Click the Next Record button.
question
Use the Find and Replace dialog to find the record with the text julie, matching the case exactly.
answer
On the Home tab, in the Find group, click the Find button to open the Find and Replace dialog. Type julie in the Find What box. Click the Match Case check box. Click Find Next.
question
From the current view, delete the Description field.
answer
Right-click the Description column header. Click the Delete Field button. Click Yes.
question
Use AutoFilter to filter the query results first to show only records where value in the Department field is Economics and the value in the Credits field is 4.
answer
Click the arrow at the top of the Department column and click the (Select All) check box to remove all the checkmarks. Click the Economics check box to add a checkmark. Click OK. Click the arrow at the top of the Credits column and click (Select All) check box to remove all the checkmarks. Click the 4 check box to add a checkmark. Click OK.
question
Add a new record to the table with the student ID 6412 and advance to the second field.
answer
Click in Cell 33 in the Student ID column, type 6412, and press Tab.
question
From the current view, move the Description field so it is the last field in the table.
answer
Drag Description after Status.
question
Modify the width of the Time column to exactly 22.
answer
On the Home tab, in the Records group, click the More button, and select Field Width to open the Column Width dialog. Type 22 in the Column Width: box. Click OK.
question
Add the Status Quick Start fields to the right of the DegreeName field.
answer
On the Fields tab, in the Add & Delete group, click the More Fields button. Scroll to the bottom of the Field Types gallery to the Quick Start section. Click Status.
question
Sort the records in this table so they are grouped by the value in the Classification field from A to Z and then grouped within each classification by the value in the DOB field from newest to oldest. Don't forget that when sorting by multiple fields, start with the innermost sort and work your way out.
answer
Click the arrow at the top of the DOB column. Click the Sort Z to A button. Click the arrow at the top of the Classification column. Click the Sort A to Z button.
question
Enable active content in this database.
answer
Click the Enable Content button.
question
Create a new blank database named Accounting.
answer
Click File, click New, click the Blank database template, type Accounting in the File Name box, and click Create.
question
Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.
answer
Click the arrow at the top of the DOB column. Click the Sort Newest to Oldest button.
question
Import all of the fields from the Assets worksheet in the Accounting Excel file to a new table. Use the first row as column headings. Do not change any field information. Use the AccountID field as the primary key. Accept the new table Assets. Do not save the import steps.
answer
On the External Data tab, in the Import & Link group, click the New Data Source button. Point to From File, and click Excel. Click the Browse button. Click the Accounting file. Click Open. Click OK. Click Next. Click the First Row Contains Column Headings check box. Click Next. Click Next. Click the Choose my own primary key radio button. Click Next. Click Finish. Click Close.
question
Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance.
answer
Click the arrow at the top of the Department column. Click the (Select All) checkbox, click the Accounting checkbox, click the Finance checkbox, click OK.
question
Clear the sorting from this table.
answer
On the Home tab, in the Sort & Filter group, click the Remove Sort button.
question
Go to record number 20.
answer
Click the Current Record Box, type 20, and press Enter.
question
Create a new table in Datasheet view. Save it with the name: Degrees
answer
On the Create tab, in the Table group, click the Table button. Click the Save button on the Quick Access Toolbar. Type Degrees in the Table Name box. Click OK.
question
Go to the first record.
answer
Click the First Record button.
question
Create a new database from the Students template. Do not change the location. Name the database: Students.
answer
Click File, click New, click the Students template, type Students in the File Name box, and click Create.
question
Open the Course table.
answer
Double-click the Course table.
question
Change the Navigation Pane grouping option so all database objects of the same type are grouped together (all tables together, all forms together, etc.)
answer
Click the Navigation Pane Header. In the Category/Group menu, click the Object Type button.
question
Use Filter by Selection to filter the table to show only records where the student's DOB is 10/25/1998 or later.
answer
Click the 10/25/1998 Cell. On the Home tab, in the Sort & Filter group, click the Selection button. In the Selection menu, click the On or After "10/25/1998" button.
question
Delete this student record (StudentID 3191).
answer
Right-click the Row Selector (that shows 3191). Click the Delete Record button. Click Yes.
question
Create a backup of the database. You do not need to change the backup location.
answer
Click the File tab. Click Save As. Click Back Up Database in the Save Database As section at the right side of the screen. Click the Save As button. Click Save.
question
Go to the previous record.
answer
Click the Previous Record button.
question
Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
answer
Click the arrow at the top of the CourseDescription column. Point to Text Filters, and select Contains... Type Foundation in the CourseDescription contains box. Click OK.
question
Use the Search box to begin searching for a student with the last name beginning with Car.
answer
Click the Search Box, type Car.
question
Go to the last record.
answer
Click the Last Record Button.
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
