In this project, you will continue to work with the Computer Science Department database from the Chapter 2 Skill Review
2.1. It uses Access to manage employees and various items that are loaned to students and faculty. You will create a variety of forms for entering employee, loan, and item information. This project has been modified for use in SIMnet.
Skills needed to complete this project:
• Creating a Single Record Form Based on a Table or Query
• Creating a Multiple Items Form
• Creating a Split Form
• Creating a Form Using the Form Wizard
• Applying a Theme
• Creating a New Blank Form
• Adding Fields to a Form in Layout View
• Resizing Controls
• Formatting Controls
• Adding Design Elements to Form and Report Headers
1. Open the start file AC2013-SkillReview-3-1.
2. If necessary, enable active content by clicking the Enable Content button in the Message Bar.
3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
4. If necessary, enable active content again.
5. Create a Single Record form using the Employees table as the record source.
a. In the Navigation Pane, select the Employees table.
b. On the Create tab, in the Forms group, click the Form button.
c. Save the form with the name: EmployeesForm
d. Close the form.
6. Create a Multiple Items form using the Employees table as the record source.
a. In the Navigation Pane, select the Employees table.
b. On the Create tab, in the Forms group, click the More Forms button and select Multiple Items from the list.
c. Save the form with the name: EmployeesFormMulti
d. Close the form.
7. Create a Split form using the Employees table as the record source.
a. In the Navigation Pane, select the Employees table.
b. On the Create tab, in the Forms group, click the More Forms button and select Split Form from the list.
c. Save the form with the name: EmployeesFormSplit
d. Close the form.
8. Create a form using the Form Wizard to show items on loan to each employee.
a. On the Create tab, in the Forms group, click the Form Wizard button.
b. In the first step of the wizard, select Table: Employees from the Tables/Queries list box.
c. Double-click the following fields to add them to the Selected Fields box in this order: EmployeeID, LastName, FirstName
d. Expand the Tables/Queries list again and select Table: Loans.
e. Double-click the following fields to add them to the Selected Fields box below the fields from the Employees table: LoanID, ItemID, LoanDate.
f. Click the Next button.
g. Verify that the form will be organized by data in the Employees table as a form with a subform. Click Next.
h. Click the Datasheet radio button to use the Datasheet layout for the subform. Click Next.
i. Enter the following title in the Form box: EmployeeLoansForm
j. Enter the following title in the Subform box: EmployeeLoansSubform
k. Verify that the Open the form to view or enter information radio button is selected.
l. Click the Finish button. Do not close this form.
9. Apply a theme to the form.
a. Switch to Layout view.
b. Click the Form Layout Tools Design tab if it is not already selected.
c. In the Themes group, click the Themes button. Select the Wisp theme.
10. Save and close the form.
11. Create a new blank form in Layout view.
a. On the Create tab, in the Forms group, click the Blank Form button.
b. Save the form with the name: ItemsForm
12. Add controls to the new ItemsForm.
a. If necessary, display the Field List pane. On the Form Layout Tools Design tab, in the Tools group, click the Add Existing Fields button.
b. If necessary, click the Show All Tables link in the Field List pane.
c. Click the + in front of Items.
d. Add the ItemID field to the form by double-clicking ItemID in the Field List pane.
e. Click the ItemName field and drag it to the form to the right of the ItemID control. Pay close attention to the placement guide so you drop the new controls to the right of the ItemID control, not below it.
f. Click and drag the Cost field to the form so it is placed directly below the ItemName field. Make sure the label controls line up in the same column.
g. Click and drag the Description field to the form so it is placed directly below the Cost field. Make sure the label controls line up in the same column.
13. Modify the height of the Description control so the entire description is visible.
a. If necessary, click the Description text box control to select it.
b. Click and drag the bottom boundary of the control downward to make the control taller.
14. Apply a font color to all the labels in the form.
a. Click the ItemID label control to select it. Press Ctrl and click each of the other label controls. All the label controls should be selected.
b. On the Form Layout Tools Format tab, in the Font group, click the Font Color button arrow to view the color palette, and click the theme color Olive Green, Accent 4.
15. Add a title to the form header.
a. On the Form Layout Tools Design tab, in the Header/Footer group, click the Title button.
b. Change the title to: Items
16. Save and close the form.
Step 2 Upload & Save
Step 3 Grade my Project
17. Close the database.
18. Upload and save your file.
19. Submit project for grading.
Attachment:- Assignment.rar