June 18

Exam Review

Notebook Link Check

Advertisements
Posted in Uncategorized | Leave a comment

June 10-17 – Summative

Summative Assignment

Posted in Uncategorized | Leave a comment

June 6

End of Unit:  Database Test

Posted in Uncategorized | Leave a comment

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)

Posted in Uncategorized | Leave a comment

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

Posted in Uncategorized | Leave a comment

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

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

Posted in Uncategorized | Leave a comment

May 28-30 – Unit 7 – Microsoft Access Database

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)

Posted in Uncategorized | Leave a comment