ACIS 1504 Study Guide - Midterm Guide: Wildcard Character, Spreadsheet, Data Type

• School: Virginia Tech
• Department: Accounting and Information Systems
• Course: ACIS 1504
• Professor: E A Martin

Document Summary

Acis 1504 exam 3 study guide: 3 applied erd questions, applied wildcard character question: question mark/ asterick. Like (cid:862) son*(cid:863) (cid:449)ould gi(cid:448)e you results like onfield, onstein. Like (cid:862)*son(cid:863) would give results like sampson, johnson, smithson, etch. Like (cid:862)*son*(cid:863) (cid:449)ould gi(cid:448)e results likemarkson(cid:448)ille, bo(cid:271)sonstein, et(cid:272): benefits of database definitional question. Big ones were increased data integrity, reduction of data anomalies, reduction of data. Data independence: storing data separately from the programs that act upon it: when to use a data base versus spreadsheet applied question. Data base can keep track of many themes, whereas spreadsheet can only keep track of one. Db are good for data with multiple themes, good to report multiple subsets of. Data( like list of emails for one set of customers and mailing labels for another set of customers). Access properties definitional question = properties define various characteristics of fields. Input mask (specifies a pattern that must be matched to be accepted and stored.