Access Practice 4
Here is a video demonstrating the skills in this practice. Please note it does not exactly match the instructions:
Complete the following Practice Activity and submit your completed project.
For Access Practice 4, we will continue to work with the same database that manages student and faculty data in the Honors program at South Puget Sound Community College. For this practice, we will focus on creating Forms for the database. The Forms we create will be used to enter Faculty and Student data into the database.
- Open Access, under open, select the database Lastname_Firstname_Access_Practice3. You may need to browse to the location where you saved this database. In backstage view, select Save As, and save the database as Lastname_Firstname_Access_Practice4. Ensure the database is saved on your Access folder.
- If necessary, select Enable Content to show all of the database content.
- Ensure the navigation pane is open, and all database objects are displayed.
- On the Create tab, in the Forms grouping, notice there are several options to create a Form.
- Form
- Form Design
- Blank Form
- Form Wizard
- In the navigation select but do not open the Faculty table. On the Create tab, in the Forms group, click Form.
- Notice how a new form, named Faculty is created with all of the fields from the Faculty table. This is the quickest and easiest way to create a Form. Notice the Form Layout tools tab, with three sub-tabs: Design, Arrange and Format. On the Design tab, in the Views Group, select the arrow under View and select Form View.
- Near the bottom of the page where the record count and scroll displays, select the icon to add a new record. Enter in data for the Faculty ID, Last Name, First Name, E-Mail and Division. You can make up any data for this. Save and close the Faculty Form.
- In the navigation pane, double click the Faculty form to open it. Notice that it opens in Form View. Near the bottom of the page, use the arrows to scroll through the records to find the record you just added.
- On the Home tab, in the Views Group, change the view to Layout View. Notice how the Form Layout Tool bar appears. On the Design tab, in the Themes group, select Themes. Select the Office theme, and then change the colors to Blue. Under Fonts, change the Font to Arial.
- Select the label in the form titled Division. This is an Unbound Label. On the Arrange tab, in the Move group, select Move Up one time. Notice how the Division label moves above the E-Mail.
- Select the Text Box that was next to the Division Label. It should say ‘Business’. This is a bound control text box. Select Move Up one time to move this bound control next to the Division Label.
- Next to the Faculty ID Label, select the text box that displays 1. On the Form Layout Tools tab, under Design, in the Tools group, select Property Sheet. The Property Sheet will open on the right hand side of your screen.
- Notice how the selection type shows Text Box. On the Data Tab, under Control Source, Faculty ID displays that represents the Faculty Table.
- On the Format tab, in the Property Sheet, ensure the Format displays as General Number. Close the Property Sheet.
- Save and Close the Faculty Form. If prompted, save changes to both the Form and the Table.
- On the Create tab, in the Forms group, select Form Wizard. In the Form Wizard dialog box under Tables/Queries ensure the Table: Students displays. Select all fields from the Students table by clicking the double arrows to move the Available Fields to the Selected Fields. Select Next.
- Select the Columnar Format for the form and select Next.
- Ensure the title of your form is Students, and then open the form to view or enter information. Select Finish.
- Notice that the Students form opens in Form View. Use the Search function, or scroll through the records in the form to find StudentID 15037, Emily Martinez. In the Last Name field, change her last name to Bezos. Change the Graduation Year from 2021 to 2020, and check the scholarship box to indicate, Yes, this student has a scholarship.
- On the Home Tab, in the Views Group, change the View of the Students table to Design View. Notice the toolbar Form Design Tools displays, with three tabs: Design, Arrange and Format. On the Design tab, select the Office theme, and change the colors to Blue.
- In design View, there are several Form sections. Take a moment to view the following sections of the form:
- Form Header
- Detail
- Form Footer
- On the Format Design Tools, Design tab, under Controls, select the arrow next to Insert Image and select Browse. Navigate to where your data files are stored, and insert the image titled Access_Practice_4. Insert the image into the form header.
- In the Form Header, select the label that says Students. You can delete it by first selecting the label, and then pressing the Delete key on your keyboard. You can also right click on the label, and then select Delete.
- Center the Image in the form header. Use the ruler at the top of the page to help guide you as you center the image within the form header.
- Change the view of the form to Form View, and view the changes you made. Then, change the form to layout view.
- In layout view, on the Form Layout Tools, Design tab, in the Header/Footer group, select Data and Time. In the Data and Time dialog box, if necessary, check the box for Include Data and Include Time, and choose the first option under both. Select OK. Notice how the current Date and Time displays in the upper right hand corner of the form.
- Change the view of the Students Form to Design View. On the Format Design Tools, Design tab, in the Tools group, turn on the Property Sheet.
- Select the Scholarship Label. Change the text of the label to read Scholarship Awarded? And resize the label if necessary. To precisely change the height and width of the label, use the Property Sheet, Format tab to type in the Width and the Height.
- Select the Email label, and change the text to read E-Mail Address. Resize the label if necessary to ensure all of the data is visible.
- Click the line below the Form Footer and drag down to create space in the Form Footer. You will only need to add about an inch of space.
- On the Form Design Tools toolbar, on the Design Tab, in the controls group, select Label. Click or Draw to add a label in the Form Footer. Inside the Label type PVCC Pumas. Click to select the label, right click inside the label and choose any fill color, and then select any Font/Fore color.
- Save and Close the Students Form. Ensure all database objects are closed and the Navigation Pane is open and displays All Access Objects.
- Take a moment to verify you have the following database objects in your database.
- Tables:
- Faculty
- Students
- Queries:
- Health Sciences Students
- Honors Program Faculty and Students
- Honors Student List
- Scholarships Awarded
- Students Missing Field of Interest
- Forms:
- Faculty
- Students
- Tables:
- To exit out of the database, first close any database objects that are open. Select the File tab, and take note of where your database is saved. Then select close. Then, exit out of Access.
- Submit your entire database for grading per your instructor’s instructions.