COMPSCI 1BA3 Chapter Notes -Sentence Spacing, Logical Connective, Kerning

• School: McMaster University
• Department: Computer Science
• Course: COMPSCI 1BA3
• Professor: Anthony Hurst

Document Summary

Field value - first set of field values (very top row) Record the set of data under the field value. Primary key uniquely field represented a record. Foreign key relationship of field between two different tables (dbsm) database management system software programing system. Relational database management system- common field of data collected in tables. Data type the field value you enter. Autonumber inserts a unique number in the fields of every record. Layout view make design changes to the form while its displaying data, so that you can see the effects of the changes you make immediately. Composite key a combination of two primary keys. Caption property sets the field name as the 1st set of data. Byte whole numbers (numbers with no fractions) Single- positive and negative numbers up to seven decimal places. Double- stores positive and negative numbers to 15 decimal places. Replication id- unique identifier for replication of tables, records, and other objects in databases.