180 likes | 203 Views
OPEN ACCESS. GO TO THE START MENU OPEN ACCESS FROM THE PROGRAMS MENU THIS IS A MICROSOFT PROGRAM purple icon with the little key. OPEN BLANK DATABASE. SAVE THIS INTO YOUR “BIOLOGY FOLDER” SAVE AS “Review”. CREATE A TABLE . DOUBLE CLICK ON THE DEFAULT CREATE TABLE IN DESIGN VIEW
E N D
OPEN ACCESS • GO TO THE START MENU • OPEN ACCESS FROM THE PROGRAMS MENU • THIS IS A MICROSOFT PROGRAM purple icon with the little key
OPEN BLANK DATABASE • SAVE THIS INTO YOUR “BIOLOGY FOLDER” • SAVE AS “Review”
CREATE A TABLE • DOUBLE CLICK ON THE DEFAULT • CREATE TABLE IN DESIGN VIEW Field Names: Descriptions • Topic ------ Which unit of study • Chapter ------ Which chapter in text • When covered ---- Approximate month • Question ---------- The Question • Question Part II --- Multiple choice/two-part questions • Answer ---- Answer
SAVE • Save AS A TABLE • Access will ask if you want a Primary key – click “YES” • You will now enter data onto your table:
THIS IS THE DESIGN VIEW – NOTICE THE QUESTION YOU TYPED INTO THE TABLE IS NOT HERE
DRAG THIS TO THE 8 CHANGE THE SIZE BY DRAGGIN THE TOP OF THE FORM FOOTER TO THE 2
MOVE YOUR FIELDS – CLICK AND HOLD – YOU WILL SEE A HAND – MOVE BOTH THE LABEL AND INPUT BOX LABEL BOX INPUT BOX
ENLARGE THE BOXES THAT WILL HAVE A LOT OF TEXT • MAKE THE FOLLOWING BOXES BIGGER: • QUESTION • QUESTION PART 2 • ANSWER • ADDITIONAL NOTES
REFORMAT LABEL BOXES • YOU CAN MOVE THE LABEL AND INPUT BOXES BY GRABBING THE TOP LEFT CORNER AND DRAGGING IT
GO FROM DESIGN TO FORM VIEW • AS YOU WORK TO REARRANGE YOUR FORM DESIGN, GO BACK AND FORTH BETWEEN YOUR FORM AND THE DESIGN FOR THE FORM
Access Review - Report • You currently have a review TABLE • You currently have a review FORM • The grey area on the left allows you to navigate to each of these documents • Remember you have a design view and a form view for each of these documents • Create your Report