Introduces students to database software and prepares them to work in an environment where data is managed electronically. Basic principles of analysis, design, creation, storing, retrieval, manipulation of electronic files, form and report generation are covered.
| Class: | BTS 168 - Advanced Database Applications |
| Credits: | 5 |
| Instructor: | Debi Griggs |
| Phone: | (425) 564-2911 |
| E-Mail: | dgriggs@bellevuecollege.edu |
| Mail Box: | A242 |
| Office: | A220 |
| Office Hours: | By Appointment Only |
| Materials: |
New Perspectives on Microsoft Access 2007 – Introductory by Adamski |
Finnegan Microsoft Access 2007 is required. Instructions for checking out the software for use during the quarter will be available at the course site. USB (flash) drive recommended. |
| Student Data: | Student Data at the course site. |
Design, create, and modify tables, queries, forms and reports
Add, change and delete records ensuring data and referential integrity
Find, replace, sort, and group data
Create forms and reports using wizards
Select and create the appropriate query to answer specific questions
Create and modify tables, queries, forms and reports in design view
Customize forms and reports using application controls
Perform calculations in queries, forms, and reports
Use AND, OR, and NOT logical operators in query design
Explain relational database and application-specific terms and concepts
Use standards for naming conventions
Perform self-assessment for Microsoft certification skills
If a situation occurs during the quarter that affects a student’s ability to complete the work, the student must contact the instructor immediately. Any student who finds that he or she cannot manage the workload is encouraged to withdraw.
If you need course modifications/adaptations or accommodations because of a disability, I can refer you to our Disability Resource Center (DRC). You may contact them directly by going to B132 or by calling 425.564.2498 or TTY 425.564.4110. Information is also available on their website at http://bellevuecollege.edu/drc/
You are expected to conduct yourself with integrity. If you cheat or aid someone else in cheating, you violate trust. Cheating includes, but is not limited to copying or providing answers on tests, stealing, plagiarizing or illicitly using the materials of others. BCC has a due process for students accused of cheating—See WAC 132H120 in the Office of the Dean of Students.
| Assignment |
| Tutorials with End-of-Tutorial Activities |
| Quizzes |
| E-mails |
| Self-Evaluation |
| Team Project |
| Total |
Most of your grade will come from the Tutorials, Review Assignments and Case Problems. Becoming proficient in Access is achieved by using the software for many hours. Homework gives you the opportunity to immerse yourself in the Access software and perform the mental exercise necessary to really understand Access. The weight of each activity can vary with the number of tasks required. The Assignments are located on the Assignments page.
There is a significant amount of homework in this class. You can expect to spend at least 12 hours per week to complete the assigned work. Be sure that you can spend the time this quarter. If you are overloaded, this may not be the quarter for you to take Access.
You are expected read the text, explore Help, use Web resources, discussion with classmates, and post problems you encounter when working on these projects.
Late Work: Any work received after the due date is considered late. Late work may be discounted or not accepted.
This course may include team projects.
Debi Griggs
Bellevue Community College
3000 Landerholm Circle SE
Bellevue, WA 98027
(425) 564-2911
dgriggs@bellevuecollege.edu