| MSBA 504 | ||
| Session Two | ||
| Assignment Due: Assignment One | ||
| Assignment Two | ||
| Session Materials | ||
| chapter one powerpoint | ||
| remote into uark epic | ||
| horizon vm client (download from pdf) | ||
| access lab assignment | ||
| https://waltonlab.uark.edu/ | ||
| Session Topics | ||
| Introduction to Access | ||
| Introduction to Queries | ||
| Reintroduction to UARK EPIC remote | ||
| Importing Excel to Access | ||
| Learning Objectives | ||
| Describe the main functions of a database management system | ||
| understand the layout of database IDE | ||
| Learn how to remote access into guac and epic | ||
| relational algebra | ||
| explain and use query by example (QBE) | ||
| understand different types of queries | ||
| Session Deliverables | ||
| Combined database from excel | ||
| Access lab assignment | ||
| Schedule | ||
| 1230 | Session Begins | |
| 1230-115 | more on chapter 1, discussion of access IDE, queries type | |
| 115-220 | creating database from excel, assignment 3 | |