Welcome to P2P, Jett.
I break up Access into three parts whenever someone at work asks me: 1) structure, 2) cosmetic, 3) functional.
Structural has to do with how to make proper data tables and follow the rules for normalization, naming conventions, setting data types, what to store vs. what NOT to store (e.g. calculated values), creating form/subform combinations, creating report/subreport combinations.
Cosmetic has do with how the forms and report will look and how to make them visually pleasing, how to abide by the Americans with Disabilities Act (ADA), conventions on 800x600 vs. finer screen resolutions (see ADA), etc.
Functional has to do with constructing queries properly so they do what you want; and the big one is how to do Visual Basic for Applications (VBA) programming behind the forms and report that actually DO something when you click or button or change a value somewhere.
Years ago, our office tended to have training classes on the first two, but it wasn't until a few of begged did they get the vendor to set up a two-day extensive VBA class. A form/report is useless unless it DOES something.
You need to get a good handle on all these concepts before you make anything meaningful and that functions properly.
Michigan Dept. of Environmental Quality, Air Quality Division