Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / EXAM 2  BUSI 201          ACESS  CH  1 - 4 1) Apply the Ion Boardroom theme without changing the view

EXAM 2  BUSI 201          ACESS  CH  1 - 4 1) Apply the Ion Boardroom theme without changing the view

Business

EXAM 2  BUSI 201          ACESS  CH  1 - 4

1)

Apply the Ion Boardroom theme without changing the view.

   

2

From Design view, change the Field Size property for the Classification field to 4.

   

3

Apply the Short Date input mask format to the selected field (DOB). Do not change default format or placeholder characters.

   

4

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

   

5

Export the StudentGPA query to Excel, maintaining all data formatting and layouts. You do not need to change the location of the saved file or save the export steps.

   

6

Modify this query so the DeptName field is hidden in the query results, and then run the query.

   

7

Create a new blank report that will open in Design view.

   

8

Enable active content in this database.

   

9

Insert a new Date/Time field named StartDate above the Gender field. Save the table when you are finished.

   

10

From Datasheet view, add a new field the far right of the table to store a picture for each resident advisor.

   

11

Add the picture Patrick to the second record.

   

12

Switch to the view where you can see live data while modifying the report layout.

   

13

Limit the query results to records where the student's GPA is greater than 3.5. Run the query to view the results.

   

14

Start a new query without using one of the query wizards.

   

15

From Layout view, group this report by values in the StartTime field. Change the grouping to group by the entire value instead of by quarter.

   

16

Create a new query in Design view using the following fields in this order: From the Student table, add the LastName, FirstName, Classification, and ResidenceHall fields. From the ResidenceHalls table, add the ResidenceName and FreshmenOnly fields. Run the query.

   

17

Create a parameter query where the user will enter a value to use as the criterion for the DeptCode field. Use the prompt Enter Department Code. Run the query using the Department Code FIN.

   

18

Find the first record with Goulet in the LastName field.

   

19

Add criteria to this query to return only the records where the value in the Credits field is >120 or the value in the Classification field is Sr. Run the query to view the results.

   

20

Run the Compact & Repair tool to optimize database efficiency by compacting unused space and deleting unnecessary temporary objects.

   

21

Set the sort order so the results will display records with the highest GPA first. Run the query and review the results. On the Query Tools Design tab, in the Results group, click the Run button.

   

22

Switch to the view where you can modify the structure of the report without viewing any live data.

   

23

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

   

24

Add criteria to this query to return only the records where the value in the GPA field is <2.5 and the value in the Classification field is Sr. Run the query to view the results.

   

25

From Datasheet view, rename the Field1 field to: ResidenceName

   

26

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.

   

27

Delete this student record.

   

28

Use Filter by Selection to filter the table to show only records where the student's DOB is on or after 9/3/1992.

   

29

Export the ClassReport report to a PDF file. You do not need to change the location of the saved file or save the export steps.

   

30

Use the Form Wizard to create a new form. Include these fields in this order: DeptCode and DeptName fields from the Department table and CourseNumber and CourseDescription fields from the Course table. Organize the form by Department with data from the Course 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.

   

31

Use the Report Wizard to create a new report. Include fields in this order: DeptName from the Department table, CourseNumber and CourseDescription from the Course table, and ClassCode and Time from the Class table. View the report data by the Department 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.

   

32

From Layout view, add the date and time to the report header using the date format similar to 31-May-2013 and the time format similar to 1:12 PM.

   

 

 

33

 

 

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

 

 

 

34

From Datasheet view, apply the Medium Date format to the StartDate field.

   

35

From Datasheet view, add a new field the far right of the table to store a picture for each resident advisor. Add the picture Justin to the first record.

   

36

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. Run the query to view the results.

   

37

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.

   

38

Move the LastName control and its label control to the layout area directly above the GPA controls.

   

39

Go to the last record.

   

40

Create a Split form from the Class table.

   

41

Apply the Blue, Accent 5 font color to the selected controls.

   

42

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

   

43

Use the Field List pane to add the FirstName field to the form immediately below the LastName controls. Do not switch views.

   

45

Open the Navigation Pane.

   

45

Add the Professor table to the Relationships window.

   

 

 

 

Option 1

Low Cost Option
Download this past answer in few clicks

3.83 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 6 times

Completion Status 100%

Sitejabber (5.0)

BBC (5.0)

Trustpilot (4.8)

Google (5.0)