Microsoft Access Tutorial - How to create a database
Building a database isn't as hard as it first seems. Listed below is a series of tutorials that will visually demonstrate how to build a database from scratch using Microsoft Access. They are highly recommended for beginners to help them off to a quick start.
Step 1: Planning your database
The first step to making a database is to firstly plan one. This important step is often overlooked by eager beginners wanting to jump right in the deep end. However, without a clear plan, your database might end up a jumbled mess. Planning your project on paper will save you much frustration and dissapointment over the long run.
The tutorial below will talk you through how to go about planning your database project. Press the go arrow to start the video.
Step 2: Start Microsoft Access and begin building a database
When Microsoft Access first loads, you will notice a blank empty program. For some unknown reason the developers presumed users would automatically know what to do next. However this isn't always the case. The tutorial below is helpful in showing you how to firstly start a database and secondly, familiarize you with a few useful tools within Access.
Step 3: Creating Tables - Part One
Access databases work via numerous tables. The tutorial below will visually demonstrate different choices you have for building database tables. It then shows you how to build your first table.
Creating Tables - Part Two
Creating Tables - Part Three
Creating Tables - Part Four
Step 4: Adding Records
Now you have a database table built, its time to add some records. Or in other words, add some customers. The tutorial below will show you how to add a few customer records to your database.
Over the next few days I'll be posting Access tutorials discussing how to query your database, as well as how to build forms and reports.
| Want to learn more about designing a website or improving an existing one? Subscribe to Website Design Tips today for free. |
Comments (2)
Thank you this has been extremly helpfull, now days there is not many people using this program any longer
Posted by Imanol | September 21, 2007 1:00 PM
Posted on September 21, 2007 13:00
Thanks a lot for these great helpfull tutorials! Meany greatings from Belgium.
Posted by Peter | January 16, 2008 3:23 PM
Posted on January 16, 2008 15:23