During my working experience, I’ve had the opportunity for developing and designing a few databases for my work unit. I think that databases are great for tracking, reporting and presentations purposes because they allow users to create and automate reports in a daily, weekly or monthly basis.
In order to create a database, first we will need to create a table with the information that we want to work with, the table contains columns and rows (as an excel sheet) that will assist users to input the data needed for the software.
Second, once we have created several tables with the information needed, we will need to create relationships in order to link tables together and also to ensure data integrity. This part can be complicated because there are different types of relationships that a user can apply in MS Access. The most common ones are “One to Many” and “Many to Many”, these two relationships allow users to relate data from different tables in order to link information together.
Third, create queries, this step is also a little complex because in order to create queries we need to know the structure of the database and what kind of data we would like to connect or show to users.
Finally, we will need to create forms; the forms that you create will need to look friendly to users. In other words, the form will need to look nice and simple so that users can find it attractive an easy to input data in the system.
You can also create reports, modules, macros, or even apply some codes through Visual Basis Studio. But that would need a little more that this blog to explain and understand this computer language. I have attached a Youtube Video that would help you to understand this in further.
http://www.youtube.com/watch?v=BLIn1UHkee0