How can I attach the worksheets? Transfer Student Registration Project Descripti

Question

How can I attach the worksheets?

Transfer Student Registration Project Description You were recently hired by your local college to help with registering all transfer students. The coleges Transfer Counseling Department is a one-stop location for transfer students to come with questions. They have been working with Excel spreadsheets generated the Information Technology department, but they are hoping to do more with an Access database. They have had a number of problems, including employees putting information in the wrongfield, putting information in the wrong format, and aeating incorrect formulas They are also hoping for more consistent ways of finding information, as well as being able to generate reports. Your tasks indude importing an existing Excel worksheet as a table into your Access database; modring the table: creating relationship between two tables, aeating queries with calculatedfields, functions, and totals, creating a form for input, and creating a report. Instructions: For the purpose of grading the project you are required to perform the following tasks: Points Start Access. Open the downloaded Access file named exploring acap grader hu aoMege. Import the exploring acap grader LTransfer dsor Excel workbook into a table named Transfer Schools. While importing the data, choose StudentID as the primary key field. Ensure StudentID has a data type of Short Text, Change the StudentID field size to 10 and remove the G symbol from the StudentID format property. aange the Admittingschool field size to 75. Change the and TuitionDue fields 0 decimal Switch to Datasheet View and apply Best Fit to all columns. Sort the table on the CreditsTransferred field in ascending order, then save and close the table. Create a one-to-one relationship between the StudentID fields in the Transfer Students (primary) and Transfer Schools (related) tables. Enforce referential integrity between the two tables. Save the changes and dose the Relationships window. open the Transfer Students Data Entry form. Change the major for Comelius Kavanaughto lementary Education and dose the form Create a new query using Design view. From the Transfer Students table, add the FirstName LastName, Major, Class, and GPA fields, in that order. From the Transfer Schools table, add the AdmissionDate, TuitionDue, CreditsEarned, and CreditsTransferred fields, in that order. 10 Save the query as Transfer Credits. Set the criteria in the AdmissionDate field to 8/1/2015. Run the query. Enter the TuitionDue for Diana Sullivan to $1500 and the GPA for Owen as 3.51, Save the Switch to Design view and save the Transfer Credits query as Transfer Credit Calculations. Remove the criteria from the Adm e field. Create a calculated field in the first empty cell of the query named LostCredits that subtracts CreditsTransferred from Credits arned pdated: 08/23/2013 EXP ACC CAPSTONE Inst structions do

Explanation / Answer

Hii there,this may help you out..

If you need to email a single worksheet out of a workbook, here’s a quicker way to do it instead of saving a copy and deleting what you don’t want to send. Note; This will work only when Outlook is set up on your office computer. Right-click on the tab of the worksheet you want to email. If you want to send more than one worksheet, hold down the Ctrl key & click each one.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.