Unit 7 – Microsoft Access Database

May 28-29

Lesson:  Database Terms – Database, Data Record, Data Field

Microsoft Access Terms:  Tables, Forms (Design View, Layout View, Form View), Reports

Other Terms:  Query, Sort

Login at:  http://resources.elearningontario.ca/

To Login use:

Student userid:  AMDSBstudent

Student password:  oerbs

and the click on this link to review database terms

1) Choose the content tab and then click on the “Video Lesson”

2) Answer the following questions (type your answers after each question):

a) What is a database field?  Give an example.

b) What is a database record? Give an example.

c) What are some advantages associated with an electronic database (name at least 3)

d) What are the steps to create a database table?

e) What is a form?  What is it used for?

f) What is a query (or a search)?  What is it used for?

g) What is a sort?  What is it used for?

h) What is a report?  What is it used for?

3) Choose the Assignment Tab and click on the “The Database True False Quiz”.  Try the quiz.

Record your mark on the quiz here: _______ / 10

Assignment: 

Task 1:  Create a simple database for our class, storing information about students in our class.  Field names to be used are: last name, first name, age, address, city, province, postal code, gender, favourite sport, favourite food.

Steps:

1) Design a database entry form

– outline which fields are going to be used in the database (Layout View)

– add titles and other items to make your database entry form attractive

2) Enter your personal information into the database (Form View Mode)

3) Print a copy of your completed data entry form (Print from Layout View)

4) Enter  records from the other members of class (at least 10 records need to be entered)

Task 2:    Database Exercise 2 (page 267) and Database Exercise 9 (page 274)

May 30

Lesson:  Database Features – Reports, Sorts and Queries

Database Reports

A database report presents information found in the database in a formatted, attractive manner.  The information presented may be the database as entered, a database of sorted records,  or only  certain records of the database as found in a search (query).

Reports generally show multiple records per page in table format – with one record being displayed per row of the table.  The columns of the table are the fields of information.  Not all fields need to be displayed in each report.  You may choose which fields to display, the order of the fields and whether a search has taken place.

To create a report:

1) Perform the sort or query as required

2) Create Report

3) Choose the fields to keep in the report – you can decide which fields to delete – this only deletes from the report not from the database

4) In Design View – make the report attractive, add titles – there should be a main title which is the name of the database and a secondary title which is what has been done to the database:

5) Use Print Preview to print the report

eg.

Class Database – sorted by last name

or

Class Database

Sorted by Last name

To Sort

1) Set up the sort Criteria:  Home / Sort and Filter / Advanced / Advanced Filter Sort   – Enter the sort criteria (the first sort is the primary sort, and subsequent sorts break ties – for example – first sort is last name and break ties with first name)

2) Perform the Sort:  Home / Sort and Filter / Advanced / Apply Filter Sort

3) Create a report

To Query

1) Set up the sort Criteria:  Home / Sort and Filter / Advanced / Filter by Form  – Enter the search criteria (for example – last name is Smith)

2) Perform the Query:  Home / Sort and Filter / Advanced / Apply Filter Sort

3) Create a report

Assignment:

Task 1: For the BTA 3O Class Database create the following reports:

1) All students listed in alphabetical order by last name.

2) All students listed in order by age (oldest to youngest)

3) All students that have a last name that starts with A-J

4) All students that like hockey as their favourite sport

For each report decide which fields to display (do not display all fields in all reports)

Task 2: Exercises 17, 22, 25, 34 of database section

 

May 31

Lesson:  Database Features – Reports, Sorts and Queries

 

Database Reports

A database report presents information found in the database in a formatted, attractive manner.  The information presented may be the database as entered, a database of sorted records,  or only  certain records of the database as found in a search (query).

 

Reports generally show multiple records per page in table format – with one record being displayed per row of the table.  The columns of the table are the fields of information.  Not all fields need to be displayed in each report.  You may choose which fields to display, the order of the fields and whether a search has taken place.

 

To create a report:

1) Perform the sort or query as required

2) Create Report

3) Choose the fields to keep in the report – you can decide which fields to delete – this only deletes from the report not from the database

