Homework answers / question archive / 1)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

1)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

Business

Share With

---

1)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.                                            

               

2 Delete the Description field.

               

3 Preview how this report will look when printed.

               

4 Open the Navigation Pane.

               

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

               

6 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.

               

7 Use the Report Wizard to create a new report. Include fields in this order: DeptName from the Departments table, CourseNumber and CourseDescription from the Courses table, and ClassCode and Time from the Classes table. View the report data by the Departments table. Add grouping by CourseNumber. Sort records by the Time field. Use the Stepped layout and Portrait orientation. Name the report CoursesByDepartment and allow Access to display the report in Print Preview view when you finish.

               

8 Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.

 

9 From Design view, modify the Gender field to use a lookup list with Male and Female in a single column. Limit the field to values in the list only.

 

10vDelete the Major field from the table.

 

11 Clear the sorting from this table.

 

12 Replace all instances of the first name julie with Julie. Be sure to match the case exactly.

 

13 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. Do not switch views.

 

14 Add a new record to the table with the student ID 6412 and advance to the second field.

 

15 From Layout view, group this report by values in the Classification field.

16 Go to the first record.

 

17 Use the Search box to begin searching for a student with the last name beginning with Car.

 

18 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: Resident Advisors

 

19 Close the Navigation Pane.

               

20 Add a new Short Text field to the far right side of the table. Name the field: Description

 

21 From Design view, apply the Medium Time format to the StartTime field.

 

22 Set the Default Value property for the Classification field to Fr.

 

23 Create a new blank desktop database named Accounting.

 

24 Insert a new Date/Time field named StartDate between the DegreeName and Status fields. Save the table when you are finished.

 

25 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.