a picture of this table is shown below:
Table 3 (Record Label Info)
A picture of this table is shown below:
How will I link the tables together?
There will be relationships between each of the tables.
Table 1 will link to table 2 with the performer field. Table 2 will link to Table 3 with the Record Label.
4 Describe how you put your plan for tables and relationships into Access
I set up the first table by typing the basic data into or as the fields. For my data I mostly used text, this was because everything to do with cd’s was mostly related with text with only one exception which was the “telephone number”. Sometimes when I was typing in the data I was encountered with errors, each time I found out what the problem was and then changed either the field name or the data type.
Next, I set up the primary keeps in each of the tables. The way I adjusted the primary key was, I highlighted the field name and then right clicked on it then a selection menu came up and I click the primary key button, and then a little symbol appeared next to the field that I had chose to confirm and show that was the primary key.
My tables linked together. I created the relationships by using the most common and most suitable fields. In this case I used the “performer” and “record label” because I felt that they were the most common. The steps I used to create the relationships were, first I clicked on the toolbar icon and then clicked on the relationships button, then a separate window came up with all the 3 tables init and from there I linked the fields which I wanted.
5 describe how you entered data into your tables
I entered my data straight into the tables. This was because it was easier to identify it and easier for people to use it. It also helped me to make sure that everything I entered was correct. I also use extra features for example the “next record” and “last record” buttons these are clearly visible on the screen shot below, I created these so it would be easier for people to move onto the next and previous record and it also improved the design and layout.
In the form I had made some changes which improved the design of the form and made it easier to use. First I made some buttons which when clicked on would link to, the next record, last record, find record and exit. I also had to make some changes in the properties make the form better, I removed the navigation buttons and removed the border.
So after all the changes the final design looked like this, I changed to option on the navigation option to make it invisible instead I put separate buttons on the form design so it was easier to use and work.
To create the buttons I had to design them through design view of the form. To increase the quality of the forms I inserted a picture that was relevant to the form and which also described the main subject of the form (BHANGRA).
To insert a picture I had to use the image option in the tool box in the design view of the form,
6 Describe how you have searched (query) and reported any findings
I have tested my database by setting up a query and report. I have created 2 main queries, my queries would help people choose different things throughout the table. The title for my queries were “Artist age under 30” and “record label - moviebox” this allow people to see each and every artist under the age of 30, and the record label would have allowed people o see the albums released under the moviebox record label. What I did to create my query was, I clicked on the query button and then I clicked on the query wizard, then I entered all the different fields that I needed in my query, and then I entered a criteria to search for through out the fields. I have printed out a copy of one of the reports that I did, the report basically shows information entered throughout the database.
In some of the queries I had an option where people could put in information they wanted to search for, for example in one of the queries people had to put in the age of the performer they were looking for, they method I used to do this is shown in the diagram before simply all I had to do was to choose a different command. Simply he queries allow the user to extract exactly what information is required from a database. Specific fields and records may be selected.
After I had clicked on the icon it a little box like this came up, this is where the person has to enter the criteria they are looking for, for example what particular age they are looking for.
After clicking ok the a normal window would have came up which would have showed all the results that matched the inserted criteria.
Altogether I designed 8 different queries, these are,
Reports
Reports are generally lists of data, reports can be used to,
SEARCH for data.
PRESENT data in some order.
COMBINE data from different tables.
GROUP data according to some category.
I have printed out all the reports that I have created some have all the information required and some of the reports require you to put in some data or value, for example the age. I have altogether created 4 repots,
7 Describe how you ensured that your work was safe and accurate.
I created several back up copies of my data bas this was just in case one got deleted or lost. I saved a copy in school and at home. I checked my work for errors some things that I looked for were, spelling and grammar I done several checks as I went along to make sure that none of the work were spelt incorrectly. I also made sure that the relationships were linked correctly and the form features were working correctly.
8 evaluate what you have done
My finished database is different in many ways compared with the one that I has designed for my plan. I added many features which made the design look better and the database easier to use. If I had more time I would have put in many more features and buttons and maybe I would have had more tables which might have allowed me to create more relationships. To extend my database I could put more tables in and maybe I could insert pictures or covers of the albums, which would also improve the quality of the presentation. I made sure that the names of the tables had something in relation with the information in the tables.
GNVQ ICT – Sherjeel Akhtar
