It would be helpful to readers, and you, if you provided a description of the "business" your database is intended to support.
Start at 30,000 ft and gradually add some details.
Here is a link to
a free, generic data model that involves video rentals that shows a tables, relationships and fields/attributes of a typical rental business. There are several free data models available at
Barry Williams' site.
You can add, remove, ignore parts as required. It is intended only as a starting point to review your setup. You can change or read video as audio to suit your needs.
While a form serves as the user interface, it is the underlying data structure (tables and relationships) that is most critical.
Can you post a jpg of your tables and relationships?
Good luck with your project.