Knowledge Check

  1. The Extends and Supports Inheritance properties: The Supports Inheritance property can be selected as “Yes” or “No” to determine if a table supports inheritance. The Extends property is used to determine which table will be inherited from or extended.​
  2. Yes: Field groups store logical groupings of fields, such as different fields relating to an address. If fields are added to a field group, and that field group is used on a form, the form will automatically update to reflect the new fields that were added to the field group on the table.​
  3. An index is used to improve the speed of data retrieval: The main purpose of an index is to increase the speed of retrieving data.​
  4. A string with T-SQL: The view method for a computed column should return T-SQL to be executed on the SQL Server. In the DictView class, you can use the method computedColumnString to generate T-SQL. The SysComputedColumn class provides helpful syntax for more complicated computed columns.​