Excel Exam

Name__________________ Section # __________ Date: _________
To successfully complete the test, the questions MUST be answered in sequence. Use the Excel file My_members.xls tocreate a table in the database created by you called membership.accdb. There should be no primary key.
Section 1 Retrieving Information (5 Points each)
1. How many members from the city of Ziphraare Male?
2. How many members from the state of Iowa are male?
3. List the last name of members from the state of Kansas born before January 1, 1948.
Section 2 Sorting Records (10 Points)1. Sort the table Members ascending by State (primary sort field) and Last Name (secondary sort field). Write down the LastName and FirstName for the last member on your sort.
Section 3 EditingRecords (5 Points each)
1. Change the city to Wichita for the member whose FirstName is William.
2. Change the FirstName to Larry for the member whose LastName is Wilson.
Section 4 Deleting Information1. Delete all members from Iowa born before March 12, 1960. (4 points)
2. Delete all female members from the city of Mission Hill. (8 points)
3. How many records are left in the tableMembers? (3 points)
Section 5 Changing a Table’s Structure (5 Points)
Add a currency field called bonus between Dues and Renewed.
Section 6 Creation of a Table
1. Create a table called Staff thatcontains the following information: (10 Points)
a) Last_N Text with 25 positions (Primary Key Field)
b) First_N Text with 25 positions
c) Date of Hire Short date format
d) Cell_NumberText with 11 positions
Add two relevant fields to this table. (5 Points)
2. Add two records to the Table Staff. (5 Points)
Section 7 Form Creation
Part 1 (15 Points)
Create a form usingthe following fields from the table Staff: First_N, Last_N, Date of Hire Name the form Staff.
Part 2
Add three Command Buttons to the form Staff: Next Record, Previous Record and Delete...