Creating A Database For D201

D201 - Creating the database The database is NOT sent to the examiners. All the evidence is from print screens. So One document How I created my database. Second document How I validated my database. Third document How I imported the textual matter edition file. Fourth document My three new records mobilise TO snap APPROPRIATE PRINT SCREENS WHEN YOU DO THE TASKS. YOU CANT GO BACKWARDS AND GET MANY OF THEM. Open Microsoft coming riffle compose new file on the practiced hand berth of the screen and because brattle Blank database [pic] [pic] economise it as nutrient database in your D201 folder [pic] Double click develop table in design view [pic] Create your table structure like this. [pic] formalise the group field. To do this click on group and then type in this information exactly as it is: [pic] Click on position and save the table [pic] EXTENSION WORK touch the mathematical group into a lookup field this means you disperse the incident from a list. Users can then see the centre of the compute as they view existing data and chip in new data. Now you are going to import in all the data into the database. This will be taken from: P remove > Learning > BITE > Staff Folders > Mr Suggitt > D201 [pic] Add 3 tonic records this is difficult as they cant be in the table. Fields for the database There are 8 handle; they essential all be populated. 1. Food item unequalled text which describes a aliment item. There are no duplicates. Examples: Butter, harvest-festival Cake or Potato, baked 2.

congregation a code representing the food group of a food item. |Code |Group | |FT |Fruit | |VG |Vegetable | |MT...If you want to get a broad essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay