Reference no: EM131057242
National Residence Life Conference
Project Description:
Your boss asked you to prepare a schedule for each speaker for the national conference being hosted next year on your campus. She wants to mail the schedules to the speakers so that they can provide feedback on the schedule prior to its publication. You assure her that you can accomplish this task with Access.
Instructions:
1 Start Access. Open the file named exploring_a04_grader_h1.accdb. Save the database as exploring_a04_grader_h1_LastFirst.
2 Select the Speakers table as the record source for a form. Use the Form tool to create a new stacked form.
3 Change the title in the form header toEnter/Edit Speakers. Reduce the width of the text box controls to approximately half of their original size.
4 Delete the Sessions subform. View the form and data in Form view. Sort the records by LastName in Ascending order. Save the form as Edit Speakers. Close the form.
5 Open the Room Information form in Layout view. The form does not have a Form Layout. Select all controls and apply the Stacked Layout. Save and close the form.
6 Select the Speaker and Room Schedule query as the record source for a report. Activate the Report Wizard and use the following options as you go through the Wizard.
Select all of the available fields for the report. View the data by Speakers. Verify that LastName and FirstName will provide grouping levels. Use Date as the primary sort field, in Ascending order.
Accept the Stepped and Portrait options. Save the report as Speaker Schedule.
7 Switch to Layout view and apply the Organic theme to only this report. Save and close the report.
8 Open the Speaker and Room Schedule query in Design view. Add the StartingTime field in the Sessions table to the design grid, after the Date field. Run the query. Save and close the query.
9 Click the Speaker and Room Schedule query. Start the Report Wizard again and use the following options. Select all of the available fields for the report. View the data by Speakers.
Use the LastName, FirstName fields as the primary grouping level. Use Date as the primary sort field, in Ascending order. Use StartingTime as the secondary sort field in Ascending order.
Select the Stepped and Landscape options. Name the report Speaker Schedule Revised.
10 Switch to Layout view, and then apply the Facet theme to only this report.
11 Add a space to the column heading labels as needed. For example, change RoomID to Room ID. Save and close the report.
12 Close the database, and submit based on your instructor's directions.
Attachment:- exploring_a04_grader_h1.accdb
|
Calculating the degrees celsius
: Show all steps in full and be sure to put the right unit. 1) How many moles of Ar gas are in a 50.0 L tank at 20.4 degrees celsius and 759.1 torr?
|
|
Current investments after inflation
: MTM Ltd. wants to earn 14.25 percent on its current investments after inflation. Inflation is expected to average 2.8 percent over the next 5 years. What discount rate should MTM assign to a 5-year project assuming the project has the same level of r..
|
|
Two investments have the same net present value
: The following two investments have the same net present value at i=6.0% 1) Invest 10,000 now and receive 6,000 in two years and $8,000 in 4 years. 2) Invest 5,000 now and receive 3,000 in one year and X in 2 years. Find X
|
|
The negative amortization of discount in period
: a three year $1,000 par bond has a coupon rate of 6% convertible semiannually. It is sold at a yield of 7% convertible semiannually. Find a) the price of the bond. b) the amount of discount. c) the negative amortization of discount in period 5.
|
|
Prepare a schedule for each speaker for national conference
: Your boss asked you to prepare a schedule for each speaker for the national conference being hosted next year on your campus.
|
|
Compute the expected return on the portfolio
: A porfolio consists of 75% invested in Security A with an expected return of 35% and 25% invested in Security B with an expected return of 7%. Compute the expected return on the portfolio.
|
|
According to the dividend discount model-stock price
: You expect Budweiser will pay dividends of 1.75 in one year, 2.25 in two years, and 2.75 in three years. From that point onwards, dividends will grow at 6% per year. Investors' required rate of return is 11%. According to the Dividend Discount Model,..
|
|
A strategic plan to involve school-family-community
: Research indicates that high quality academic, civic and social outcomes occur when service learning is incorporated into a school's curricula. Why do you think this occurs? Have you ever been involved in service learning at your school? Relate ..
|
|
Determine the power required to drive the compressor
: The air entering the impeller of a centrifugal compressor has an absolute axial velocity of 100 m/s. At rotor exit the relative air angle measured from the radial direction is 26°36' the radial component of velocity is 120 m/s, and the tip speed o..
|