The most open source DBMS.
A. Microsoft SQL Server
B. Microsoft Access
C. MySQL
D. Oracle
Select an option to see the answer and solution.
Print options can be changed in the Print _______.
A. tab
B. layout mode
C. setup routine
D. dialog box
Select an option to see the answer and solution.
Which of the following term is least related to database?
A. Attributes
B. Tuples
C. Relationship
D. Columns
Select an option to see the answer and solution.
Which of the following database object produces the final result to present?
A. Forms
B. Reports
C. Queries
D. Tables
Select an option to see the answer and solution.
If a piece of data is stored in two places in the database, then
A. Storage space is wasted
B. Changing the data is one spot will cause data inconsistency
C. It can be more easily accessed
D. Both a and b
Select an option to see the answer and solution.
Which of the following statement is true?
A. Foreign key fields don't allow duplicate values
B. In primary key field you can enter duplicate value
C. In an indexed field you may or may not enter duplicate value depending upon setting
D. All statements are true
Select an option to see the answer and solution.
You can set a controls border type to make the border invisible.
A. Transparent
B. Invisible
C. Do not display
D. No border
Select an option to see the answer and solution.
How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
A. Query Wizard
B. Look up Wizard
C. Form Wizard
D. Report Wizard
Select an option to see the answer and solution.
The _________ Builder is an Access tool for selecting colors from a palette or creating custom colors.
A. Color
B. Expression
C. Palette
D. Property
Select an option to see the answer and solution.
This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
A. Columnar
B. Justified
C. Datasheet
D. Tabular
Select an option to see the answer and solution.
The following database object can you import from one Microsoft Access database to another?
A. Queries
B. Tables
C. Forms
D. All of the above
Select an option to see the answer and solution.
Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
A. Edit Relationships
B. Indexes
C. Option
D. Show Table
Select an option to see the answer and solution.
The _________ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
A. Date
B. Time
C. Calendar
D. Appointment
Select an option to see the answer and solution.
how do you filter by selection?
A. Right click the field value and select filter by selection from the shortcut menu
B. Find and double click the value on which you want to base the filter
C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
D. None
Select an option to see the answer and solution.
The key uniquely identifies each record in a table.
A. primary key
B. key word
C. filed name
D. All of above
Select an option to see the answer and solution.
A _______ often display summary data such as totals or counts.
A. Group Header
B. Group Footer
C. Report Header
D. Page Footer
Select an option to see the answer and solution.
The __________ is used to access one record at a time.
A. query
B. filter
C. form
D. report
Select an option to see the answer and solution.
In the Field List of a table, the primary key appears _______________.
A. bold
B. italicized
C. underlined
D. with key icon
Select an option to see the answer and solution.
In the second subform wizard dialog box you specify the table to use as the data source and the
A. Records from the selected form
B. Form from the selected table
C. Fields from the selected table
D. Content from the selected form
Select an option to see the answer and solution.
Which of the following is a standard file format language for web documents?
Select an option to see the answer and solution.