COMPSCI 1BA3 Study Guide - Final Guide: Referential Integrity, Link Group, Logical Connective
6 Dec 2013
School
Department
Course
Professor
Document Summary
Backstage = select current/existing dbase or create new (blank or template) [see. Query = ask dbase a question = english rdbms syntax; form (input), report (output) Navigation pane database objects; datasheet view direct entry of fields and records. Organizing data: the first step is to identify each entity, and its individual attributes. Entity: a person, object or event: next, define each entity"s attributes as a set of fields; each access entity is called a table. Each field (i. e. , column) has a specific data-type. A set of field values is called a record (i. e. , row: enter data values into your table(s) and store the data as an access 2010 file (. accdb) An access table is a two-dimensional representation of a relation. Other design models for database structure: network, hierarchical. Keys involving more than one field are referred to as composite, concatenated or compound keys. Pk must have unique values; no duplicates allowed.
