Computer Science 1032A/B Lecture Notes - Lecture 7: Data Type, Foreign Key

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Louis Magguilli

Document Summary

Compsci 1032 - lecture 7 - access tutorial. Enter access and create a blank database. Will default to tab view - there is also design view, where we can work. All entities in er diagram will become their own tables. Change tab view to design view (top left view" button toggles between tab and. Name table same name as entity - caps or lowercase depending on type. Metadata - table in design view that allows you to edit information. Less than 255 characters - select short text". More than 255 characters - select long text". Can use text, but using date allows for better information processing. Will automatically default to currency default on computer - has to be in cad for assignments. Will never reuse numbers, even if you delete record (stores it forever) - not an issue at all. To ascertain nullable or not, choose yes or no in the. Yes required = not nullable, no required = nullable.