Create a query that finds all of the history majors

Assignment Help Basic Computer Science

Reference no: EM131087527

Preparing the data for use in Access

• Import the file 'Students Last & First Names Combined'
• The last and first names must be separated into thier own fields. Use Excel for this
• Save the new table make sure the FORMAT is 'Unicode Text'
• YOU WILL USE THIS NEW TABLE IN THE NEXT EXERCISE

Creating a query

Open Microsoft Access

• Create a query that finds all of the History majors with a GPA greater than or equl to 3.5. Include in this query the following fields in the given order: last name, first name, major, & GPA
• Create relationships
• Create a report that includes in this order last name, first name, major, GPA

Creating a Custom Report to Turn In

• Create a report on the History query from above
• Make the report look nice by putting the fields closer together so they are easier to read
• At the top of the report in the header create a text box and put "History Majors"
• Make the report look nice and make sure it fits on the portrait page format. You can have multiple pages but do not go off the side of the page
• Title the report "Homework 9 Report"
• Remove the time field in the header
• In the header create a text box with 'History Average GPA ___" calculated from above
• Save the report as "Homework 9"
• Export the report in the 'Word/RTF' format
• The report is what you will turn in.

Reference no: EM131087527

Questions Cloud

Why is the second slightly more efficient : Why is the second slightly more efficient?

Explore how the profit rate changes : explore how the profit rate changes.

Calculate the number of milligram : The absorbance was found to be 0.30. Using your calibration curve, calculate the number of milligram of Cu2+ in 1.0L of wastewater.

Create a file that can be used with big memory : create a file that can be used with big memory

Create a query that finds all of the history majors : Create a query that finds all of the History majors with a GPA greater than or equl to 3.5. Include in this query the following fields in the given order: last name, first name, major, & GPA.

Apportioned into four regional tournaments : The NCAA basketball tournament begins with 64 teams that are apportioned into four regional tournaments, each involving 16 teams. The 16 teams in each region are then ranked (seeded) from 1 to 16. During the 12-year period from 1991 to 2002, the ..

Conjugate acid of a strong base : Considering how the conjugate base of a strong acid has no measurable strength, does that mean that the conjugate acid of a strong base has no measurable strength as well?

The proportion of successes in a particular population : Let p1 denote the proportion of successes in a particular population. The test statistic value in Chapter 8 for test

Write down a system of two first order ode : Math 164 - Quiz two State carefully a theorem that guarantees that Newton's method will converge to a zero of a real valued function of one real variable and write down a system of two first order ODE that has precisely two equilibrium solutions.

User Account

All Pages