4) In Design View – make the report attractive, add titles – there should be a main title which is the name of the database and a secondary title which is what has been done to the database:

5) Use Print Preview to print the report

 

eg.

Class Database – sorted by last name

or

Class Database

Sorted by Last name

 

To Sort

1) Set up the sort Criteria:  Home / Sort and Filter / Advanced / Advanced Filter Sort   – Enter the sort criteria (the first sort is the primary sort, and subsequent sorts break ties – for example – first sort is last name and break ties with first name)

2) Perform the Sort:  Home / Sort and Filter / Advanced / Apply Filter Sort

3) Create a report

 

To Query

1) Set up the sort Criteria:  Home / Sort and Filter / Advanced / Filter by Form  – Enter the search criteria (for example – last name is Smith)

2) Perform the Query:  Home / Sort and Filter / Advanced / Apply Filter Sort

3) Create a report

 

June 3

Assignment:

Task 1: For the BTA 3O Class Database create the following reports:

1) All students listed in alphabetical order by last name.

2) All students listed in order by age (oldest to youngest)

3) All students that have a last name that starts with A-J

4) All students that like hockey as their favourite sport

 

For each report decide which fields to display (do not display all fields in all reports)

 

Task 2: Exercises 17 (full database report), Exercise 22 update (do not print reports) and Exercise 34 (3 reports) of database section

 

June 4

Database Integration

 

When creating a business presentation it is often necessary to use more than one piece of software to accurately, efficiently and effectively display all information.  Often the use of a word processor is required for the structure of a report, but a database or spreadsheet is used to accurately and efficiently manipulate data.  The integration of software is a useful tool.  To enhance word processing documents it is often necessary include  reports, data or charts from a database or spreadsheet program.

 

Example: Records/Report exported from Database

Doe Tom 15
Jones Sally 18
O’Brien Susie 17
Smith Jane 14
Smith John 17

 

Steps to Export Data and use reports in other applications (Excel or Word):

1. Complete sorts/queries in database program and create a report to display the data

2. Choose Export in the Report Menu (Right click on filename and choose export) and export in format required (Excel or Word)

3. Open the report in required program (Excel or Word) and use as required

 

Assignment:  Create a title page and hand in the following 2 tasks:

Task 1: Exercise 9 on page 393

Task 2:  Create a form letter to everyone in class which outlines information (as outlined below) about our class

– Introduce your letter in paragraph 1

– Paragraph 2 – outline what is being shown in the following charts:

All students in the database sorted by last name in a simple table.

– Paragraph 3 – outline what is being shown in the following table and graph

All student ages displayed in table and a spreadsheet line graph showing the ages graphically

– Provide a conclusion in paragraph 4

– End your letter with an appropriate closing section (ie.  Sincerely,        your name)

– Merge the letter with our class database for names and addresses (print only the first 3 letters of the form letter merge)

 

June 5

Work Period – finish all database assignments and prepare for Thursday’s test

 

June 6

End of Unit:  Database Test

Unit 6: Word processing

Unit 6 – Microsoft Word Wordprocessing

 

May 2-10

Complete the following wordprocessing exercises (from Computer Applications for Business) using MICROSOFT WORD.  If you have difficulty with a concept use Microsoft Word built in program help screens or Google Searches on Microsoft Word concepts.

 

Day 1:  Exercise 2 (page 7), 3, 4, 5, 6, 8, 9, 10, 11, 12, 13

 

Day 2:  Exercises 15, 16, 19, 20, 22, 25, 26, 27, 29

 

Day 3:  Exercises 31, 36, 37, 39. 42. 43, 45, 46, 48, 49

 

Day 4: Exercises 53, 56, 58, 60, 63, 65, 66, 78, 83

 

Day 5:  Exercises 90, 92, 93

 

May 13

Wordprocessing Assignment 1 due

1)  Create a title page for Wordprocessing Assignment 1 (your name, date, name of assignment)

2)  Print the following exercises (put your initials or name on each printed page) and submit them in this order

Exercises:   11, 19, 22, 27, 36, 43, 48, 53, 56, 63, 66, 90, 92, 93

 

 

May 14

No Class – Assembly

 

May 15

Lesson: Advanced MS Word techniques – Templates, Form Letters, Macros

 

1) Templates in MS Word – why reinvent the wheel – many template available from office.com.  You can browse/download templates within Office 365

 

2) Merge Documents (form letters and similar types of documents):  A merge document (form letter) is a document that is generic and allows insertion of specifics from a data file (recipient list) 

 

Assignment: Exercise 70, Exercise 76

 

3) Macros:  Do you have a series of tasks that you perform over and over again?  If so this can be shorted by creating a macro.

 

A macro is a ‘recording’ of a series of commands that you can playback whenever you want by calling upon the macro

 

Example 1 – if I like all my headings in bold, underlined, Arial 16 then I can create a macro to do this

Example 2 – A closing to a block formatted business letter

 

Steps:  View / Macro / Create

Choose a shortcut menu option or shortcut keys (optional)

Record steps

Stop recording

 

Assignment: Exercise 85, record your own letter closing, any other macro you deem efficient, Exercise 89 part I, use your letter closing and other macros in this exercise

 

Final Wordprocessing Assignment:

Part 1 – Exercise 70, 76  

Part 2 – Exercise 85, record your own letter closing, any other macro you deem efficient, Exercise 89 part I, use your letter closing and other macros in this exercise

Part 3 – Pick one command or process in MS Word you did not know about before the exercises (not one discussed in this lesson – maximum 1 person per command).  Make up a short  (approx 2 minutes) MS Powerpoint presentation explaining that command or process.  Use screen captures to enhance your presentation.    Examples of commands/process: decimal formatting, setting margins, creating a table, list outline (numbered lists), footnotes/endnotes, headers/footers, 

 

Print and hand in parts 1 and 2

Presentation for Part 3 – Tuesday, May 21

 

May 16-17

Work Period – Final Wordprocessing Assignment

 

May 21

Final Wordprocessing Assignment due

Presentations for final wordprocessing assignment – save your powerpoint presentation in folder on S: Drive

Unit 5: videos and youtube

Apr 24

Unit 5 – Creating Videos, Uploading to YouTube and Embedding in Webpages

 

Lesson:  Social Media’s Role in Business Part 1 (From Grade 9)

Lesson:  Social Media’s Role in Business Part 2 – YouTube

 

Your Job:  Be a little gutsy and create a Video that

  • establishes a positive presence for you and your business on the internet
  • is a little gutsy so that people remember it
  • Edutains your viewers
  • is embedded in your website to keep people at your website to increase your google ranking
  • reviews or demonstrates your product, tells a story, is social, gives a behind the scene look, other

 

Hardware:

Use your own Device

Use an IPAD

Use Small Wonder Camera

 

Software:

You can use any video creation software that you are familiar with:

 

Windows Moviemaker

Adobe Premier Pro

Other?

 

Resources:

To Download and Install MS Windows Moviemaker

http://windows.microsoft.com/en-CA/windows-live/movie-maker-get-started#t1=overview

 

Windows MS Moviemaker Tutorials:

http://windows.microsoft.com/en-ca/windows-vista/getting-started-with-windows-movie-maker

 

To Download and Install Adobe Premier Pro:

http://www.adobe.com/cfusion/tdrc/index.cfm?product=premiere_pro&loc=en_us

 

Adobe Premier Pro Tutorials:

http://blogs.adobe.com/kevinmonahan/2011/05/20/getting-started-with-adobe-premiere-pro-cs4-cs5-cs5-5/

 

Apr 25

Work Period – Video Project

 

 

Apr 26

Lesson:  Shooting Footage, uploading footage, importing to video editting software, trimming clips, transitions, titles, effects, saving you final video

 

Apr 29

Lesson:  Uploading to Youtube, Embedding into webpage

 

Video Project due end of class Apr 30th

 

Apr 30

Work Period – Video Project

 

May 1

1)  Share your video at this  link.

2)  Embed your video into your webpage and recopy your webpage folder to S: Drive for evaluation

 

 

 

 

 

May 21

Final Wordprocessing Assignment due

Presentations for final wordprocessing assignment – save your powerpoint presentation in folder on S: Drive