DATABASES

DATABASES

In today's lesson, we started a new topic - Databases. We started using the Microsoft Access software. First, we started of by making a form. We then added the information in the correct data areas and then made it look nice by changing the background colours, the font and adding a picture. This is how my form looked:

The second part of the lesson was setting up the information type in design view. 

First we added information about cars and the picture below is the type of information we added. 

Then, we went to design view and added some information and set some things so the user can only put a certain amount of information at a time.

This is how the design view looks.

We  then set up the information. First we changed the field size of the model to 20 like this:

Now the user will not be able to type in more than 20 letters as I previously changed the field size to 20.

Then we changed the engine capacity information in the input mask section to only let someone to add 4 digits of information and no more. We called it CC.

Now the user will not be able to put in more than 4 numbers in the engine capacity section. This is how the engine capacity information looked in the actual view.

We then changed the transmission field to only let the user to select automatic or manual. To do this, we used Lookup Wizard. The picture below shows how we used Lookup Wizard.

Now the user will only be able to choose from automatic or manual.

The last step was changing the price currency to pounds by going on the format option at the bottom and changing the currency to whatever you want like shown in the image below:

Now when the user enters in a price, it will automatically change into dollars.

This was our task to do for 2-3 lessons. It was challenging and took a while to get the hang of it but I soon got used to it.