Tamia
Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr (without punctuation). Run the query to view the results.
Click the Classification field's criteria row, changed the Classification field's criteria to Sr, clicked the Credits field's criteria row, and changed the Credits field's criteria to >124. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
Enter a validation rule for the table to require values in the DueDate field to be greater than the values in the Date field. Remember to enclose the field names in square brackets.
CorrectIn the Design Ribbon Tab in the Show/Hide Ribbon Group, you clicked the Property Sheet button. Inside the Property Sheet dialog, you clicked the ... button. Inside the Expression Builder dialog, you typed [DueDate]>[Date] in the Expression Default Value Input input, clicked the Ok button.
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 Access Report, you clicked on 10/25/1998(Cell 1-0) in the DOB column. 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 27-Oct-19 Radio Button, selected the 7:38 AM Radio Button, and clicked the OK 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, right-clicked the CourseDescription column header, and 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.
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.
In the Access Table, you clicked on DOB, 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.
From the current view, 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, 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.
From the current view (Design view), apply the Medium Time format to the StartTime field.
In the Access Table, you clicked the Format property box, clicked the Drop-Down Button, and clicked the Medium Time Item.
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, you clicked the dialog Close button. In the Access Table, you clicked in the StartDate Cell, clicked the Input Mask property box, and 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.
From Design view, add a field validation rule to the AccountID field to require that values are less than 2000.
In the Access Table, you clicked the Validation Rule property box, typed <2000 in the Validation Rule property box, and pressed the Enter key.
Add the Status Quick Start fields to the right of the DegreeName field.
In the Access Table, you clicked the arrow at the top of the Description column. You clicked the Table Column Filter Right-Click menu. 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, insert a new Date/Time field named StartDate between the DegreeName and Status fields. Save the table when you are finished.
In the Access Table, you right-clicked the Status cell. In the Right Click menu, you clicked the Insert Rows menu item. In the Access Table, you typed StartDate, typed StartDate and pressed Tab, clicked the Drop-Down Button, clicked the Date/Time Item, typed Date/Time and pressed Enter, clicked in the StartDate Cell, clicked in the StartDate Cell, typed StartDate, typed StartDate and pressed Enter, typed Date/Time and pressed Enter, and typed and pressed Enter. You right-clicked the Degrees Tab Header. In the Right Click menu, you clicked the Save menu item.
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: Courses drop-down, you selected Table: Departments. Inside the Form Wizard dialog from the Available Fields list, you selected DeptName. Inside the Form Wizard dialog, you clicked the > button. Inside the Form Wizard dialog from the Available Fields list, you selected DeptName. Inside the Form Wizard dialog, you clicked the > button. Inside the Form Wizard dialog in the Table: Courses drop-down, you selected Table: Courses. Inside the Form Wizard dialog from the Available Fields list, you selected DeptCode. Inside the Form Wizard dialog, you clicked the > button. Inside the Form Wizard dialog from the Available Fields list, you selected Credits. Inside the Form Wizard dialog, you clicked the > button, clicked the Next > button, clicked the Next > button, clicked the Next > button, and clicked the Finish button.
Create a new table in Design view. Name the first field: RA ID Make the field data type: AutoNumber Add the description: Unique RA ID Set the field as the primary key. Save the table with the Name: ResidentAdvisors
In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button. In the Access Table, you typed RA ID, typed RA ID and pressed Tab, clicked the Drop-Down Button, clicked the AutoNumber Item, clicked in the Unique RA ID Cell, clicked in the AutoNumber Cell, typed AutoNumber and pressed Tab, and dragged the RA ID row. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Primary Key button. You right-clicked the Table1 Tab Header. In the Right Click menu, you clicked the Save menu item. Inside the Save As dialog, you typed Resident Advisors in the Table Name: input, clicked the OK button.
Modify the table relationships so that when a record is updated in the Department table, the related records in the Professor table will also be updated.
In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Edit Relationships button. You clicked the DeptCode option. Inside the Edit Relationships dialog in the Table/Query drop-down, you selected Department. Inside the Edit Relationships dialog, you checked the Cascade Update Related Fields check box, clicked the OK 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 Design Ribbon Tab in the Grouping & Totals Ribbon Group, you clicked the Group & Sort button. You clicked the Add a Group 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. In the Access Report, you clicked a , clicked on Ryan(Cell 3-5) in the First Name column.
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 Bottom of Page [Footer] Radio Button, selected the Page N of M Radio Button, and 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 selected DeptName, clicked the DeptName list item. You clicked the undefined String. 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 clicked the LastName list item. You clicked the undefined String. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Faculty list, you clicked the FirstName list item. You clicked the undefined String.
Use the Field List pane to add the DOB field to the form immediately to the right of the LastName controls. Do not switch views.
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 Students field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Students list, you clicked the DOB list item. You clicked the undefined view.
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 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 double-clicked the LastName list item.
From the current view (Datasheet view), set the Default Value property for the Classification field to Fr.
In 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.
Use the Enter Field Properties dialog to rename the ID field to DegreeName and change the caption to Degree Name. Do not add a description.
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, typed Degree Name in the Caption: input, and clicked the OK button.
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 Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button, clicked the Advanced 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 3 checkbox. 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. In the Access Table, you clicked on Credits, clicked on Department, and 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 3 checkbox, clicked the OK button.
Use Filter by Selection to filter the table to show only records where the student's DOB is 10/25/1998 or later.
In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button. In the Access Table, you clicked in the 10/25/1998 Cell. In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button. In the Selection menu, you clicked the On or After "10/25/1998" menu item.
Switch to the view where you can see live data while modifying the report layout.
In 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.
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 design ribbon tab in the tools ribbon group, you clicked the property sheet button. Inside the property sheet dialog you typed 2.3 in the width box, pressed the Enter key
Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
You changed the LastName field's criteria to Like "A*". In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
Modify this query to show only students who are freshmen. Add criteria to the Classification field to return only records where the classification is Fr. Run the query.
You clicked the Classification field's criteria row, changed the Classification field's criteria to FR. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
You clicked the Credits field's criteria row, changed the Credits field's criteria to >120. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.
You clicked the Credits field's criteria row, changed the Credits field's criteria to >124, clicked the Classification field's criteria row, and changed the Classification field's criteria to Sr. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
Modify this query so the DeptCode field is hidden in the query results, and then run the query.
You clicked the DeptCode column's Show box. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
Add a new calculated field named Tuition in the first empty column to the right of the Credits field. The new field should calculate the value in the Credits field multiplied by 150. Run the query to view the results.
You clicked the Drop-Down Menu, right-clicked the Drop-Down Menu. In the Right-Click menu, you clicked the Zoom... menu item. Inside the Zoom dialog, you typed Tuition:[Credits]*150 in the Zoom Value Input input, clicked the Query Zoom Ok Button button. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
Change the Navigation Pane grouping option so all database objects of the same type are grouped together (all tables together, all forms together, etc.)
You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Object Type menu item.
Insert a new row into the form layout above the TuitionPaid and GPA controls.
You clicked the TuitionPaid control. In the Arrange Ribbon Tab in the Rows & Columns Ribbon Group, you clicked the Select Row button, clicked the Insert Above button.
Move the TuitionPaid label control and its bound control to the layout area directly below the FirstName controls.
click the tuition paid label, press ctrl and then click bound control, then drag it directly below the firstname controls.
Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance
n the Access Table, you clicked on Department, right-clicked the Department column header, clicked on Department, and 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.
n the Access Table, you right-clicked the DOB column header. In the Right Click Menu menu, you clicked the Sort Newest to Oldest menu item.
Create a Split form from the Classes table.
select the table in the Navigation Pane, tap or click CREATE on the ribbon, tap or click the more forms button on the CREATE tab to display a menu, and then tap or click Split Form on the menu.
Add a new record to the table with the student ID 6412 and advance to the second field.
tIn the Home Ribbon Tab in the Records Ribbon Group, you clicked the New button. In the Access Table, you typed 6412, typed 6412 and pressed Tab.
