Illustrated Access 365 | Module 5: SAM Project A скачать в хорошем качестве

Illustrated Access 365 | Module 5: SAM Project A

Please contact us if you need this project or any other project in any subject to be completed. Whatsapp: +1-343-321-3276 Email: [email protected] #illustratedaccess365 #TechBuilders Illustrated Access 365 | Module 5: SAM Project A Tech Builders MODIFYING TABLES AND QUERIES PROJECT STEPS 1. You work in the data division of Tech Builders which sells computer and network system hardware to a variety of companies. For high level planning purposes you have created an Access database to track new customers, the hardware modules they have purchased, and the lead representative for each installation. In this project you will improve the tables and queries of the database. In Design View of the Customer table, add three new fields with the following specifications: a. A field named Website with a Hyperlink data type. b. A field named Logo with an Attachment data type. c. A field named Comments with a Long Text data type. d. For the Comments field, use Yes as the value for the Append Only property value. Save the Customer table. 2. While still in Design View of the Customer table, modify the following field properties: a. Enter Customer as the Caption property for the CustomerName field. b. Enter 40 as the Field Size property for the CustomerName field. c. Choose Medium Date as the Format property for the ContractSigned and ProjectStart fields. Save the Customer table. If prompted that some data may be lost, click Yes to continue. (Hint: No data is lost because no values exceed 30 characters in the CustomerName field.) 3. While still in Design View of the Customer table, modify the following field properties: a. Choose Yes as the Required property for the Employees field. b. Enter =1000 as the Validation Rule property for the Employees field. c. Enter 1000 is the minimum for the Validation Text property for the Employees field, and then save the Customer table. If prompted to test data integrity rules, click Yes. 4. While still in Design View of the Customer table, add a new field immediately below the existing fields using the Lookup Wizard and the following information: a. Enter CountryCode as the field name. b. Get the values from the Country table. c. Select both the CountryCode and CountryName fields. d. Sort the records in ascending order by the CountryName field. e. Do not hide the key column. f. Store the CountryCode value, use the other default options of the Lookup Wizard, and save the Customer table as prompted. g. Use Yes for the Column Heads Lookup property for new CountryCode field. Save the Customer table. 5. Switch to Datasheet View of the Customer table, and select CAN (Canada) as the CountryCode value for the ninth record (CustomerID 9 Kaflorp Systems). 6. Switch to Design View of the Customer table and modify these table properties: 7. Switch to Datasheet View of the Customer table, and make the following modifications: 8. In Design View of the Revenue query, complete the following modifications: 9. Create a new query in Query Design View based on the Customer table with the following details: 10. Create a new query in Query Design View with the following details: 11. Use the Find Unmatched Query Wizard to find records in the Representative table that contain no related records in the Customer table using the following details: