CIS Access

Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.

Click in the Sort row under the Credits field. Click the arrow to expand the sort options list, and select Descending. On the Query Tools Design tab, in the Results group, click the Run button.

Create a new database from the Students template. Do not change the location. Name the database: Students.

Click the File tab. Click New. Click the Students icon. Type Students in the File Name box. Click the Create button.

Create a backup of the database. You do not need to change the backup location.

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.

From Layout view, change the width of the DeptName column, so the department names do not wrap to two lines (approximately 2.3 inches).

Click the right border of the DeptName column and drag to the right until the entire name Computer Information Systems is visible on one line.

From the current view (Design view), apply the Medium Time format to the StartTime field.

In the Field Properties pane, click in the Format property box. Click the arrow at the right end of the box to expand the list of available formats, and select MediumTime.

Create a Single Record form from the Classes table.

On the Create tab, in the Forms group, click the Form button.

Create a new form based on the Details form application part.

On the Create tab, in the Templates group, click the Application Parts button. In the Blank Forms section, click Details.

From the current view (Layout view), group this report by values in the Classification field.

On the Design tab, in the Grouping & Totals group, click Group & Sort. Click Add a Group. Click Classification.

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.

On the Design tab, in the Tools group, click the Add Existing Fields button. In the Field List pane, click and drag DOB from the list of fields under Students to the right of the LastName controls in the form.On the Design tab, in the Tools group, click the Add Existing Fields button. In the Field List pane, click and drag DOB from the list of fields under Students to the right of the LastName controls in the form.

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.

On the Design tab, in the Tools group, click the Add Existing Fields button. In the Field List pane, click the + in front of Departments. Double-click DeptName. Click the + in front of Faculty. Double-click LastName and then double-click FirstName

Display the Total row in this table and calculate the sum of the values in the Amount field.

On the Home tab, in the Records group, click the Totals button. Click in the Amount column in the Total row. Click the arrow to expand the list of functions and select Sum.

Clear the sorting from this table.

On the Home tab, in the Sort & Filter group, click the Remove Sort button.

Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results

Type ENG in the Criteria row in the DeptCode column. Type CIS in the or row in the DeptCode column (below the Criteria row). On the Query Tools Design tab, in the Results group, click the Run button.

Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.

Type Like "A*" in the Criteria row in the LastName column. On the Query Tools Design tab, in the Results group, click the Run button.