Bell Ringer
Take the chapter 14 Exam if you have not taken it yet. Do not forget the application section.
Objectives
- Create a report
- Add summary values to a report
- Use fields in select query criteria
- Create a calculated field
Agenda
Finish the chapter 14 exam
Work on chapter 15 Practices
Work on chapter 15 Questions and exercises
Create an amoritization table for financing at your store. The rate is 8% the term is 1 year. Add interactivity(pg 10) to this worksheet and save as a web page into your final project folder.
Assignments:
Bell Ringer
Work on the chapter 15 questions and exercises for the first 15 minutes of class
Objectives
- Create a report
- Add summary values to a report
- Use fields in select query criteria
- Create a calculated field
Agenda
Work on chapter 15 Questions and exercises
Worksheet 15.1 and 15.2
Chapter 15 Questions
Create report for final project
Assignments:
Bell Ringer
Finish the chapter 15 exercises and the final project
Objectives
- Create a report
- Add summary values to a report
- Use fields in select query criteria
- Create a calculated field
Agenda
Work on chapter 15 Questions and exercises
Chapter 15 Questions
Create report for final project -
- Add employeeID, firstName, lastName and comission from the commission query.
- Group the report by employeeID.
- Add summary options that will total the commissions.
- Sort decending by the commission
- Save the report as Best Salesperson
Assignments:
Bell Ringer
Objectives
- Create a report
- Add summary values to a report
- Use fields in select query criteria
- Create a calculated field
Agenda
Work on chapter 15 Questions and exercises
Chapter 15 Questions
Create report for final project -
- Add employeeID, firstName, lastName and comission from the commission query.
- Group the report by employeeID.
- Add summary options that will total the commissions.
- Sort decending by the commission
- Save the report as Best Salesperson
Create a webpage for your final project
- include your company logo and address
- include an email link to you
- links to other websites related to your products
- a link to your loan spreadsheet you created for the final project
- Design a data access page to add data to a table from the web.
Assignments: