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 (full database report), Exercise 22 update (do not print reports) and Exercise 34 (3 reports) of database section

Advertisements

May 27

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

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”

Answers to questions 

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/ 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 Mode)

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

2) Enter your personal information into the database (Browse Mode)

3) Print a copy of your completed data entry form (Print from Browse Mode)

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 22

Macro Presentations

Lesson:  Introduction to Adobe InDesign (Desktop Publishing)

Assignment:

Complete the following Desktop Publishing Exercises using Adobe InDesign:  Ex 1 (page 152), 6, 11, 12, 15, 17, 18, 20

May 21

Final Wordprocessing Assignment due

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

BONUS:  Exercise 94 – use 2 book macros and your two created macros when completing this exercise.  Send the letter to 3 of your friends using a merge file