access
Go to the first record.
You clicked the first record button
Close the Course table.
You clicked the Course Tab Header, clicked the close table button.
Open the Course table.
You clicked the Course table, clicked the Course table, and double-clicked the Course table.
Go to record number 29.
You clicked the Current Record Box, clicked the Current Record Box, typed 29 in the Current Record Box, and pressed the Enter key.
Create a new blank desktop database named Finance.
You opened the backstage view, clicked the New navigation button, clicked the Blank desktop database template, typed Finance in the File Name box, and clicked the Create button.
Create a new desktop database from the Updated: Students template. Do not change the location. Name the database: Students.
You opened the backstage view, clicked the New navigation button, clicked the Updated: Students template, typed Students in the File Name box, and clicked the Create button.
Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
In the Access Table, you clicked on CourseDescription, clicked the arrow at the top of the CourseDescription column. In the Table Column Filter Right-Click menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom Filter dialog, you typed Foundation in the CourseDescription contains input, clicked the OK button.
Add a new Short Text field to the far right side of the table. Name the field: Description
In the Access Table, you clicked the Click To Add Field Heading. In the Drop-Down Menu menu, you clicked the Short Text menu item. In the Access Table, you typed Description and pressed Enter.
Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance.
In the Access Table, you clicked the arrow at the top of the CourseNumber column, clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Accounting checkbox, clicked the Finance checkbox, and clicked the OK button.
Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.
In the Access Table, you clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Newest to Oldest menu item.
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.
In the Access Table, you clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Z to A menu item. In the Access Table, you clicked the arrow at the top of the Classification column. In the Table Column Filter Right-Click menu, you clicked the Sort A to Z menu item.
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.
In the Access Table, you clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Economics checkbox, and clicked the OK button. In the Access Table, you clicked the arrow at the top of the Credits column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the 4 checkbox, and clicked the OK button.
Delete the Description field.
In the Access Table, you clicked the arrow at the top of the Description column, clicked the arrow at the top of the Description column. In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the Delete button. Inside the Spa : Database dialog, you clicked the Yes button.
Rename the ID field to: DegreeName
In the Access Table, you clicked the arrow at the top of the ID column. You clicked the Table Column Filter Right-Click menu. In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Name & Caption button. Inside the Enter Field Properties dialog, you typed DegreeName in the Name: input, clicked the OK button.
Enable active content in this database.
In the Access Table, you double-clicked the the border next to the CourseDescription column header.
Modify the width of the CourseDescription column to best fit the data.
In the Access Table, you double-clicked the the border next to the CourseDescription column header.
Move the Description field so it is the last field in the table.
In the Access Table, you dragged Description after Status.
Create a new table in Datasheet view. Save it with the name: Degrees
In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table button. You clicked the Table1 Tab Header. In the application header, you clicked the Save button. Inside the Save As dialog, you typed Degrees in the Table Name: input, clicked the OK button.
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.
In the External Data Ribbon Tab in the Import & Link Ribbon Group, you clicked the New Data Source button. In the New Data Source menu in the From File menu, you clicked the Excel menu item. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the Browse... button. You clicked Accounting. Inside the File Open dialog, you clicked the Open button. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the OK button. Inside the Import Spreadsheet Wizard dialog, you clicked the Next > button, checked the First Row Contains Column Headings check box, clicked the Next > button, clicked the Next > button, selected the Choose my own primary key. Radio Button, clicked the Next > button, and clicked the Finish button. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the Close button.
Add the Status Quick Start fields to the right of the DegreeName field.
In the Fields Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow, clicked the View button arrow. In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button. In the More Fields menu, you clicked the Status menu item.
Use the Find and Replace dialog to find the record with the text killian, matching the case exactly.
In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Find button. You clicked the Replace tab, clicked the Find tab. Inside the Find and Replace dialog, you typed killian in the Find What input, checked the Match Case check box, and clicked the Find Next button.
Replace all instances of the first name killian with Killian. Be sure to match the case exactly.
In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Find button. You clicked the Replace tab. Inside the Find and Replace dialog, you typed killian in the Find What input, typed Killian in the Replace With input, checked the Match Case check box, and clicked the Replace All button. Inside the Appointments dialog, you clicked the Yes button.
Delete this student record.
In the Home Ribbon Tab in the Records Ribbon Group, you clicked the Delete button arrow. In the Delete menu, you clicked the Delete Record menu item. Inside the Spa : Database dialog, you clicked the Yes button.
Add a new record to the table with the student ID 6657 and advance to the second field.
In the Home Ribbon Tab in the Records Ribbon Group, you clicked the More button, clicked the More button, and clicked the New button. In the Access Table, you typed 6657, typed 6657 and pressed Enter.
Clear the filter from the Department field.
In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Remove Sort button.
Clear the sorting from this table.
In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Remove Sort button.
Change the Navigation Pane grouping option so tables and dependent database objects are grouped together.
In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow, clicked the View button arrow. You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Tables and Related Views menu item.
Modify the width of the Name column to exactly 20.
In the Home tab, in the Records group, you click the More button, and you selected Field Width to open the Column Width dialog. You typed 20 in the Column Width: box. You click OK.
Go to the last record.
You clicked the Last Record Button.
Close the Navigation Pane.
You clicked the Nav Pane Open/Close button.
Change the Navigation Pane grouping option so all database objects of the same type are grouped together.
You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Object Type menu item.
Go to the next record.
You clicked the Next Record Button.
Go to the previous record.
You clicked the Previous Record Button.
Use the Search box to begin searching for a student with the last name beginning with Cat.
You clicked the Search Box, typed Cat in the Search Box.
Open the Navigation Pane.
You clicked the Shutter Bar Open/Close button.
Create a backup of the database. You do not need to change the backup location.
You opened the backstage view, clicked the Save As navigation button, clicked the Back Up Database button, and clicked the Save As button. Inside the Save As dialog, you clicked the Save button.
Use Filter by Selection to filter the table to show only records where the student's DOB is on 9/12/1992 or after
You selected the On or After 9/12/1992 menu item in the Access ribbon.
