access 4.1

Skill Review 4.1

In this project, you will work with a Computer Science department database. 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.

Skills needed to complete this project:

• Creating a Single Record Form Based on a Table or Query (Skill 4.1)
• Creating a Multiple Items Form (Skill 4.2)
• Creating a Split Form (Skill 4.3)
• Creating a Form Using the Form Wizard (Skill 4.4)
• Applying a Theme (Skill 4.12)
• Creating a New Blank Form in Layout View (Skill 4.5)
• Adding Fields to a Form in Layout View (Skill 4.6)
• Resizing Controls (Skill 4.13)
• Modifying the Layout of a Form or Report (Skill 4.15)
• Formatting Controls (Skill 4.11)
• Adding Design Elements to Form and Report Headers (Skill 4.16)

Steps to complete this project:

Mark the steps as checked when you complete them.

1. Open the start file AC2021-SkillReview-4-1.
2. If the database opens in Protected View, click the Enable Content button in the Message Bar at the top of the database so you can modify it.
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. Create a Single Record form using the Staff table as the record source.In the Navigation Pane, select the Staff table.On the Create tab, in the Forms group, click the Form button.Save the form with the name: StaffFormClose the form.
5. Create a Multiple Items form using the Staff table as the record source.In the Navigation Pane, select the Staff table if it is not already selected.On the Create tab, in the Forms group, click the More Forms button and select Multiple Items from the list.Save the form with the name: StaffMultipleItemsFormClose the form.
6. Create a Split form using the Staff table as the record source.In the Navigation Pane, select the Staff table if it is not already selected.On the Create tab, in the Forms group, click the More Forms button and select Split Form from the list.Save the form with the name: StaffMultiViewFormClose the form.
7. Create a form using the Form Wizard to show items on loan to each employee.On the Create tab, in the Forms group, click the Form Wizard button.In the first step of the wizard, verify that Table: Staff is selected from the Tables/Queries list.Double-click the following fields to add them to the Selected Fields box in this order: EmployeeID, LastName, FirstNameExpand the Tables/Queries list and select Table: Loans.Double-click the following fields to add them to the Selected Fields box below the fields from the Staff table: LoanID, Item, LoanDateClick the Next button.Verify that the form will be organized by data in the Staff table as a form with a subform. Click Next.Verify that the Datasheet radio button is selected to use the Datasheet layout for the subform. Click Next.Enter the following title in the Form box: LoansToStaffFormEnter the following title in the Subform box: LoansDatasheetSubformVerify that the Open the form to view or enter information radio button is selected.Click the Finish button. Do not close this form.
8. Apply a theme to the database.Switch to Layout view.Click the Form Layout Design tab if it is not already selected.In the Themes group, click the Themes button. Select the Gallery theme. IMPORTANT: Due to a Microsoft Access bug, double check the application of the Gallery theme before submitting your file. You will need to close the database and then reopen it. Open the database object and reapply the theme.Save and close the form.
9. Create a new blank form in Layout view.On the Create tab, in the Forms group, click the Blank Form button.Save the form with the name: ItemInventoryForm
10. Add controls to the new ItemInventoryForm form.If necessary, display the Field List pane. On the Form Layout Design tab, in the Tools group, click the Add Existing Fields button.If necessary, click the Show All Tables link in the Field List pane.Click the + in front of Items.Add the ItemID field to the form by double-clicking ItemID in the Field List pane.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.Click and drag the ItemCost field to the form so it is placed directly below the ItemName field. Make sure the label controls line up in the same column. Hint: If you make a mistake, press Ctrl + Z to undo, and then try again.Click and drag the Description field to the form so it is placed directly below the ItemCost field. Make sure the label controls line up in the same column.
11. Modify the width of the ItemID bound text control.Click the ItemID bound text control to select it.Click and drag the right border to the left to make the control smaller. The control should be just large enough so the entire ACC1 is visible.
12. Increase the padding between all the controls in the form detail section.On the Arrange tab, in the Rows & Columns group, click the Select Layout button to select all the controls in the detail section at once.On the Arrange tab, in the Position group, click the Control Padding button and select Medium.
13. Apply a font color to all the labels in the form.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.On the Format tab, in the Font group, click the Font Color button arrow to view the color palette, and click the standard color Blue (the third color from the right in the last row of standard colors).
14. Add a title to the form header.On the Form Layout Design tab, in the Header/Footer group, click the Title button.Change the title to: Current InventorySave and close the form.
15. Close the database and exit Access. IMPORTANT: Due to a Microsoft Access bug, double check the application of the Gallery theme before submitting your file. You will need to close the database and then reopen it. Open the appropriate database object and reapply the theme. See step 8c.
16. Upload and save the project file.
17. Submit project for grading.