How To Create A Database
Databases are a way of organizing and storing data. Many companies require database usage and the usage of forms that are created from spreadsheets. In this video, you will learn how to use Microsoft Access and Microsoft Excel to create basic spreadsheets and forms.
Today I am going to show you how to create a database. A database can be very, very straight forward, a single column of data like an Excel spread sheet or it can be very, very complex involving multiple tables of multiple data all linked together to create forms and graphs and so forth. Today we are going to create just a simple database which stores peoples first names and last names.
The program most people use when creating a database on their desktop computer is Microsoft Access. There are lots and lots of other ones out there, some very big and used in the corporate world and others are just home ones or web based ones. The principles are all the same.
The principle of databases is that you have tables. A table is a list of data with as many or as few columns as you want. As I said early, you can use Excel as a very straight forward database which contains, lets say, first name and last name.
If that is all you are trying to store, then this would work absolutely fine. However, spreadsheets are good for doing calculations and containing basic data. Access allows you to view that data in a different way and also make it easier for people to enter that data.
We will close that here, but we will create the same thing on Access just to show you the principle. First things first, in this case we are using Access 2010. Double click it.
We have got a number of options when we start up. As you can see, underneath, in the second section, there are a bunch of templates which Microsoft throws in automatically, so it will do it automatically for you. These are pre-prepared and available for you to use.
In our case, we are going to just create a blank database, a very straight forward one here. Double click "blank database." What we are going to want to do is design the first table.
This is a table just like the spreadsheet which contains columns that you want your database to contain. So, go to the design view at the top. First of all it asks us to give the table a name so we are going to call it names.
We go to here. Again, there is lots and lots of different options here, but lets keep this really simple. It is always good practice to have the first column as an I.
d. column, so this is an alter numbers that is generated so that the database knows how to reference that line. We are going to create the first column, which is first name.
Press tab. There is a text field, so we are just going to enter text in there. We have got a second name as the second column.
That is a text field. To add a bit of extra information we will do one which is age. Here, you could just leave it as text, but if we change it to number, then the database knows that that that is specifically a number field and it wont let you put letters or symbols or anything else in there.
What you do, is click on the database view. It asks you to save the table, click yes. Just like in Excel, we no have got like a column view that we can start to put some information in.
So, name: Jamie. Second name: Claret. Age: 34.
If you just press tab, you can now start adding more. So, this is not really much different to Excel, but what we can do is go into create and we can create a form. This is what most people will be used to when they work with databases.
This will be a form that people can fill in, or that you can fill in, to add your data. So we will click form. As you can see, it is now looking more like a database, but with first name, second name, and age.
So, I've just showed you how to create a database with Microsoft Access. It can be very large or it can be very small or as complex as you want it to be. .