Скачать или смотреть AC2021-Capstone-Level3 | AC2021 Capstone Level3 | AC2021 Capstone Level3

Whatsapp: +923177402009
Whatsapp: +923084981394
Email: [email protected]
Whatsapp link: https://wa.me/qr/ALGVOLHWN4M2K1

Instagram link: https://www.instagram.com/alim25431?i...

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more

#AC2021-Capstone-Level3
#AC2021 Capstone Level3
#ac2021-capstone-level3
#ac2021 capstone level3
#AC2021
#Capstone
#level3
#AC2021 Capstone
#AC2021-Capstone
#level3
#capstone-project
#AC2021
#level-3
#final-project
#student-work
#academic-project
#team-project
#research-project

1. Open the start file AC2021-Capstone-Level3.
2. NOTE: 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, and save it.
4. Create a new table from scratch to track sales.
a. The first field should be an AutoNumber field named: SaleID
b. The second field should be a Date & Time field named: SaleDate
c. The third field should be a lookup field. (Hint: Use the Lookup Wizard to create the new field.) It should display the LocationDescription field from the Locations table. Values in the lookup should be sorted by values in the LocationDescription field. Include the LocationID field in the lookup, but do not display it. (Hint: Hide the key column.) Enable data integrity by restricting deletions. Name this field: SaleLocation
d. Save the table with the name: PopcornSales
5. Switch to Design view and modify field properties.
a. Add an input mask to the SaleDate field. Use the Short Date input mask. Do not change any other input mask options.
b. Apply the Short Date format to the SaleDate field.
6. Add a new lookup field as the last field in the PopcornSales table to track payment type. (Hint: Use the Lookup Wizard to create the new field.)
a. Name the field: PaymentType
b. The lookup field should display these values in this order:
c. Cash
Credit Card
Gift Card
Store Credit
d. Limit data entry to values in the list. Do not allow multiple values.
e. Save the table.
7. Switch back to Datasheet view to add sample records to the PopcornSales table.
a. Add three records to the table with the following data. (Hint: Remember, the first field in the table, SaleID, is an AutoNumber field, so there is nothing to enter for each record. Be sure to follow the short date input mask when entering the sale date.)