Computer: Chapter 2 - Access - Creating a Database
Computer Chapter 2 Access - Creating a Database Exercise A 1. access 2. record 3. value 4. Query 5. memo Exercise B 1. False 2. True 3. True 4. True 5. False 6. False Exercise C 1. Rows and columns 2. Value 3. .accdb [note: the dot (.) should also be put before accdb] 4. OLE object 5. Primary key 6. 255 Exercise D Ans 1: Unique name given to each field in the table is known as the field name. Ans 2: Data type controls what type of data can be stored. Ex: We cannot enter letters if the data type of that field is ‘Number’. Ans 3: It allows you to enter a detailed description of all the fields within the table. Ans 4: A validation rule is used to limit a field entry to meet certain criteria. Exercise E 1. Record: It is a row in a table that contains information. Field: It is a column in a table that contains information within a record. 2. Datasheet View: It is used to create a table quickly. It gives general names to field such as Fi...