Access
Enable active content in this database.
You clicked the Enable Content button.
Go to the first record.
You clicked the First Record Button.
Open the Class form.
You clicked the Shutter Bar Open/Close button, clicked the Class table, clicked the Student form, and double-clicked the Class form.
From the current view, add a new Short Text field to the far right side of the table. Name the field: Description
You pressed the Ctrl + F keyboard shortcut. Inside the Find and Replace dialog, you typed in the Find what input, clicked the dialog Close button. In the Access Table, you clicked the arrow at the top of the Click To Add column. In the Drop-Down Menu menu, you clicked the Short Text menu item. In the Access Table, you typed Description and pressed Enter.
Create a new relationship between the EmployeeID field in the Professor table and the Advisor field in the Student table. Ensure that values in the Advisor field have a corresponding value in the EmployeeID field.
CorrectIn the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You clicked the relationships Database, dragged the object onto the advisor in the student Database. Inside the Edit Relationships dialog, you checked the Enforce Referential Integrity check box, clicked the Create button.
From the current view (Datasheet view), set the Default Value property for the Classification field to Fr.
CorrectIn the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Default Value button. Inside the Expression Builder dialog, you typed =Fr in the Expression Default Value Input input, clicked the Ok button.
Switch to the view where you can modify the structure of the report without viewing any live data.
CorrectIn the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Design View menu item.History
Switch to the view where you can see live data while modifying the report layout.
CorrectIn the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Layout View menu item.
Open the Course table.
CorrectYou clicked the Course table, double-clicked the Course table.
Preview how this report will look when printed.
CorrectYou clicked the Microsoft Search field, changed the Microsoft Search field, opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button.
Open the Navigation Pane.
CorrectYou clicked the Shutter Bar Open/Close button.
Create a Split form from the Classes table.
CorrectYou clicked the Tables navigation item, right-clicked the Classes table, and clicked the Classes table. In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the More Forms button. In the More Forms menu, you clicked the Split Form menu item.
Create a new database from the Students template. Do not change the location. Name the database: Students.
CorrectYou opened the backstage view, clicked the New navigation button, clicked the Blank database template, clicked the Blank database close button, clicked the Students template, typed Students in the File Name box, and clicked the Create button.
Create a new blank database named Accounting.
CorrectYou opened the backstage view, clicked the New navigation button, clicked the Blank database template, typed Accounting in the File Name box, and clicked the Create button.
Preview how the results of this query will look when printed.
CorrectYou opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button.
From the current view (Layout view), group this report by values in the DOB field. Change the grouping to group by year instead of by quarter.
In the Access Report, you clicked on DOB(Cell 1-0) in the DOB column, right-clicked cell 1-0. In the Design Ribbon Tab in the Grouping & Totals Ribbon Group, you clicked the Group & Sort button. You clicked the Add a Sort button. In the Field Name menu, you clicked the DOB menu item. You clicked the by quarter arrow. In the Sort By menu, you clicked the by year menu radio button.
From Layout view, change the width of the DeptName column, so the department names do not wrap to two lines (approximately 2.3 inches).
In the Access Report, you resized the DeptName column to 179.33333206176758 px by dragging cell 0-0's right border.
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 right-clicked the CourseNumber column header. You clicked the Right Click Menu menu. 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 English checkbox, clicked the Finance checkbox, clicked the Management checkbox, clicked the English checkbox, clicked the Finance checkbox, clicked the Management checkbox, clicked the (Select All) checkbox, clicked the (Select All) checkbox, clicked the Economics checkbox, and clicked the OK button. In the Access Table, you clicked on Credits, 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.
From the current view, rename the ID field to: DegreeName
In the Access Table, you typed DegreeName, pressed Enter, pressed Enter, double-clicked the ID column header, and typed DegreeName and pressed Enter.
From the current view (Layout view), add the date and time to the report header using the date format similar to 31-May-19 and the time format similar to 1:12 PM.
In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Date and Time button. Inside the Date and Time dialog, you selected the 30-Nov-23 Radio Button, selected the 7:38 AM Radio Button, and clicked the OK button.
From the current view (Layout view), add automatic page numbers centered at the bottom of the page footer on every page. Use the format that includes the current page number and the total number of pages.
In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Page Numbers button. Inside the Page Numbers dialog, you selected the Page N of M Radio Button, selected the Bottom of Page [Footer] Radio Button, and clicked the OK button.
From the current view (Design view), set the Default Value property for the Classification field to Fr.
CorrectIn the Access Table, you clicked the Default Value property box, clicked the Default Value Build... Button. Inside the Expression Builder dialog, you typed =Fr in the Expression Default Value Input input, clicked the Ok button.History
Create a Single Record form from the Classes table.
CorrectIn the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Form button.
Add a new table in Design view.
CorrectIn the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button.
Go to the last record.
In the Access Table, you clicked in the MKT-423 Cell.
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 on Department, clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the Marketing checkbox, clicked the Management checkbox, clicked the English checkbox, clicked the Economics checkbox, clicked the Computer Information Systems checkbox, and clicked the OK button.
Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.
In the Access Table, you clicked the Input Mask property box, clicked the Input Mask Build... Button. Inside the Input Mask Wizard dialog from the Input Mask list, you selected Short Date. Inside the Input Mask Wizard dialog, you clicked the Next > button, clicked the Next > button, and clicked the Finish button.
Use the Form Wizard to create a new form. Include these fields in this order from the Departments table: DeptCode and DeptName fields and then add these fields from the Courses table: CourseNumber and CourseDescription. Organize the form by the Departments table with data from the Courses table as a datasheet subform. Accept the suggested names for the form and subform. Allow Access to open the form in Form view when you are finished.
In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Form Wizard button. Inside the Form Wizard dialog in the Table: Departments drop-down, you selected Table: Departments. Inside the Form Wizard dialog from the Available Fields list, you selected DeptName, double-clicked the DeptCode list item, and double-clicked the DeptName list item. Inside the Form Wizard dialog in the Table: Departments drop-down, you selected Table: Courses. Inside the Form Wizard dialog from the Available Fields list, you double-clicked the CourseNumber list item, double-clicked the CourseDescription list item. Inside the Form Wizard dialog, you clicked the DialogHeader view, clicked the dialog undefined button. Inside the Form Wizard dialog in the Table: Departments drop-down, you selected Table: Departments. Inside the Form Wizard dialog, you clicked the Next > button, clicked the Next > button, clicked the Next > button, and clicked the Finish button.
Start a new query without using one of the query wizards.
In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design button.
Create a new query in Design view using the following fields in this order: From the Students table, add the LastName, FirstName, Classification, and ResidenceHall fields. From the ResidenceHalls table, add the ResidenceName and FreshmenOnly fields. Run the query.
In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design button. Inside the Add Tables dialog from the Table list, you double-clicked the Students list item. You double-clicked the LastName field in the Students table, double-clicked the FirstName field in the Students table, double-clicked the Classification field in the Students table, and double-clicked the ResidenceHall field in the Students table. Inside the Add Tables dialog from the Table list, you double-clicked the ResidenceHalls list item. You double-clicked the ResidenceName field in the ResidenceHalls table, double-clicked the FreshmenOnly field in the ResidenceHalls table. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
Use the Simple Query Wizard to create a select query combining fields from two related tables. Include these fields in this order: FacultyLastName, FacultyFirstName, and DeptCode fields from the Faculty table and the LastName, FirstName, and Classification fields from the Students table. Include every record in the results. Select the option to open the query to view information. Name the query Advisors and view the query results.
In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Wizard button. Inside the New Query dialog, you clicked the OK button. Inside the Simple Query Wizard dialog in the Table: Students drop-down, you selected Table: Faculty. Inside the Simple Query Wizard dialog from the Available Fields list, you double-clicked the FacultyLastName list item, double-clicked the FacultyFirstName list item. Inside the Simple Query Wizard dialog in the Table: Students drop-down, you selected Table: Departments. Inside the Simple Query Wizard dialog from the Available Fields list, you selected StudentID, selected StudentID, and double-clicked the DeptCode list item. Inside the Simple Query Wizard dialog in the Table: Students drop-down, you selected Table: Students. Inside the Simple Query Wizard dialog from the Available Fields list, you double-clicked the LastName list item, double-clicked the FirstName list item, and double-clicked the Classification list item. Inside the Simple Query Wizard dialog, you clicked the Next > button, clicked the Next > button, typed Advisors in the What title do you want for your query? input, and clicked the Finish button.
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, clicked the Table1 Tab Header. In the Access Table, you clicked the arrow at the top of the ID column. You clicked the Table Column Filter Right-Click menu, clicked the Table1 Tab Header, and right-clicked the Table1 Tab Header. In the Right Click menu, you clicked the Save menu item. Inside the Save As dialog, you typed Degrees in the Table Name: input, clicked the OK button.
From the current view (Layout view), use the Field List pane to add the following fields to the report: From the Departments table, add the DeptName field. From the Faculty table, add the LastName and FirstName fields.
In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Departments field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Departments list, you dragged the DeptName list item. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Faculty field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Faculty list, you dragged the LastName list item, dragged the FirstName list item.
Add the Status Quick Start fields to the right of the DegreeName field.
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.
From the current view (Layout view), add a title to the form header and change the text to: Review Press Enter when you are finished.
In the Form Layout Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Title button. You updated the header title to Review.
From the current view (Layout view), use the Field List pane to add the LastName field from the Students table to the form.
In the Form Layout Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog, you clicked the Show all tables item. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Students field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Students list, you selected LastName, dragged the LastName list item. You dragged it into the layout view area.
Replace all instances of the first name julie with Julie. Be sure to match the case exactly.
In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Replace button. Inside the Find and Replace dialog, you typed julie in the Find what input, typed Julie 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.
