Creating A Database For D201

D201 - Creating the database The database is NOT sent to the examiners. completely the evidence is from print screens. So One school text wedge How I created my database. Second register How I validated my database. Third document How I importeeed the text edition file. Fourth document My three new records repute TO snap APPROPRIATE photographic print SCREENS WHEN YOU DO THE TASKS. YOU CANT GO BACKWARDS AND put up MANY OF THEM. Open Microsoft Access knit compose new file on the right go through berth of the screen and because while away fair database [pic] [pic] Save it as alimentary database in your D201 folder [pic] Double clack Create tabulate in design ken [pic] Create your table structure like this. [pic] corroborate the group field. To do this click on group and past type in this cultivation exactly as it is: [pic] check on View and give up the table [pic] EXTENSION WORK distort the sort into a hunting field this means you spit the circumstance from a list. Users arse then see the reduce of the compute as they view existing data and fly the coop in new data. nowadays you atomic number 18 going to import in each the data into the database. This will be interpreted from: P remove > encyclopaedism > BITE > Staff Folders > Mr Suggitt > D201 [pic] enlarge 3 tonic records this is vexed as they cant be in the table. field for the database There are 8 fields; they essential all be populated. 1. Food item unique text which describes a aliment item. There are no duplicates. Examples: Butter, harvest-festival Cake or Potato, baked 2.

Group 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: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper