Bell Ringer
Create a database for your final project in your folder on the C drive. Name it finalProject.mdb. Create a table named tblProducts with the following fields
- productId
- onHand
- unitPrice
- productDescription
Use appropriate data types and choose one field as your primary key.
Create a form for the table, name it frmProducts.
Enter 10 records into your table via the form.
Objectives
Define data types
Number types - long integer, single, double
Fixed decimals, currency, default values, required fields, autonumber
Filter by form, complex query
Create address labels
Agenda
- Create the products table for your final project
- Review chapter 13 Questions
- Work on chapter 13 Exercises
- Create address labels from your address book
- Review for chapter 13 exam
- Work on Final Project
Assignments:
Make sure you back up your projects to your Y drive at the end of the period!
Bell Ringer
Copy the database sampleAddressBook from the K drive to your C drive. Create a set of envelopes to go to all of the people in the contacts table. Save the document as sample envelopes. Merge them to a new document and show it to Mr. Wissing.
Objectives
Customize mail merges
Create address labels
Review chapter 13 topics
Agenda
- Mail merge bell ringer
- Customize envelopes and return lables
- Create the sales table for your final project
- Finish chapter 13 exercises
- Review for chapter 13 exam
- Work on Final Project
Assignments:
Open your final project database Create a table named tblSales with the following fields
- salesId
- productId
- customerId
- employeeId
- quantity
Use appropriate data types and choose one field as your primary key.
Create a form for the table, name it frmSales.
You will need to create and fill in your products, employees and customers tables before you can fill in the sales tables.
Make sure you back up your projects to your Y drive at the end of the period!
Bell Ringer
Review the chapter 13 topics by reviewing the chapter 13 summary and vocabulary in the back of the booklet
Objectives
Assess the chapter 13 objectives
Use layers in Adobe PhotoShop Elements
Use the Liquify Effect in photoshop elements
Use the clone stamp tool
Agenda
- Review for test
- Chapter 13 Exam
- Create all 4 tables for final exam
- Enter data into the tables
- Create realtionships between the tables
- Work on the photoshop elements layers and effects tutorial
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
Make sure you have all 4 tables for your final project created.
Products
- productId
- onHand
- unitPrice
- productDescription
Customers
- customerID
- (all the information for an envelope)
Employees
- employeeId
- firstName
- lastName
- wage
Sales
- salesId
- productId
- customerId
- employeeId
- quantity
Objectives
Use layers in Adobe PhotoShop Elements
Use the Liquify Effect in photoshop elements
Use the clone stamp tool
Relationships in a database
Agenda
- Create all 4 tables for final exam
- Enter data into the tables
- Create realtionships between the tables
- Work on the photoshop elements layers and effects project
- Create your company logo
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