|
| Home | Course
Info | Syllabus
| Calendar | Assignments
| Resources | Review |
WebCT
| FAQ |
Last Week's Lesson |
Next
Week's Lesson
| Week
13: At a Glance
|
|
What
We Did Last Week
In Project 1, you learned about databases and database
management systems. You learned how to create a database and how to create
the tables within a database. You saw how to define the fields in a table
by specifying the characteristics of the fields. You learned how to open a
table, how to add records to it, and how to close it. You also printed the
contents of a able. You created a form to view data on the screen and also
created a custom report. You learned how to use Microsoft Access Help.
Finally, you learned how to design a database to eliminate redundancy.
Microsoft Office 2003 Teacher and Student version does not come with
Access. If you have Teacher and Student version and need Access, you can
pick up a copy of Microsoft Office 2003 Professional 30-day trial CD from
me. Make sure to finish all your work within 30 days before it expires.
We will continue to work on
Access 2003 this week. Please do not hesitate to call or email me if you
have any questions. You can also make an appointment to come to my
office if you need help on your course.
Have fun exploring Access!
Top of
the Page
What
You Will Learn This Week
In Project 2, you will create and run a variety of queries. You will
see how to select fields in a query. You will use text data and
wildcards in criteria. You also will use comparison operators in
criteria involving numeric data. You will combine criteria with both AND
and OR. You will see how to sort the results of a query, how to join
tables, and how to restrict the records in a join. You will create
computed fields and calculated statistics. You will learn how to use
grouping as well as how to save a query for future use.
Top of
the Page
After completing this lesson, you will be able to:
Top of
the Page
Activities
for This Week
-
Reading Assignment
- Project 2 in Microsoft Access 2003 section in your textbook.
-
Assignment #9, Part 2 - Querying
a Database Using the Select Query Window
You have
two more weeks to work on this assignment. You will have Part 3 for next week. Email your completed assignment
(Part 1, Part 2 and Part 3) to your instructor at llemley@pjc.edu
as attachments. Remember to type "Your Section #, Assignment 9,
Your Name" in the Subject.
-
MSLQ survey
- You are selected to be in a research study to determine how motivation and
use of learning strategies influence performance. You will be asked to
complete a survey consisting of demographical information and questions correlating to motivation orientation and cognitive/metacognitive
learning strategies. Here is more
information concerning the survey. Please go to
WebCT to answer the MSLQ survey.
Remember to answer all questions and save each one of them before
submitting your survey. Thank you in advance for your participation.
Troubleshooting -
Pop-up
blocking software
The survey appears in a new browser window. If you have pop-up
blocking software installed on your computer, the survey may not appear.
To take the survey, you may have to disable the pop-up blocking
software.
Top of
the Page
Conclusion
At the end of this lesson, you have learned:
To query a database using the select query window.
Assignments
What we will do next
week: Microsoft Access 2003
Home | Course
Info | Syllabus
| Calendar | Assignments
| Resources | Review |
WebCT
| FAQ Last Week's Lesson
Last updated:
09/23/05
|
