Introduces key concepts of data management and the use and creation of
relational databases as a business tool. Topics include: views, simple
and advanced queries, create and modify forms and sub-forms, reports,
primary and foreign keys, importing data, formulas, controls and
conditional formatting. Projects apply skills to multiple hands-on
databases of increasing complexity.
| Class: | BTS 168 - Business Data Management Tools |
| Credits: | 5 |
| Instructor: | Debi Griggs |
| Primary Contact: | debi.griggs@bellevuecollege.edu |
| Secondary Contact: | (425) 564-2911 |
| Mail Box: | A242 |
| Office: | A220 |
| Office Hours: | By Appointment Only; Lab hours will be announced at the class site during the first week of classes |
| Materials: |
New Perspectives on Microsoft Access 2010 – Introductory by Adamski |
Finnegan Microsoft Access 2010 is required. Instructions for checking out the software for use during the quarter will be available at the course site. USB (flash) drive recommended. |
| Important note on Textbook: | BTS 268 - Advanced Business Management Tools uses New Perspectives on Microsoft Access 2010 – Comprehensive by Adamski |
Finnegan, ISBN: 978-0-538-79847-1. If you intend to take BTS 168 AND BTS 268, the Comprehensive version of the text may be a better purchase. Either the Introductory or the Comprehesive version can be used for BTS 168, but only the Comprehensive version works for BTS 268. |
| 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. BC 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 |
| Discussions |
| Self-Evaluation |
| Team Project and Peer Evaluation |
| 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 College
IBIT
3000 Landerholm Circle SE
Bellevue, WA 98027
(425) 564-2911
debi.griggs@belleuecollege.edu