Create a new table displaying the following fields :

1st field: name: CopyCode, data type: BIGINT, AutoValue, primary key

2nd field: name: MovieName, data type: VARCHAR, Length: 50

3rd field: name: YearReleased, data type: BIGINT

Save the table as Copies and close it.

Insert one more field named Notes in the Movies table. Make sure the field is set to hold a text of 1000 or more characters. Save and close the table.

Modify the RetailPrice field in the Movies table to display values in 3 decimal places. Save and close the table.

Set the width of all columns of the Movies table to 3cm in datasheet view. Close the table.

Change the Price field format of the open table into currency. Save and close the table.

Change the Date field format of the open table to 05/18/1903 13:37:46. Save and close the table.

Insert one more field in the Products table using the name Active and the appropriate type so that it allows Yes/No values only. Save and close the table.

Create a new table displaying the following fields:

1st field: Code,type of data: BigInt, PrimaryKey, AutoValue

2nd field: Name,type of data: Text [VARCHAR]

3rd field: Information, type of data: Memo.

Save the table as Names and close it.

Create a new table displaying the following fields:

1st field: Activation,type of data: Date/Time

2nd field: Cost,type of data: Numeric, format: Currency

3rd field: Count, type of data: Numeric

Save the table as Charges and close it.

Apply the appropriate index to the Description field of the Products table that will not allow the input of duplicates. Save the table.

The use of index accelerates…

An index allows …

Which of the following actions can help you decreasing the number of duplicates?

…, format and default value are field associated properties.

How would you reduce the number of duplicates in a database?

A change in the length of a Text field from 10 to 20 it will...

A primary key allows a database user to…

What is a primary key used for?

The type of information that can be saved to a field is defined by …. property.

Changing the length of a text field from 10 to 6 characters will …

Which of the following objects can specific data be saved to?

Every field has associated properties like…

How many data items a table field should provide?

The type of data that can be saved to a field is defined by the …. property.