Santa Monica College Access Chapter 1 Project

Having Trouble Meeting Your Deadline?

Get your assignment on Santa Monica College Access Chapter 1 Project  completed on time. avoid delay and – ORDER NOW

Do My Paper

kills needed to complete this

project:

• Introduction to Access (Skill 1.1)
• Working with Security Warnings (Skill 1.2)
• Organizing Objects in the Navigation Pane (Skill 1.4)
• Understanding and Viewing Table Relationships (Skill 1.3)
• Navigating Records (Skill 1.6)
• Creating a New Record in a Table and Entering Data (Skill 1.7)
• Finding and Replacing Data (Skill 1.12)
• Deleting Records (Skill 1.13)
• Adjusting Table Column Widths (Skill 1.9)
• Sorting Records in a Datasheet (Skill 1.8)
• Creating a New Record in a Form and Entering Data (Skill 1.10)
• Deleting and Renaming Database Objects (Skill 1.14)
• Using Compact and Repair (Skill 1.20)

1. Open the start file AC2019-ChallengeYourself-1-4.
2. If necessary, enable active content by clicking the Enable Contentbutton in the Message Bar.
3. The file will be renamed automatically to include yourname. Change the project file name if directed to do so by your instructor.
4. Change the organization of the Navigation Pane to use the Tables and RelatedViews category.
5. Open the Relationships window and show the Vaccines table. Save the changes tothe layout, and then close the Relationships window.
6. Open the Vaccines table and browse the records using the record navigationbuttons and keyboard shortcuts.
7. Enter the following record into the table. Note that the TargetAudience fieldis a lookup field.

1. Find the record with the value TD in the VaccineID field and change the value of the TargetAudience field from Adults to Teenagers.
2. Find and delete the record with a VaccineID of JE.
3. Change the width of the VaccineName column to exactly 28.
4. Sort the records in the table alphabetically from A to Z by values in the VaccineName field.
5. Save and close the table.
6. Open the VaccinesForm form and enter the following as a new record:

1. Close the VaccinesForm form.
2. Open the Locations table and use the Replace command to replace all instances of Angola with: Republic of Angola
3. AutoFit the width of the Country column so all the names are visible.
4. AutoFit the width of the City column so all the names are visible.
5. Sort the records so they are sorted by values in the Country field alphabetically from A to Z and then by values in the City field alphabetically from A to Z. Hint: Remember to sort the innermost sort first.
6. Save and close the table.
7. In the Navigation Pane, rename the Shipments form to: ShipmentsForm
8. Observe the file size of your database. Use the Compact and Repair Database command and check the file again. How much did the file size decrease?
9. Close the database and exit Access.
10. Upload and save your project file.
11. Submit project for grading.