Here is a
link to various articles re Database Planning and Design.
I recommend you spend 30-60 minutes
working through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in the link. You will learn concepts that can be used with any database. You learn by doing the tutorials.
It is also critical to clearly identify your needs. For that, the tutorial video(s) from BA-Experts (also mentioned in the link) will be helpful.
You need to work from 30,000 ft level to some details, and you know the environment better than anyone. Don't be too quick to jump into physical database. Easier to solve an issue/problem when testing a model on paper with some test data than to "fix" a poorly designed physical data structure and related procedures.
Good luck.