Select “Form Wizard” and an input box will pop up. Click on Access’ “Create” tab and then click on the “More Forms” drop down in the Forms section.Attachments – Attachment Format – This allows you to attach pictures or a copy of the actual recipe.Instructions – Text Format – Enter 19 more ingredient lines (Ingredient1, Ingredient2, etc).Quantity – Text – Enter 19 more ingredient lines (quantity1, Quantity2, etc.).Then go back and number the Ingredients (Ingredient1, Ingredient2, etc.) Ingredient – Text Format – Enter 19 more ingredient lines (Ingredient1, Ingredient2, etc) – One tip here is to enter the first line and copy and paste 19 more times. Calories per Serving – Number, set the decimal places at the bottom to 0 decimals.Number of Servings – Number, set the decimal places at the bottom to 1 decimal.Access will ask you to save the table since this table is now linked to the first table. Food Category – Lookup Wizard – Leave want to lookup from table or query checked and click next through each of the input box screens and finally finish.
0 Comments
Leave a Reply. |