Microsoft Access 1) Design view is used to create a table from scratch. True or
ID: 3891782 • Letter: M
Question
Microsoft Access
1) Design view is used to create a table from scratch.
True or Flase
2) When a table is created in Design View, a primary key field is automatically assigned.
True or False
3) Field validation rules are used to create range and data format integrity rules by limiting entries to a certain range of values or making sure entries match a specified format.
True or False
4) Data integrity rules ensure that the data in a database is accurate and consistent.
Ture or False
5)Lookup fields display a list of data values from which the user can choose.
True or False
Explanation / Answer
Answer)
Microsoft Access
1) Design view is used to create a table from scratch.
Answer)
True - Tables can be created in Design View from the scratch.
2) When a table is created in Design View, a primary key field is automatically assigned.
Answer)
False - The primary key field for the table has to be assigned by you using the Design View.
3) Field validation rules are used to create range and data format integrity rules by limiting entries to a certain range of values or making sure entries match a specified format.
Answer)
True - A validation rule is used to create range and data format integrity rules, also match an expression when entering or changing records.
4) Data integrity rules ensure that the data in a database is accurate and consistent.
Answer)
True - Data integrity means to maintain the accuracy and consistency of the data.
5)Lookup fields display a list of data values from which the user can choose.
Answer)
True - Lookup fields display a list of data values from which the user can choose.