Objective: Review Excel Charts and Graphs I.  Bellwork A.  Reading and Interpreting Charts & Graphs – International Trade 1.  Write the Questions and Answers II.  Classwork A.  Excel Final Review #1 B.  Excel Final Review #2 C.  Missing Assignments

Objectives Review Database Mail Merges Review Excel Charts and Graphs I.  Bellwork A.  What data type  (text, number, currency, date, hyperlink, etc.) would each of the following be: Fordson High School  20051452 01/15/08  dearbornschools.org 13800 Ford Road 48126 $1.03  II.  Classwork A.  Handout – Care Free Travel Mail Merge -Print Report & Letter B.  Handout- Excel […]

Objectives Create Tables and Forms Sort Data Create a Report Perform a mail merge I.  Bellwork A.  What is the difference between a field and a record?  B.  Can two records share the same primary key?  II.  Classwork A.  Handout – Friendly Car Mail Merge-Print Report & Letter B.  Handout – Care Free Travel Mail Merge III.  […]

Objectives Create Tables and Forms Sort Data Create a Report Perform a mail merge I.  Bellwork A.  What data type  (text, number, currency, date, hyperlink, etc.) would each of the following be: Ali Beydoun 7239 Kentucky St. 9-08-70  January 11, 2008 $200.00 msn.com 85,000 Northwest  II.  Classwork A.  Rent a Lot Video Mail Merge – Print […]

Objectives Create Tables and Forms Sort Data Create a Report Perform a mail merge I.  Bellwork A.  Place the following parts of a Database in order  Create a Form Create a Table Create a Report B.  What do you need to create a table in Access?  II.  Classwork A.  Pet Place Mail Merge – Type & Print […]

Objectives Create Tables and Forms Sort Data Create a Report Perform a mail merge I.  Bellwork-Use the Library Database A.  Using the Author table sort the LastName field descending and write down the entire first record. B.  Using the Books table sort the Titles field ascending and write down the entire first record. II.  Classwork […]

Objectives: Define fields and records Create tables Modify a table and form. Create a  form. Enter records using forms. View tables in design view and datasheet view I.  Bellwork-Using the Museum Database A&B.  Sort the Exhibits Table ascending  and then descending by Updated.  List which record is first for each sort. C&D.  Sort the Attendance Table ascending and […]

I.  Objectives Define fields and records Create tables Modify a table and form. Create a  form. Enter records using forms. View tables in design view and datasheet view II.  Bellwork A.  Which other application is most like Access? B.  Explain how they are similar.  III.  Classwork A.  Pg 413-414 Exercise 1 – Print out Tables […]

Objectives: Copy access data to Excel and Word Export Access data table to HTML format I.  Bellwork  A.  Page 411 #18 Question and Answer II.  Classwork A. Widget Part 6 pgs 403-405 – Print B. Page 406 Products C.  Pg 413-414 Exercise 1

Objectives  Enter records using forms. View tables in design view and datasheet view. Sort, update, and delete records I.  Bellwork A.  Pg 411 #15 Questions and Answers II.  Classwork A.  Widget Part 4 pgs 396-397-Print Orders and Products Tables B.  Widget Part 5 pgs 400-402 C.  Widget Part 6 pgs 403-405