MIS 342 Final Exam
Covers all material discussed in class
Open book, open notes, open class recordings
Must use Access for Hands-On problems
Need to be able to access \\store\classes\20201000007 for exam.
Make
sure to verify this before the exam. See tech support
if you have problems. I
do not control access to this folder!
Hands on problems using Access.
Problems similar to those on Midterms 1 and 2
There will be the following types of problems on the final exam.
- Outer Join queries
- Calculated fields in queries, forms, reports
- Domain aggregate functions
- XML data exports
- Form controls
- Evaluating Expressions in the Immediate Window
- Preserving/archiving data
- Indexing considerations
- Application performance issues
- Application licenses, cost issues
- Access vs Crystal Reports
- Action queries
- Unmatched queries
- Database design issues and considerations-indexes, data preservation
- Relational database, calculating data from tables
- Evaluating expressions using the Immediate Window
- Access vs MySQL vs SQL Server
- Understanding importance of data to an organization