ACCESS Practice 1

1. ACCESS Practice 1

2. Lesson 1. Using Forms • Form • A graphic object that can display and accept data for related tables • example • Download ‘exdb’ zip file from lecture homepage • Uncompress ‘exdb’ zip file in exdb folder • Open the Access DB file ‘Sweetlil.mdb’ in ‘exdb’ folder • Follow the steps as in the next slides

3. The steps to follow(1.1) • Data input • Use “Chocolate Preferences” form • Use TAB key to move to next field • Use “record move” buttons (,) to move between records • Use “new record” button ( *) to enter a new record • Enter the following data • First name: Amanda •Last name: Hart • Street: 10 MacLead • City: Melfort • State/Province: Saskatchewan • Postal code: SOE 1A0 • Country: Canada • Chocolate type: Milk

4. The steps to follow(1.2) • Data input • Use “Bonbons” form • Use “combo box” to select an input data • Try to select ‘Bittersweet’ for ‘Chocolate Type’ • Try to select ‘Marzipan’ for ‘Filling Type’ • Try to insert new cost ‘.35’ for ‘Cost’ field ※marzipan: 아몬드와 설탕을 이겨 만든 과자

5. The steps to follow(1.3) • Data search • Use “Customer Review” form • Click a specific field for search to find a record. E.g. Last Name field • Click the icon of ‘binocular field glasses’ for search form • Try to find a person whose last name is ‘Hemshire’ ※binocular field glass: 쌍안경

6. The steps to follow(1.4) • Data search • Use “Customer Review” form • You may use wild card characters(*) • ‘*’ corresponds to any number of any characters • ‘?‘corresponds to any one character EX) N*man* = Newman, Newmann, Neumann, … ?ouse = douse, house, louse, … • You can search by • Matching in all contents in a field • Matching in part of contents in a field • Matching in beginning of a field • Try to find streets that contains ‘rose’

7. The steps to follow • Data editing • Data editing task is similar in word processors • Insert • Copy • Add a new record • Cancel edited work • You can change all data that meet some condition at once

8. Lesson 2. Tables and Subforms • A database contains many tables. • Basket Details, Baskets, Bonbons, Box Details, …… • How many tables are included in ‘sweetlil’ db? • Open ‘Baskets’ table and try to change the size of row or column • A form can contain subform(s) • a form or subform can be linked to a table. • So, multiple tables can be linked in a form • See the next slide for example

9. From table ‘Bonbons’ subforms Linked to table ‘Baskets’ Linked to table ‘Basket Details’

10. The steps to follow(2.1) • Insert a new record into the ‘Baskets’ main form using ‘new record input’ button (*) • Insert the following data • Basket Name: By The Fire • Basket ID: WINT • Basket Description: Nuts and berries coated with chocolate.

11. The steps to follow(2.2) • Insert several new records into the subform of ‘Baskets’ after moving to the first field of the subform (use ‘TAB’ key) ※raspberry:나무딸기, cashew:서인도제도산 옷나무, walnut:호두, fudge:설탕,버터,우유,초컬릿으로 만든 물렁한 캔디

12. The steps to follow(2.3) • You can see a whole table by using ‘Data sheet’ menu • You can adjust the width of each column for better inspection