a09c1Cards M9 Assignment: Baseball Trading Cards Access

Capstone Exercise

· MyLab IT Grader

Baseball Trading Cards

You and your partner Stann Dupp have a small business selling baseball cards online through eBay. As the more computer-savvypartner; you created an Access database with records of the cards you have in stock. As it turns out, Stann was attempting to manage the card inventory and ended up modifying crucial aspects of the database that impact the general operation of the database. You will reverse those changes and create other safeguards to protect this from happening in the future. The database tables may already be normalized; however, you will examine the tables to verify.

Restore Database Relationships

You have noticed the existing database has problems with relationships. You will open the database and create the relationships between the tables to make sure data are consistent in the database.

1. Open a09c1Cards and save the database as a09c1Cards_LastFirst.

2. Open each table in the database and look for normalization errors.

3. Open the Relationships window. Notice there are currently no relationships.

4. Add the Cards, Brands, and Rarity tables to the layout. Restore relationships between the Cards, Brands, and Rarity tables via the Brand ID and Rarity ID fields.

5. Set the options to Enforce Referential Integrity and Cascade Update Related Fields for each relationship you create.

6. Save the changes and close the Relationships window.

Analyze Database Performance

It is important to verify that the database performs properly when it is used in a production environment. You will run the Performance Analyzer tool and take note of the recommendations, suggestions, and ideas in the analysis results.

7. Open the Performance Analyzer dialog box, click the All Object Types tab, click Select All, and then click OK.

8. Verify that the first item on the list (an idea) suggests creating an MDE file (which is called ACCDE in Access 2019). You will create an ACCDE file later.

9. Verify the second item on the list (an idea) suggests you change the data type of Year field in the Cards table from Short Text to Long Integer. You decide not to make this change.

10. Close the Performance Analyzer.

Split the Database

You have decided to split the database to enable you and Stann to customize the individual front-end databases while the back end (the tables) remains safe and secure

11. Split the database, accepting the default back-end name a09c1Cards_LastFirst_be. The front-end copy of the database remains open.

12. Look for the linked tables in the front-end copy of the database.

Create a Navigation Form and Hide the Navigation Pane

You will create a Navigation form that displays a new form and the five reports in the database. You will also set the database to hide the Navigation Pane and open the Navigation form whenever the database is opened.

13. Create a new form based on the Cards table using the Form tool.

14. Save the form as Add or Edit Cards.

15. Create a Navigation form based on the Horizontal Tabs template.

16. Drag the new Add or Edit Cards form to the first tab position.

17. Drag the reports to fill the next five tab positions.

18. Switch to Form view and test the Navigation form. Save the Navigation form with the default name and close it.

19. Set the database to open the Navigation form when the database opens and to hide the Navigation Pane.

20. Test the Navigation form by closing and reopening the database.

Encrypt the Database with a Password and Create an ACCDE File

You will encrypt the front-end database with a password. In addition, you will convert the front-end database to the ACCDE file format.

21. Close the database. Reopen the database in exclusive mode.

22. Display the Set Database Password dialog box.

23. Type the database password eXploring!2019 in both dialog boxes and click OK.

24. Close and reopen the database to test the password.

25. Save the database as an Access Database Executable. Save the file with the name a09c1CardsExecutable_LastFirst.

25. Close the database and exit Access. Based on your instructor’s directions, submit the following:

a09c1Cards_LastFirst

a09c1Cards_LastFirst_be

a09c1CardsExecutable_LastFirst