A database can become very helpful for many people, especially if the person has their own business or responsibilities to look after a lot of information, that they require to look at every now and then.By using a database, you can make it possible for yourself to search for various information quickly and easily.A database has to consist of many relations, so that all the information in the database can link together and be searched for easily.Data is arranged into various tables (preferably two or more), and as I have mentioned above, the data is linked together with the aid of relations.With a database various searches and reports can be produced based on the needs of the user.This is extremely flexible and can save space by avoiding duplication.
Each table in a database is made up of fields and records.Fields have different formats depending on the type of data they store.Examples of various kinds of fields and their formats:-Type of data- text, category- Basic – Mixed letters and/or numbers,What is included in it- Up to 255 characters (letters and/or number codes).Number: -Integer- Whole numbers between -32,768 and +32,767-Long Integer- Whole numbers between -2,147,483,648 and +2,147,483,647-Byte- Whole positive numbers between 0 and 255-Single- Any number (accurate to 7 significant figures)-Currency- Up to 15 figures before decimal place, 2 after – e.g. ï¿½1,234.56-AutoNumber- Automatic counter – incremented by 1 for each record.Special: Date/Time- Both date ; time – e.
g. 25/12/98 16:25:08-Yes/No True/False On/Off – For data with only 2 possible values- OLE Object- For pictures, sound, video, Word/Excel documents etc.-Hyperlink- For links to the Internet or e-mail.All of the information mentioned above is all about the different types of fields that can be used in databases.All of these fields above are found within tables and various tables can be linked together by the power of relation database.
When tables are linked together they form a relationship.A relationship enables tables to have some sort of a link with each other, so when a search is entered into the database, all the information form various tables links up and provides the necessary information.The best way of putting information into a table is by using a FormWhen a Form is created it appears on the screen and prompts you for the information a field at a timeYou can design how the Form will look or you can ask the computer to provide designs by using the Form WizardOnce you have designed the fields for each record in your table, this is how the computer is to be used to be able to find a particular record:-To help the computer you have to choose a particular field as a Primary Key.The field chosen as the Primary Key must contain unique data for each record in the table.Examples:-A field called Surname should not be used as a Primary Key because two people in the table might have the same surname!A field called Date of Birth should not be used as a Primary Key because more than one person in the table might have the same Date!Usually a Primary Key is a field, which, within its table, contains unique data for each record.Some times there are a number of fields, which could be Primary Keys.Some times it is necessary to create an extra field such as Reference Number if no other field in the table is likely to contain unique data!To obtain information form a database, the best method to use it to:- produce a query.
Now a query is used, usually if you want to search for a particular piece or group of information.The easiest way to search for information on the Access database is by using a Simple Query Wizard The Query you create produces a new table which you can print out by producing a Report The easiest way of producing a report on the Access database is by using the Report WizardEvaluation of my own database!The database that I have produced is all about football.It is based on the premier league teams, and it consists of various kinds of information such as the team names, the team grounds alongside with additional information about the ground such as the capacity of the ground, and where about the ground is located.Also my database includes information on the team mangers, and the home and away kit colours that are used for the team.This table about the premier league team consists of eight different types of fields.I have produces two tables for my database, and as I have mentioned above one of my tables includes the information on the various premier league football team.
My second table consists of information about the squad of one particular premier league team.The team that I have chosen to base my second table on is “Liverpool football club.”I have included various facts in my second table all about the squad of the Liverpool football club team.I have included 11 different fields in my second table, and they all consist of a wide range of data types.The fields that I have included in my second table are all based on different types of information about the squads personal life and their football career.My database will enable people to search various kinds of information on the premier league teams, quickly and easily.My database includes all the necessary information that people would want to know about the premier league teams.
Also my database consists of two table that are linked to each other.So my database allows people to search for the Liverpool team facts, and then also from the same search, find out information about the squad of the team.I think that my database is very helpful for those people who are interested in football.This is because they can easily type a search into the database and find only the necessary information that they require off my database.Personally I am not that interested in football myself, so I did have to search a lot of the information that I have used in my database.I did these searches by going onto the internet and typing in various searches.
There are two main sites that I received the full proper information that I required to carry out my own database.Those sites were:- www.liverpoolfc.tv- this was the site that I used for my second table which was about the Liverpool squad.The other site that helped me a lot with this database was:- www.groundguidefc.
com, this was the site that helped me a lot with my first table which was about the premier league teams.I have included a primary key in both of my tables.My first table on the premier league teams, has it’s primary key, on it’s first field type which is the team name.
My second table on the Liverpool squad, has it’s primary key also on it’s first field types, which is personal reference number.The reason that I have included a primary key in my tables is because a primary key helps and enables the computer to find a particular record.The field chosen a a primary key must contain unique for each recorded in the table.That is why I have used team names and personal reference number as a primary key, because they both contains unique data in each record.The team names in the premier league are not identical so they are all unique.
I had to create an extra field in my first table, in order to make use of a primary key, because there was no existence of unique data in any of my records that I had already.Here is a small guide with screen shots, showing how I created my tables within my database, and how I produces different fields and how I entered data into my tables and how I created a primary key:-Firstly, to begin with, I loaded up Microsoft access database software.As soon as the software loaded up, a new window came onto my screen, which looks identical to the one above.At this point I clicked on the blank database option.Then I clicked on the O.K option at the bottom of the window.Then after I had clicked on O.
K on the previous window, this window appeared onto my screen.Here in this section, I gave my database a name, and I saved this file under my user name and area.Then after that, I was ready to set up my tables.To create a table I firstly, clicked on the table’s option at the top of the window, and then I clicked on “new.”Once I clicked on new, a new window came up onto my screen, like the one shown in the diagram above.On this window I clicked on the option “design view” and then I clicked on OKAfter I had clicked on O.
K on the previous window, a new window came onto my screen, which appears like the one above.In this section I entered all the details for the various fields that I was going to use in my first table.I firstly started by entering personal reference number as the choice of my first field.In the choices in the second window, which was located at the bottom of my screen, I selected the field size as integer and I made sure that I specified that this was “required.”Finally I clicked on O.K at the bottom of the window.Then I entered the other field names, into my table according to the plan making sure that the planned types of fields, field sizes, etc. are entered.
Then I created my primary key.In this case, with my first table my primary key was used on my personal reference number, which consisted of unique data in each record.Anyway, to create the primary key, all I did was click on the first row, where my personal reference number field was located, and then I selected edit and then primary key form the toolbars at the top.A soon as I did this a small gold key appeared on my screen next to my first field on the left-hand side.Then to finish my first table, I gave my table a name.From the table I chose the toolbar- file, and I clicked on the save as option.
Once I clicked onto the ‘save as’ option, the window that is shown above appeared on my screen.At this stage I entered the name of table- by the space where it said- new name, and then I clicked on the O.K button.Finally I closed my window down, using the cross at the top right-hand corner.Then using the same techniques, as mentioned above I created my second table- obviously the file types and names, were different for this table.The window above, is the window that appeared on my screen once both of my table’s were created.
Then, once my tables were created, I began to enter the required data into the table columns and rows.After I had finished typing up all the information on football teams and players into my tables, I then began to produce my forms, relationships and reports and queries.Firstly to produce my forms for both my tables this is what I did:-Just, as I did to create my tables, I clicked on forms at the top of the window, and then I clicked on new and form wizard.Once I had done that, a new window appeared on my screen, that looked like this-Once this window appeared onto my screen ,I firstly used the drop down menu at the top left to select which table the Form is for, which in this case was the premier league football teams.The I chose the fields that I to enter data into, by moving them from the left-hand side to the right hand side using the arrow buttons.
In this case I needed to copy all fields across – as shown in the picture.Finally, I clicked on the Next button, and ten went through my layout options until I had clicked the next button three times.Once I had clicked on the next button three times, a new window appeared on my screen that enabled me to enter a name for my new form.Then I clicked on the finish option.Then I closed down my form window, and when I clicked back onto it, all the data that I had typed up into my table, had automatically converted to my form.Then I created the relationship between my tables.To create the relationships between my tables , I firstly clicked on the tools options, and then I chose the option stating “relationships.
“I needed to connect a relationship between the current team playing column in the Liverpool player info, table and the team name in the premier league table.Anyway once I clicked on the relationship option, a new window appeared onto my screen, that looked like the one following: -On this window, I clicked on my first table and clicked add, and then I clicked on my second table and clicked add.This then gave me both my tables and their file name information.Then to create a relationship, I clicked on the current team playing file in my Liverpool payers table, and then dragged my mouse while I was still hold on the click button, to the team name file in the premier league table.Once I did this a new was table appeared on my screen that told me the type of relationship I was creating.In this case it was a one to many relationship.
Then I clicked on the option the new window that said, “enforce referential integrity”, and I clicked on the O.K option.This then created my relationship between my two tables.The relationship that was created was- a “one to many relationship.”Then after all that was done I created my queries and reports.This is how I did this:-I firstly created my query to enable me to search and match.I first clicked on the queries tab, and then I clicked on new, and selected the query wizard option and selected on O.K.
Then a new window appeared on my screen which looked like the one below:-Once this window appeared onto my screen, I selected the premier league teams table at the top left hand corner, and I then selected the options that people are more likely to search for, and I placed these options in the right hand box, from the left hand box, using the small arrows in between.I did not click on the next button.Then I did the same method for my second table, which was based ion the Liverpool football squad.Then after I had done all that, I then clicked on the next button.Once, I clicked on the “next” button, the window shown above, appeared on my screen.
At this stage I gave my query a title, clicked on the modify the query design option, and clicked on the finish option.Once I clicked on the finish option, a new window appeared onto my screen, like the one shown below.Once this window appeared onto my screen, I then typed in the search that I wanted to carry-out for this particular query.I typed in this search within the in the row labelled ‘criteria’ and under the column labelled birth month. I typed in the particular birth place of the Liverpool players, that I wanted to search for.In this case my search was Chester.
So what I did was, I typed in Chester along with asterisk, within the place mentioned above.This is what my typed search looked like- “Chester.”Having done this, I then close down this window, by clicking on the cross symbol, and the when a new window appeared on to my screen enquiring about if I wanted to save the search I carried out, I clicked on the option ‘yes.’After that my first query for my database was complete.
I also created a few more queries, based on different searches, below is a list of the various searches that I also created:–Liverpool 1st team goals-Liverpool- international caps query-Premier capacity of ground-Premier home kit colour queryAfter all my queries for this database were completed, I then carried out the procedure of creating some reports from my queries.This is how I did this:-Firstly:- I created a report for my search on the birth place- Chester.To do this I firstly clicked on the reports tab at the top of the window, and I then clicked on the new option.Once I did this an new window appeared on my screen that looked like the one shown below:-Once this window appeared onto my screen, I selected the report wizard options and I then clicked on the o.
k option.Once I did this, the window shown above appeared onto my screen.Then here at this stage I selected the query Chester from the drop down list, and I then copied all the field names form the left hand box to the right hand box by clicking on the field names and then clicking on the arrows in the between the two boxes.I moved al the field names to the right hand box, apart from the Birthplace field name.I then clicked on the next button four times, until I was asked by layout.Once I was asked about layout, a number of windows appeared on my screen one after the other, asking me about the layout style, of my report.
For example- if I wanted it laid out portrait or landscape, or what type of background I wanted on my report.After I had decided all the final lay out and appearance of my report, I then clicked on the finish option.Finally I gave my report a suitable name and clicked on the finish option.The name I kept for this particular report was:- Liverpool Chester report.Then my report from my Chester query appeared onto my screen, in the same lay out I had chose it to.Below is a screen shot of what my report looked like:-After this I created a report for all of my other queries and I then had finally completed all of my database.I did then consider adding in extension ideas into my database, but I really did not have enough time to add pictures to the players name or anything like that, because I did have to begin my next assignment which was to do with spread sheets, so I thought I would leave it for the time- being and perhaps get back to it later If I found the time to do so.Basically I think that I could have improved my database, If I had perhaps added some pictures to it and livened the whole atmosphere of t a little.Also I could have added some colours to my database, and then this way, my database would be a lot more brightened interesting.