| Home > Calendar > Lesson 5 | |||||
|
Home | Course Info | Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ Last Week's Lesson | Next Week's Lesson
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 table. 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. In Project 2, you created and ran a variety of queries. You saw how to select fields in a query. You used text data and wildcards in criteria. You also used comparison operators in criteria involving numeric data. You combined criteria with both AND and OR. You saw how to sort the results of a query, how to join tables, and how to restrict the records in a join. You created computed fields and calculated statistics. You learned how to use grouping as well as how to save a query for future use. In Project 3, you learned how to maintain a database. You saw how to use Form view to add records to a table. You learned how to locate and filter records. You saw how to change the contents of records in a table and how to delete records from a table. You restructured a table, both by changing field characteristics and by adding a new field. You saw how to make changes to groups of records and how to delete groups of records. You learned how to create a variety of validation rules to specify a required field, specify a range, specify a default value, specify legal values, and specify a format. You examined the issues involved in updating a table with validation rules. You also saw how to specify referential integrity. You learned how to view related data by using subdatasheets. You learned how to order records. Finally, you saw how to improve performance by creating single-field and multiple-field indexes.
Test #4 is scheduled on Tuesday/Thursday at 6 p. m. in Room 2146. You can also take the test at any one of the PJC test centers during the week from Monday to Thursday during their testing hours. Make sure to call ahead and make an appointment. Tuesday/Thursday night test is set up for people who work during the day and can't go to the test center.
Please do not hesitate to call or email me if you have any questions.
After completing this lesson, you will be able to:
Home | Course Info | Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ Last Week's Lesson | Next Week's Lesson
Last updated: 06/26/06 |
|||||