To begin with you need to think about what you are going to use the database for, and maybe who will use it.
What kind of information do I want/have to store?
What kind of information/reports do I want to get from the database?
Then you need to create a database structure. In order to do that you can start with answering the questions below:
What tables should I have? (What data belongs in which table)
What are the relations between the tables?
What are the queries I will ask the database to generate the reports?
Relational Databases for Dummies[
^]
Absolute Beginner's Guide to Database Design[
^]
So far you can use pen and paper to create your structure. It is not really dependent on your choice of database.
As a beginner it is also good to know about database normalization. By following the rules for a good database design, you will spend a lot of time in the beginning, for sure, but much less time later on.
See
1NF, 2NF, 3NF and BCNF in Database Normalization[
^]
To create your database specifically in Access, you can use the following links:
Create an Access database - Access[
^]
How to Make a Database Using MS Access (with Pictures)[
^]
As you have noticed I haven't told you any specifics about your design.
One reason for this is that it is not exactly clear what you want to do.
I think that you will be able to sort it out by reading the links I have provided.
Good luck
Submit an article or tip