Bell Ringer
Finish the Image editing project (described below). Show Mr. Wissing the completed project and then send it to the printer.
Objectives
- Relationships in a database
- Sorting records
- Create and use select queries
- Create range queries
- Use wildcards in a query
Agenda
- Work on the photoshop elements layers and effects project
- Create your company logo
- Work on the chapter 14 booklets - Use Photoshop Elements or Fireworks
Assignments:
Make sure you back up your projects to your Y drive at the end of the period!
Photoshop Elements tutorial project
Find a classic work of art on the internet-
Examples
Edit the art using the clone stamp tool and at least 3 effects in PhotoShop Elements. Also add some text that has been adjusted using the Liquify filter. Save the file as a jpg
Bell Ringer
Get Literary City.mdb and Brokerage.mdb from the ch14 folder on the K drive. Save them to the C drive in your folder.
Objectives
- Relationships in a database
- Sorting records
- Create and use select queries
- Create range queries
- Use wildcards in a query
Agenda
- Worksheet 14.1
- Create your company logo-Use Photoshop Elements or Fireworks
- Work on the chapter 14 booklets
- Create Labels - return and customer and personalized envelopes for your company
Assignments:
Make sure you back up your projects to your Y drive at the end of the period!
Bell Ringer
Create the reorder query in your final project. Make sure you have at least 2 items in your products table that you have less than 10 in stock and at least 4 that you have more than 10 in stock. Use a filter by form to create the query. Create envelopes for all of your customers. There should be a company logo on the top of the envelope. Merge to a new document and save them as envelopes.
Objectives
- Relationships in a database
- Sorting records
- Create and use select queries
- Create range queries
- Use wildcards in a query
Agenda
- Bell Ringer
- Create your company logo-Use Photoshop Elements or Fireworks
- Create Labels - return and customer and personalized envelopes for your company
- Work on the chapter 14 booklets
Assignments:
Make sure you back up your projects to your Y drive at the end of the period!
Bell Ringer
Open the Literary City Database that we used in worksheet 14.1.
Objectives
- Relationships in a database
- Sorting records
- Create and use select queries
- Create range queries
- Use wildcards in a query
Agenda
- Bell Ringer - Worksheet 14.2
- Questions chapter 14
- Create a flyer in Word for a sale on two of our products. Use a mail merge to personalize the flyer to three of our customers (hint create a query that will sort out 3 customers and then merge to this query). Add the company logo to the top of the page. The flyer should have at least 3 merged fields in the document.
- Work on the chapter 14 booklets - check when done
- Review for ch 14 exam
Assignments:
Make sure you back up your projects to your Y drive at the end of the period!
Bell Ringer
Finish the chapter 14 exercises. Create a sales flyer for your final project.
Objectives
- Relationships in a database
- Sorting records
- Create and use select queries
- Create range queries
- Use wildcards in a query
Agenda
- Finish chapter 14 exercises
- Create the sales flyer mail merge form letter
- Review for capter 14 exam
- Chapter 14 exam
- Start chapter 15 Practices
Assignments:
Make sure you back up your projects to your Y drive at the end of the period!