1 / 15

DATA BASE

DATA BASE. Onika Clarke-Palmer. CREATING A DATA BASE. For each field name you must select the data type that is best to represent the type of field name given . This is because a food item would only be described using letters, spaces and punctuation.

gil
Download Presentation

DATA BASE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATA BASE Onika Clarke-Palmer

  2. CREATING A DATA BASE For each field name you must select the data type that is best to represent the type of field name given. This is because a food item would only be described using letters, spaces and punctuation. For the task that has been given, you open up the information sheet from the website and this will give you the data that is to be put into each field name. Don’t forget to remove the key because it is not need in this database.

  3. FOOD ITEM The data type is set to text. This is because a food item would only be described using letters, spaces and punctuation. Thefield size is reduced to 100. This is a large enough space for any food item description and will reduce the database’s file size. No duplicates has been selected. This will ensure that no two food items imported or entered into the database are the same.

  4. GROUP The data type is also set to text. This is chosen as the codes used to represent food groups of food items are using only letters. Thevalidation rule limits the data that can be imported or entered to be the specific food codes allocated. Thevalidation text is the information that will appear if the user tries to enter information other than the specific food codes.

  5. CREATING A LOOK UP WIZARD Some of the date entered into field names require a look up wizard so that specific data can be entered into the database. This will allow the user to have a drop down list box to choose one of the specific food group codes from. This is what the completed outcome will look like.

  6. Display control is changed to combo box. This will allow the user to have a drop down list box to choose one of the specific food group codes from. This shows the two rows that will display when selected. These will display the food group code and the food group next to it as a reference for the user. It will only input the code into the database.

  7. UNIT The data type is set to text. Units to describe how food item is measured will always be using text. Thefield size is reduced to 100 because it is a large enough space for any measurement to be entered and will reduce the file size.

  8. quantity The data type is set to text. Units to describe how food item is measured will always be using text. The field size is reduced to 100 because it is a large enough space for any measurement to be entered and will reduce the file size.

  9. carbs The data type is set to text. Units to describe how food item is measured will always be using text. The field size is reduced to 100 because it is a large enough space for any measurement to be entered and will reduce the file size.

  10. fibre The data type is set to text. Units to describe how food item is measured will always be using text. Thefield size is reduced to 100 because it is a large enough space for any measurement to be entered and will reduce the file size.

  11. fat The data type is set to text. Units to describe how food item is measured will always be using text. Thefield size is reduced to 100 because it is a large enough space for any measurement to be entered and will reduce the file size.

  12. calories The data type is set to text. Units to describe how food item is measured will always be using text. The field size is reduced to 100 because it is a large enough space for any measurement to be entered and will reduce the file size.

  13. Then when the data is imported from the index file, this is what the completed outcome will look like. Now you will have to research three new items each under different food groups.

  14. Sweet potato The data base did not contain honeydew melon so this is why it was chosen. It would come under the “FT” group because it is a fruit. The data base did not contain sweet potato so this is why it was chosen. It would come under the “VG” group because it is a vegetable. Honeydew melon Chocolate milk The data base did not contain chocolate milk so this is why it was chosen. It would come under the “DY” group because it is a dairy product.

  15. CHECKPOINT! I have used the ‘CHECKPOINT’ criteria from the website to make sure that the work I have produced meets all of the requirements. Because I have previously used microsoft access I have had no problems in creating my data base as I knew what need to be done and how.

More Related