In Practice Access 365: Application Capstone Project 1 (Chs. 1-4)
SIMnet Access project instructions
· Excel Projects Help
In Practice Access 365: Application Capstone Project 1 Steps to complete this project:
Mark the steps as checked when you complete them.
1.Open the MagnificentMeals-ACC-ACP-1 database.
2.Enable content in the database.
3.Open the Meals table in Datasheet view. Verify that the table does not contain any records.
Switch to Design view to edit field properties.
4.Change the Data Type of the DateAddedToMenu field to Date/Time.
5.Select a Short Date Format for the DateAddedToMenu field. The Property Update Options smart tag displays when you leave this property.
Hover over the smart tag, click the arrow to display the list of options, and select Update Format everywhere DateAddedToMenu is used. Click Yes in the Update Properties dialog box.
Make the last eight fields (ServingSize through DateAddedToMenu) Required. The other fields already had this property set correctly.
6.Save the table.
7.Create a lookup field by typing a list of values.
8.Click the row selector of the MealType field.
9.Type 20 in the Field Size of the MealType field.
10.Select the Lookup tab.
11.Select the Row Source Type property to Value List. The Property Update Options smart tag displays when you leave this property. Ignore the smart tag as you will make two other changes to this field.
12.Type "Main Course";"Side Dish";"Soup";"Dessert" in the Row Source property. Ignore the Property Update Options smart tag.
13.Set the Limit To List to Yes.
Hover over the Property Update Options smart tag, click the arrow to display the list of options, and select Update all lookup properties everywhere MealType is used. Click Yes in the Update Properties dialog box.
14.Save and close the table.
15.Import data from Excel into the Meals table.
Launch the Get External Data – Excel Spreadsheet dialog box.
16.Locate and select the MenuData.xlsx Excel file.
Append the records to the Meals table.
17.Click OK to launch the Import Spreadsheet Wizard.
Finish the Import Spreadsheet Wizard. Close the Wizard after the records have imported without saving the import steps.
18.Open the Meals table in Datasheet view. Your table should contain 16 records (Figure 1).
Meals table with imported data
Figure 1 Meals table after importing external data
19.Change the layout of the Meals table.
20.Change the Font Size to 12 pt.
Center-align the MenuID field.
21.Use AutoFit to adjust the MealName field to the correct size.
22.Save and close the table.
23.Add a title to a form in Layout view.
24.Open the MealListings form in Layout view.
25.Add a Title control to the Form Header section.
26.Edit the title wording to read Meal Description.
27.Save the form.
28.Edit form controls in Layout view.
29.Open the Property Sheet if necessary.
30.Set the Width property of the DateAddedToMenu text box to 1".
31.Set the Width property of the MenuID text box to .35".
32.Set the Width property of the MealName text box to 7.7".
33.Set the Width property of the Description text box to 4" and the Height property to 1.3".
34.Set the Width property of the MealType combo box to 1.4".
35.Set the Width property of the FoodCategory combo box to 1.4".
36.Set the Width property of the 6-ServingCost text box to .8".
37.Set the Width property of the 3-ServingCost text box to .8".
38.Set the Width property of the ServingSize text box to 1.2".
39.Change the wording of the TotalFat label to Total Fat (g).
40.Change the wording of the Sodium label to Sodium (mg).
41.Change the wording of the Cholesterol label to Cholesterol (mg).
42.Change the wording of the TotalCarbs label to Total Carbs (g).
43.Change the wording of the Protein label to Protein (g).
44.Save the form.
45.Add a new label to the form.
46.Click the Label button [Form Layout Design tab, Controls group] and then click above of the Calories label. A new label is added to the form, but it is added on top of the current MenuID label.
47.Type Nutrition Information Per Serving into the label and press Enter.
48.Apply Bold formatting to the Nutrition Information Per Serving label.
49.Use the arrow keys to move this label above the Calories label and text box. The completed form should be similar to Figure 2.
50.Save the form.
MealListing form completed
Figure 2 MealListings completed form design
51.Edit the form properties to limit user edits and deletes.
52.Select Form in the Selection type.
53.Set the Data Entry, Allow Deletions, and Allow Edits properties to No.
54.Set the Allow Additions property to Yes.
55.Close the Property Sheet.
56.Save the form.
Test the form.
Switch to Form view.
57.Add a new record and enter the following data:
Menu ID 17
Meal Name Chicken Pot Pie Soup
Description Creamy chicken soup with mixed vegetables. Topped with pie crust crumble.
Meal Type Soup
Food Category Classic
3-Serving Cost 17.35
6-Serving Cost 33.00
Serving Size 8 oz
Calories 320
Total Fat 14
Sodium 970
Cholesterol
35
Total Carbs 35
Protein 14
Data Added to Menu 1/30/2026
58.Use the navigation buttons to move back to the first record.
Notice that the Delete button on the Home tab is not enabled.
59.Click in the Meal Name text box. Try to type in that field. Access should not allow you to make any edits.
60.Close the form.
61.Create a query and sort the query results.
62.Create a new query in Design view.
63.Add the Meals table to the query and add the following fields into the query: MenuID, MealName, MealType, FoodCategory, ServingSize, and Calories.
64.Sort the query by the Calories field in ascending order.
65.Save the query as MealsByCategory.
Run the query to confirm it displays the 17 records in ascending order by the Calories field.
66.Edit the query to add a parameter that allows the user to enter the meal type when the query runs.
Switch back to Design view.
67.Type [Enter the Food Category] as the criterion for the FoodCategory field.
68.Save the query.
Test the query to verify that it works. Run the query.
69.Type Purely Plant in the Enter Parameter Value dialog box, and click OK.
70.Verify that the datasheet shows the six records that meet the criteria (Figure 3).
71.Close the query.
Query results using FoodCategory parameter
Figure 3 Query results when Food Category parameter is used
72.Modify the following database properties.
Title: Magnificent Meals Product Database
Author: Student Name
Company: Magnificent Meals
73.Click OK to save the updated properties.
74.Save and close the database.
75.Upload and save your project file.
76.Submit project for grading.