40 likes | 162 Vues
Prepare for the CPSC 203 midterm exam scheduled for March 3rd at 6:00 PM in Science Theatre 140 and 148. The exam will last one hour and consists of multiple-choice questions. Ensure you bring pencils and erasers, as electronic devices are not permitted. Familiarize yourself with key concepts including table design, data type options, field size, and primary keys, all essential for success in the course. Please review these topics thoroughly to perform well in the exam.
E N D
CPSC 203Introduction to Computers Lab 39, 40 By Jie (Jeff) Gao
Midterm Exam • Date and time: • March 3, Wednesday • 6:00 PM • Location: Science Theatre 140 & 148 • Duration: 1 hour • Type: Multiple choice • Please prepare pencils and erasers • No electronic devices allowed CPSC Labs by Jie Gao
Table Design • Data type options • Field size • Format • Decimal places • Required • Some data types in detail • AutoNumber • Number • Date/Time CPSC Labs by Jie Gao
Primary Key • A field in a table • Its value can uniquely identify each record, i.e. no two records have the same value in this field • It is often the field like “ID” • We can define a primary key in the design view • Access can automatically add a primary key in AutoNumber type CPSC Labs by Jie Gao