Computer Science 1032A/B Lecture Notes - Lecture 18: Microsoft Access, Unique Key, Foreign Key

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

Document Summary

Introduction to access: creating, tables, data entry forms. Creating a database: select new blank , enter filename and location, select create . Starting in access 2003: @ right select new file, select blank database, provide file name & location. Objects: tables, queries, reports, forms, macros, modules. Creating a table: two ways to create a table, table templates, design a table yourself, every field, name, data type, primary key makes each record unique, properties characteristics of an object. Table views: datasheet view, add records, edit records, delete records, design view, create fields, modify fields. Table views: datasheet view, used to add, modify, delete and view records. Design view: used to create and modify the fields in a tab. Datasheet view: primary key field, primary keyidentifies each record as being unique. Design view: click f6 to switch between the upper and lower panes. Creating tables: create data model, transform model into database design, primary key, foreign key, rows (records, columns (fields)