INFX 502 - Course Information
This information is updated as changes are made and applies to the next offering of the course.
Upon completion of the course, the student will be able to:
- Explain and discuss the terminology and concepts of structured database systems.
- Explain and discuss the concepts of tables, data types and key fields.
- Build a simple table to be linked to existing tables.
- Perform various simple queries using SQL and QBE skills.
- Discuss future directions in databases in large information systems.
|GO! with Microsoft Access 2013 Comprehensive
by Shelley Gaskin, Carolyn McLellan, and Nancy Graviett
Publisher: Prentice Hall (Spiral Bound, 736 pp)
There may be other versions of the book which include less or more material respectively, may have different exercises and may cost more.
The assignments can be done with a used book if you want to save a few bucks.
Note the Kindle versions and rental versions sometimes are often missing resources like Appendices and sample files, BUT we can generally work around that by me adding the materials to the Web site – so let me know if that happens.
Course Description and Syllabus
INFX 502 – Database Concepts for Information Professionals (1 Cr): Introduces the terminology and concepts of working with relational database management systems. Emphasizes working with tables and extracting information from data using Structures Query Language (SQL) commands and tools. Prepares students for advanced database design courses, web design, and programming courses. Credit / no credit only. Prerequisite: none. (Prepares students for INFX 543 and INFX 544)
Course Description PDF - Also contains the Syllabus Schedule
Software Required for this course:
- Microsoft Access 2013
- The software is also available in the 4th floor labs in Mary Gates Hall
- There is no MAC version of the software.
- You will need to have access to a Windows computer.
- Many Mac users also already own Parallels or Fusion from VMWare allowing them to run Windows applications.
- Macs can also run BootCamp to dual-boot between OS X and Windows.
Software available Free to course students at: Microsoft DreamSpark.
- Version to get: Access 2013 is part of Office Professional for Windows;
- If you have trouble getting the software from Microsoft DreamSpark, it system uses a unique login and password - not your UW NetID and password.
- iSchool students: Information on how to log into the Microsoft DreamSpark site would have been emailed to your @uw.edu email address. The email would have come from the address "firstname.lastname@example.org", so, even though it is a legitimate email, please be sure to check your spam folder.
- Non-iSchool students: The iSchool Help Desk (iHelp@uw.edu) can help you get an ID and answer your questions.
To order for download
- Go to this site to login: Microsoft DreamSpark
- Center Click the LOGIN button on the left to login.
- Login with your UW email address and enter the DreamSpark password
- You should now be able to download the program.
- If you forgot your password, on the right side, there is a dialog box that says "Login Help", and a link to click if you forgot your password. Click that link and when asked for your username enter your UW email address, ie. email@example.com Your password will be emailed to you.
- If you need help ordering or installing the software, the iSchool Help Desk (iHelp@uw.edu) is well versed in helping you with Microsoft software.
Courses I Teach
Career Resources Data Visualization Infographics Privacy Articles Things to Ponder MOOCs
Last updated: Monday, 21-Mar-2016 22:48:40 PDT
© 2013 Bob Larson
All rights reserved