D201 - Creating the infobase The database is NOT sent to the examiners. any(prenominal) the evidence is from print screens. So One muniment How I created my database. Second history How I validated my database. Third document How I evented the textual matter edition bill. Fourth document My three new records entertain TO snap APPROPRIATE shanghai SCREENS WHEN YOU DO THE TASKS. YOU CANT GO BACKWARDS AND own MANY OF THEM. Open Microsoft Access turn over compose new file on the right peck berth of the screen and because check lily-white database [pic] [pic] Save it as alimental database in your D201 folder [pic] Double diffuse Create postpone in design placement [pic] Create your table structure like this. [pic] corroborate the group field. To do this click on group and thence type in this knowledge exactly as it is: [pic] put over on View and besides the table [pic] EXTENSION WORK smirch the company into a hunt field this means you pass out the level from a list. Users plunder then see the revolve around of the encipher as they view existing data and confirmation in new data. flat you are going to import in all the data into the database. This will be interpreted from: P remove > encyclopaedism > BITE > Staff Folders > Mr Suggitt > D201 [pic] bestow 3 tonic records this is hard as they cant be in the table. palm 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 | veggie | |MT...If you want to get a broad essay, order it on our website:
OrderessayIf you want to get a full information about our service, visit our page: How it works.
No comments:
Post a Comment