2004

Create a new table to display the following fields:

1st field: name:CopyCode,data type: AutoNumber-Long Integer, primary key

2nd field: name: MovieName,data type: Short Text, number of characters: 50

3rd field: name:YearReleased,data type: Number-Long Integer

Save the table as Copies and close it.

2007

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.

2008

Set the Movies table in design view. Move the Notes field of the Movies table right after the YearReleased field. Save and close the table.

2009

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

2011

In datasheet view, set the width of all columns of the Movies table to 30pt. Save and close the table.

2032

In the Customers table insert a new field named sex in short text data type and set field size in 50. The user will be able to choose between Male or Female only. Save and close the table.

2034

Apply a validation rule to the RetailPrice field in the Movies table, so that prices higher than 100 are not accepted. Save and close the table.

2035

Apply a validation rule to the RetailPrice field in the Movies table to allow entering only prices equal to or higher than 2 and equal to or lower than 100. When the user types different prices, the system will return the message Acceptable values from 2 to 100

Save and close the table.

2068

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

2069

Locate the Description field of the open table and apply an input mask to display the word new always at the beginning followed by an empty space and a maximum of 10 letters chosen by the user. Save and close the table.

2070

Change the Date field format of the open table to Long date and the input mask into Short date. Save and close the table.

2071

Set a validation rule in the Date field of the open table to allow entering equal or greater dates than the current date. Save and close the table.

2073

Change the order of the columns as follows, without modifying the table structure:

1st column Description,

2nd column Price,

3rd column Code.

Save and close the table.

2122

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.

2190

Create a new table displaying the following fields:

1st field:Name: Code,type of data: AutoNumber

2nd field:Name: FirstName,type of data: Short Text.

3rd field:Name: Information,type of data: Long Text.

Save the table as Names and close it.

2191

Create a new table to display the following fields:

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

2nd field: name: Cost,type of data: Currency

3rd field: name: Count,type of data: Number

Save the table as Charges and close it.

2824

Insert a validation rule in the YearOfOrder field of the Orders table which allows to enter previous years only. Save the table.

2825

Insert the appropriate input mask in the PhoneNumber field of the Customers table, so that the value of the field is displayed in the following form (2310) 888-771

Save the table.

2843

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

10135

Where is the information stored in the database?

10137

Every record of a database should store data on more than one objects.

10807

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

10905

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

11751

Every field has associated properties such as…

11752

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

11755

How many data items should a table field contain?

11756

____________, format and default value are field associated properties.

11757

What is a primary key used for?

11761

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

11766

Which of the following objects is used to store relevant data?

11767

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

11768

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

12845

The use of indexes accelerates

12849

An index allows …

12850

A primary key allows a database user to…