RH

Databases with Microsoft Access

posted by trikkky on September 17, 2009

Databases with Microsoft Access

Today was an introduction to Access. We had to create a database, then create a form so when the people inputing into the database couldn’t access the information, and jo public couldn’t see other people’s info on the screen. Was Quite easy and liked the way it was done as it was easy on the brain.

What we have done is create a new database, and named it demo1

We then input different Fields and Data types into the boxes to create your database. Mine is very simple just to get going. As you are creating the fields you can give a description so that the user can see near the task bar when inputing you can see what you are supposed to be doing as it displays the description.

The blue arrow is for you to input the field size as the default on this edition of Access is 255 characters and i have given it 15, because the computer will reserve 255 characters of space for that field when it only needs to reserve 15, thus saving lots of unwanted space.

Now you have created your table you need to create a form for the user to input the data. Close the table .

What you need to do is find the form button on the toolbar then make sure it is in design view and your can then click on any input field and change the background colour, font colour, the background, font size basically make the form your own design.

To create a drop down box so that user input error can be minimised because the user has to use the mouse to click the button. Notice that I have deleted the Age input fields, and when i press the button ‘button’ the cursor will change and you drag out a box at the bottom of the screen. A list box wizard will appear and choose I will type in the values I want. Next will be entering how many options you require.

What I’ve done is say that we only want one column, then entered different ages in the boxes

Select the options as displayed on screen and from the dropdown box choose the button you are making

Name your list box the same as your input as that is what will be displayed on the form.

You will then have created a form with a drop down input area. We will continue more when we know more.