The expression builder is an access tool that controls an expression___ for entering an expression
Table
Box
Cell
Palette
- When creating a new table which method can be used to choose fields from standard databases and tables
- A small button with three dots usually displayed at the right of field properties box
- What is the difference between Open and Open Exclusively?
- To create primary key for a table when in design view
- How can you define a field so that when entering data for that field it will display ****** instead…
- Which of the following is not a field type in Access
- What do you mean by one to many relationship between Student and Class table?
- The___ operator will cause a record to be selected only if two or more conditions are satisfied
- It is a query that when run displays its own dialog box prompting you for information, such as
- Which of the following database object produces the final result to present?
- The size of a field with Number data type can not be
- The key uniquely identifies each record in a table.
- What is the maximum length a text field can be?
- A composite key is
- The task of arranging data in order is called
- This option allows you to build a new table by entering data directly into the datasheet.
- A __ name must be unique within a database
- Which of the following expresses correct order?
- Unlike text data type, this can store up to maximum of 65, 535 characters.
- We can remove a relationship defined between two tables by
- What is a form in MS Access
- This key uniquely identifies each record
- Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…
- Which of the following is a method to create a new table in MS Access?
- It is a sign or symbol that specifies, operator, and values that produce a result
- Which of the following is not a database object?
- Which of the following statement is true?
- The expression builder is an access tool that controls an expression___ for entering an expression
- To sort records in a table
- Following is not a database model