a.The information is for the employees of the Marcia Felix Corporation. Use MS-Access package to create a database for it.

a. What record structure did you design? Identify the names, widths, and other characteristics

of each field in a typical record.

b. Sort these employees by department. Print this list.

c. Sort these employees by test score. Print this list.

d. Sort these employees by department and alphabetically by last name within department.

e. What is the average pay rate for these employees?

f. What is the average pay rate for females? What is the average for males?

g. What females scored over 70 on their examinations? What males scored over 50?a.The information in Figure 4-20 (see book Page#131) is for the employees of the Marcia Felix Corporation. Use MS-Access package to create a database for it.

a. What record structure did you design? Identify the names, widths, and other characteristics

of each field in a typical record.

b. Sort these employees by department. Print this list.

c. Sort these employees by test score. Print this list.

d. Sort these employees by department and alphabetically by last name within department.

e. What is the average pay rate for these employees?

f. What is the average pay rate for females? What is the average for males?

g. What females scored over 70 on their examinations? What males scored over 50?a.The information in Figure 4-20 (see book Page#131) is for the employees of the Marcia Felix Corporation. Use MS-Access package to create a database for it.

a. What record structure did you design? Identify the names, widths, and other characteristics

of each field in a typical record.

b. Sort these employees by department. Print this list.

c. Sort these employees by test score. Print this list.

d. Sort these employees by department and alphabetically by last name within department.

e. What is the average pay rate for these employees?

f. What is the average pay rate for females? What is the average for males?

g. What females scored over 70 on their examinations? What males scored over 50?a.The information in Figure 4-20 (see book Page#131) is for the employees of the Marcia Felix Corporation. Use MS-Access package to create a database for it.

a. What record structure did you design? Identify the names, widths, and other characteristics

of each field in a typical record.

b. Sort these employees by department. Print this list.

c. Sort these employees by test score. Print this list.

d. Sort these employees by department and alphabetically by last name within department.

e. What is the average pay rate for these employees?

f. What is the average pay rate for females? What is the average for males?

g. What females scored over 70 on their examinations? What males scored over 50?