Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.
Match with a Tutor
Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.
Get Quality Help
Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.
Office 2013 – myitlab:grader – Instructions
Exploring Series Vol. 2
Paterson Credit Union
Project Description:
You work as a database administrator at the Paterson Credit Union. You are modifying a database to add
validation, lookup fields, and an input mask. You will also modify queries to take advantage of advanced functions
and features.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Points
Possible
Instructions
1
Start Access. Open the file named exploring_a05_grader_a1_Bank.accdb.
0
2
Use Design view to create a new table. Add AccountType as the first field name, with data
type Short Text and field size 10. Ensure AccountType is set as the primary key. Save the
table and name it AccountTypes. Add three records: Platinum, Silver, and Gold. Close the
table.
4
3
Open the Customers table in Design view. Set the PhoneNumber and AccountType fields to
Required. Save the table. Close the table.
6
4
Open the Loans table in Design view. Establish a validation rule for the InterestRate field that
requires the value to be greater than or equal to 2.5 but less than or equal to 10. Create
validation text for the InterestRate: Value must be between 2.5 and 10. Save the table.
Change the InterestRate in the first record to 2. The validation text appears. Press Esc to
restore the original value. Close the Loans table.
8
5
Open the Customers table in Design view. Add a phone number input mask for the
PhoneNumber field, storing the symbols with the data.
16
6
Change the Data Type of the AccountType field to Lookup Wizard. Use the AccountTypes table
for the values in the lookup field, select the AccountType field from the table, accept the
default sort, accept default column widths, and then accept the default name AccountType.
Save the table. Switch to Datasheet view.
8
7
Change the account type to Platinum in the first record and click the second record. Close the
table.
2
8
9
Open the Customer Loans Parameter query in Design view. Add criteria for the Amount field.
The user should be prompted to Enter Minimum Loan Amount. The query should display
all results that greater than or equal to the threshold. Run the query. Enter 400000 when
prompted to Enter Minimum Loan Amount. You should have two results. Save and close the
query.
Open the Missing Addresses query in Design view. Add a new column to determine if a
customer does not have an address on file. If the customer’s Address is null, it should display
Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of
Missing to the column you just created, so only the customers missing an address display.
Move the AddressPresent field so it appears between PhoneNumber and Address. Run the
query. Ensure only customers with null Address fields display. Save and close the query.
Updated: 06/19/2013
1
16
10
A_CH05_EXPV2_A1_Instructions.docx
Office 2013 – myitlab:grader – Instructions
Exploring Series Vol. 2
Step
Instructions
Points
Possible
10
Open the Loans By Interest Rate query in Design view. Create a new column to round the
InterestRate of each Loan to the nearest whole number. Name the field RoundedRate. Save
and close the query.
10
11
12
13
Open the Payment By Month query in Design view. Change the first column so that instead of
grouping by the payment date, you group by the month. Use the DatePart function to extract
the month from the date. Name the column MonthNumber. Group by the MonthNumber
field, and display the Sum of the first Total field and the Average of the Average field. Run the
query. The first line should read 2 (as the month, representing February), with a total of
$5,396.51 as the total payments received and $1,349.13 as the average payment amount.
Save and close the query.
Open the Refinance Candidates query in Design view. This query displays all adjustable loans
in the database. Create a new column to display High Priority for all loans that have an
InterestRate of 7.5% or more, and Low Priority otherwise. Name the field Priority. Run the
query. Notice customers with the highest interest rate values show a higher priority. Save and
close the query.
Save the database. Close the database, and then exit Access. Submit the database as
directed.
Total Points
Updated: 06/19/2013
2
10
10
0
100
A_CH05_EXPV2_A1_Instructions.docx
Purchase answer to see full
attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Would you like to help your fellow students? Are you in need of an additional source of income? Apply to become a tutor on Studypool! Our best tutors earn over $7,500 each month!