Troubleshooting

Practice with troubleshooting

If you haven’t yet watched it,

open the lesson video⁠

in a new tab. Then, follow the steps below to put that learning into action.

Using your table from

Translating from a spreadsheet⁠

(or the answer tables

HERE⁠

), complete and consider the following:

Run the Update troubleshooting test—is there an issue with updating information?

Do you have to update the same information in multiple places?

Would a relation help?

Test the Insert troubleshooting—is there an issue with adding new information?

Could issues be solved with a relation?

Would blank/isnotblank help?

Do we have a correct hierarchy?

Troubleshoot for Delete issues—when you delete something does everything work as intended?

Could issues be solved with a relation?

Would archiving be a better choice than deleting?

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.