Computer Science MCQ - Set 7

In the Relationship window, related fields from each table are connected by a(n) _______________.
Relationships between tables can be graphically viewed in the _______________ window.
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?
In the Field List of a table, the primary key appears _______________.
What type of relationship is created when you select a primary key in both related tables?
The Table _______________ Wizard analyzes a database and recommends changes for normalization.
The Input Mask wizard does NOT include the ability to do which of the following?
Which of the following field properties enforces the use of parentheses when keying an area code?
Which of the following field properties is an expression that specifies criteria or requirements for entering data?
In Datasheet View, what appears at the top of each column?
Which is NOT a method of creating a table?
Which of the following views displays the field name, description, and properties of a table?
Which of the following properties identifies the type of information stored in a field?
Which of the following field properties displays a model or pattern for entering data?
Which of the following data types automatically generates a consecutive number?
Database properties do NOT include ___________.
To remove all Sorts in a table you can click the ______ command.
A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
The Search tool CANNOT be used on which major Access object?
In a table, ______(s) are displayed in the order in which they were enteredMost often this order is not useful.
The ______ is a wild card that represents one or more characters.
Which is not an option for Filter on a text field?
The Search tool is best used when searching for ______ data.
. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
Which of the following functions CANNOT be used in the Totals row?
. Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.
What is the keyboard shortcut to move to the last records in a table?
A ____ is a major database object used to display information in an attractive, easy-to-read screen format.
Print options can be changed in the Print ____.
Which major database object stores all data?
The insertion point looks like a(n) ____.
Access file operations can be found by clicking the ____.
 A ____ is a major database object used to display information in a printable page format.
In Datasheet View, new records are added to a table ____.
What happens when a user selects a record in a form and presses [Delete]?
Which of the following CANNOT be done to data using a Form?
What is one of the advantages for using a form over other Access objects?
Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?
A(n) ____ in the Record Selector indicates a new record.
All attachment fields display as a(n) ____ in Datasheet View.
Which of the following methods CANNOT be used to delete records from a table?
Where can you find the undo command in Access?
An application that executes on separate PCs like this is called a(n) __________ application.
The most popular commercial DBMS.
The ability of a database to grow as the data tracking needs grow is its __________.
The most open source DBMS.
A DBMS that runs on many different operating systems is said to be __________.
Search engines use a(n) __________ to automatically index sites.
The __________ performs document tracking.
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.
__________ will answer questions you did not think to ask of your data.
__________ is the clear leader for personal databases.
The __________ is the software tool to store or access data.
__________ are documents that when filled in create records.
This database has only one table.
The __________ field is used to hold a yes or no answer.
To delete records or perform calculations on a table, the best tool to use is a __________.
__________ is used to build ‘intuitive’ queries.
To print information from a table, the __________ tool is the best choice.
To store your picture in a database requires a(n) __________ field.
The __________ is used to access one record at a time.
SQL stands for __________.
What are the different views to display a table
Which of the following creates a drop down list of values to choose from?
The command center of access file that appears when you create or open the MS Access database file.
In a database table, the category of information is called __________
It is an association established between common
This is the stage in database design where one gathers and list all the necessary fields for the database project.
Which of the field has width 8 bytes?
Which of the following statement is true?
Following is not a database model
Microsoft Access is a
Dcl provides commands to perform actions like
The database language that allows you to access or maintain data in a database
What is the maximum length a text field can be?
which of the following is not a database object?
A __________ enables you to view data from a table based on a specific criterion
What are the columns in a Microsoft Access table called?
Which of the following is not a type of Microsoft Access database object?
Which of the following database object hold data?
Which of the following store command to retrieve data from database?
Which of the following database object produces the final result to present?
What is the difference between ‘open’ and ‘open exclusively’
In table design view, which key can be used to switch between the field names and properties panels?
The default and maximum size of text field in access
Which of the following is not a field type in access
Which field type can store photos?
When entering field name, how many characters you can type in maximum?
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
Queries in access can be used as
To create queries in access
What is a form in MS Access
Which of the following statement is true
Two tables can be linked with relationship so that the data integrity can be enforcedWhere can you find relationship command
While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
What do you mean by one to many relationship between student and class table?
Referential integrity means
Cascade delete option
Cascade update option
We can remove a relationship defined between two tables by
If you need to edit a relationship
If you write criteria values vertically (one in a row) it will mean
To achieve and effect when you are entering criteria in a query design window
A search value can be an exact value or it can be
Both conditions display on the same row in the design grid when ___operator is in use
You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
The___ operator will cause a record to be selected only if two or more conditions are satisfied
When a picture or other graphic image is placed in the report header section it will appear____
The__ button on the tool box display data from a related table
You can set a controls border type to make the border invisible.
A __ name must be unique within a database
The expression builder is an access tool that controls an expression___ for entering an expression
The key uniquely identifies each record in a table.
Unlike text data type, this can store up to maximum of 65, 535 characters.
It is a database object to view, change, and analyze data in different ways
It is most common type of queryIt retrieves records from one or more tables and then displays the
Which of the following methods cannot be used to enter data in a cell
Which of the following will not cut information?
Which of the following is not a way to complete a cell entry?
You can activate a cell by
Text formulas: