To create a table in Access
Which of the following is use to view or print the data in organized manner?
In a table to insert User’s Voice, Data field should be
After creating the table which of the following is correct?
Validation Rule in a field will
Query can be use to select data from
Data can be import into Access Database from
What is the use of Referential Integrity in MS Access?
In MS Access, Field Value may contain
Which of the following is the DBMS type
Which of the following relationship is not valid in MS Access ?
A collection of related tables is called
Which of the following Format supports for Data Type Yes/No?
Queries can be created in Access by
Relationship can be establish between two tables by
What is the use of Cascade Delete Option in MS Access?
Macros can recover from _______ in a controlled manner.
A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
The VB Name used to display the warning message icon is _______.
What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?
A(n) _______ is major object that completes an action or a set of actions.
By default, what is the name of a new module in the Modules folder of the Project pane called?
To assign a macro to an event, users need to open the form in Design View.
In a module, the VB Name used to display a warning query icon is _______.
In a module, a(n) _______ is a series of commands and properties that perform a specific task.
A(n)_______ is a major object that can run independent of a control.
Which of the following statements about option group is incorrect?
The option button ____ identifies each button or check box in an option group.
Which of the following statements about a tab control in a form is incorrect?
The option group ____ describes the contents of the entire option group.
A(n) ____ is the default control for a Yes/No field.
Which of the following components has a property sheet that includes settings for the frame and the option group?
Which control lets a user create multiple pages in a form?
On the property sheet, which of the following tabs contains the Caption property?
Which of the following statements regarding charts is incorrect?
Which of the following options is NOT a part of an option group?
Which of the following is a condensed form of standard generalized markup language?
The content and application of the Search tool CANNOT be retained when you ______.
An organized collection of logically related data is known as
In databases, Locking level is also called as
Which of the following is not a database application?
HSAM stands for ________
Which of the following is not a logical database structure?
In a datasheet, what does each column represent?
In a datasheet, what does each row represent?
A ________ is a unit of information in a ________
What do you call a primary key field included in another table?
Which type of field is incremented automatically?
Which object is used to create a form?
What determines a table’s sort order?
What is an intersection of a row and a column?
Which tool do you use to create a query object?
Which of the following is not a view for interacting with a form object?
What is the purpose of indexing?
Which is the valid data type in Access?
How many relations may exist between tables in databases?
What is the full form of SQL?
Which data type is better to use for storing phone number in the following format “977-1-1234567”?
What do you call a collection of records matching parameters of a query?
Which query do you use to answer the question “Which employees earn more than $5000 a month”?
In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
What does the expression [detail] ! [product] * 1.30 do?
Which criteria return only those addresses beginning with the letter “K”?
Which criteria do not return the position “Officer” as a match?
Which query do you use to answer the question “What is the average salary of the employees”?
What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
How to make a date field DOB store the dates like “2002/10/17” ?
You have field ‘Sex’ of type Byte NumberHow to limit its value to 0 and 1 only?
In Access 2007, to make changes in the Trust Center, you need to go to the ____.
For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.
Which of the following is a standard file format language for web documents?
HTML stands for ____.
In Access 2007, to set a table to open as a document tab, you need to go to the ____.
Which of the following is the file extension for an Extensible Markup Language?
A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
A(n) _____ is an image control that displays in the background of a page on a form or report.
Which colors are used to define a custom color?
If a color property contains “#336699”, how many blue units are in the color?
The _____ function returns a string that has been converted to uppercase text.
Which part of the IIF expression is the action performed if the true condition exists?
If you need a calculation in an unbound control, you can create a custom _____.
The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
Which function evaluates a “true/false” expression and then performs one of two actions?
When adding an image, which size mode will change the height or width of the image fit the control?
The three parts of an IIF function are separated by _____.
A Smart Tag can be set using the _____ tab in the property sheet.
A(n) _____ is a control that, when clicked, executes an action or series of actions.
According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
How can a user open the Expression Builder dialog box?
According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
. You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
The Allow _____ property controls whether new records can be added through the form.
The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.
Which of the following is NOT true about background images?
In a query, what symbol is used to surround a parameter’s user prompt?
A(n) _______________ query locates data from one or more tables.
Which function extracts the name of the month from a date/time value?
Which of the following queries prompts users for input data by displaying dialog boxes?
A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
Which of the following queries modifies fields not records?
A summary query can be created by adding which row to the design grid of a select query?
Which of the following functions is used to all the values in a numeric field?
Which of the following queries can create a table?
In a query, which row do you need to place wildcards to affect a parameter?
. You created a query with two tables that have relationship of One-To-Many with referential rules appliedThe first table has 3 records and the second has 8With using a right outer join, how many records will the resulting recordset have?
Which of the following types of joins displays records with the same value in the common field?
A global join will be created automatically when using tables in a(n) _____.
Which of the following is the default join between two recordsets?
. In a query’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
What is an index?
. You created a query with two tables that did NOT have a join lineThe first table has 12 records and the second has 5The resulting recordset would have how many records?
Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
In a junction table, the _____ field consists of the foreign key from both the linked tables.
What does an inner join display?
The page count of a report can be determined by clicking the _______ button.
When you add fields in ____, a Field List pane displays.
Any report, including a basic report, can be modified in __.
A ____ often display summary data such as totals or counts.
Which of the following can a Report Wizard NOT do?
. ______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.
Which report section prints once at the bottom of every printed page?
Which report section only prints one time at the end of the report?
Which of the following database objects can have more than one Group Header/Footer section?
Which of the following statements about the Label Wizard is NOT true?
Which of the following views enables users to create and modify the sections of a form?
To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
Which Form tool creates a new form that show both a form and datasheet views?
Which of the following statements about tab order setting is NOT true?
What type of controls are text boxes when data from the recordset is visible?
When increasing the Control Padding, space is added where?
Which of the following is NOT possible when printing Forms?
To apply an AutoFormat to an entire Form, what must you select first?
Which is NOT an option of the Picture Size Mode property?
Which mode sizes an image to fit the control while maintaining the proportions of the original image?
Which of the following views is used to graphically summarize and analyze data in a recordset?
Which of the following statements about criteria in a query is NOT true?
Which of the following statements does NOT hold true for the Top Values property?
Which of the following statements about calculated fields is NOT true?
Using the keyword _______________ will return records in which the field value equals a defined text.
What is the process of eliminating redundant fields by separating data into tables called?
Which of the following statements about PivotChart View is NOT true?
Which of the following search criteria is invalid?
In a query, using the keyword _______________ will return records in which the field value is between two numbers.
Which of the following database objects extracts information from one or more tables or queries?
Referential integrity cannot be set for _______________ relationships.
A relationship is created between how many tables?
. The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
Which of the following is use to view or print the data in organized manner?
In a table to insert User’s Voice, Data field should be
After creating the table which of the following is correct?
Validation Rule in a field will
Query can be use to select data from
Data can be import into Access Database from
What is the use of Referential Integrity in MS Access?
In MS Access, Field Value may contain
Which of the following is the DBMS type
Which of the following relationship is not valid in MS Access ?
A collection of related tables is called
Which of the following Format supports for Data Type Yes/No?
Queries can be created in Access by
Relationship can be establish between two tables by
What is the use of Cascade Delete Option in MS Access?
Macros can recover from _______ in a controlled manner.
A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
The VB Name used to display the warning message icon is _______.
What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?
A(n) _______ is major object that completes an action or a set of actions.
By default, what is the name of a new module in the Modules folder of the Project pane called?
To assign a macro to an event, users need to open the form in Design View.
In a module, the VB Name used to display a warning query icon is _______.
In a module, a(n) _______ is a series of commands and properties that perform a specific task.
A(n)_______ is a major object that can run independent of a control.
Which of the following statements about option group is incorrect?
The option button ____ identifies each button or check box in an option group.
Which of the following statements about a tab control in a form is incorrect?
The option group ____ describes the contents of the entire option group.
A(n) ____ is the default control for a Yes/No field.
Which of the following components has a property sheet that includes settings for the frame and the option group?
Which control lets a user create multiple pages in a form?
On the property sheet, which of the following tabs contains the Caption property?
Which of the following statements regarding charts is incorrect?
Which of the following options is NOT a part of an option group?
Which of the following is a condensed form of standard generalized markup language?
The content and application of the Search tool CANNOT be retained when you ______.
An organized collection of logically related data is known as
In databases, Locking level is also called as
Which of the following is not a database application?
HSAM stands for ________
Which of the following is not a logical database structure?
In a datasheet, what does each column represent?
In a datasheet, what does each row represent?
A ________ is a unit of information in a ________
What do you call a primary key field included in another table?
Which type of field is incremented automatically?
Which object is used to create a form?
What determines a table’s sort order?
What is an intersection of a row and a column?
Which tool do you use to create a query object?
Which of the following is not a view for interacting with a form object?
What is the purpose of indexing?
Which is the valid data type in Access?
How many relations may exist between tables in databases?
What is the full form of SQL?
Which data type is better to use for storing phone number in the following format “977-1-1234567”?
What do you call a collection of records matching parameters of a query?
Which query do you use to answer the question “Which employees earn more than $5000 a month”?
In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
What does the expression [detail] ! [product] * 1.30 do?
Which criteria return only those addresses beginning with the letter “K”?
Which criteria do not return the position “Officer” as a match?
Which query do you use to answer the question “What is the average salary of the employees”?
What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
How to make a date field DOB store the dates like “2002/10/17” ?
You have field ‘Sex’ of type Byte NumberHow to limit its value to 0 and 1 only?
In Access 2007, to make changes in the Trust Center, you need to go to the ____.
For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.
Which of the following is a standard file format language for web documents?
HTML stands for ____.
In Access 2007, to set a table to open as a document tab, you need to go to the ____.
Which of the following is the file extension for an Extensible Markup Language?
A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
A(n) _____ is an image control that displays in the background of a page on a form or report.
Which colors are used to define a custom color?
If a color property contains “#336699”, how many blue units are in the color?
The _____ function returns a string that has been converted to uppercase text.
Which part of the IIF expression is the action performed if the true condition exists?
If you need a calculation in an unbound control, you can create a custom _____.
The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
Which function evaluates a “true/false” expression and then performs one of two actions?
When adding an image, which size mode will change the height or width of the image fit the control?
The three parts of an IIF function are separated by _____.
A Smart Tag can be set using the _____ tab in the property sheet.
A(n) _____ is a control that, when clicked, executes an action or series of actions.
According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
How can a user open the Expression Builder dialog box?
According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
. You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
The Allow _____ property controls whether new records can be added through the form.
The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.
Which of the following is NOT true about background images?
In a query, what symbol is used to surround a parameter’s user prompt?
A(n) _______________ query locates data from one or more tables.
Which function extracts the name of the month from a date/time value?
Which of the following queries prompts users for input data by displaying dialog boxes?
A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
Which of the following queries modifies fields not records?
A summary query can be created by adding which row to the design grid of a select query?
Which of the following functions is used to all the values in a numeric field?
Which of the following queries can create a table?
In a query, which row do you need to place wildcards to affect a parameter?
. You created a query with two tables that have relationship of One-To-Many with referential rules appliedThe first table has 3 records and the second has 8With using a right outer join, how many records will the resulting recordset have?
Which of the following types of joins displays records with the same value in the common field?
A global join will be created automatically when using tables in a(n) _____.
Which of the following is the default join between two recordsets?
. In a query’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
What is an index?
. You created a query with two tables that did NOT have a join lineThe first table has 12 records and the second has 5The resulting recordset would have how many records?
Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
In a junction table, the _____ field consists of the foreign key from both the linked tables.
What does an inner join display?
The page count of a report can be determined by clicking the _______ button.
When you add fields in ____, a Field List pane displays.
Any report, including a basic report, can be modified in __.
A ____ often display summary data such as totals or counts.
Which of the following can a Report Wizard NOT do?
. ______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.
Which report section prints once at the bottom of every printed page?
Which report section only prints one time at the end of the report?
Which of the following database objects can have more than one Group Header/Footer section?
Which of the following statements about the Label Wizard is NOT true?
Which of the following views enables users to create and modify the sections of a form?
To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
Which Form tool creates a new form that show both a form and datasheet views?
Which of the following statements about tab order setting is NOT true?
What type of controls are text boxes when data from the recordset is visible?
When increasing the Control Padding, space is added where?
Which of the following is NOT possible when printing Forms?
To apply an AutoFormat to an entire Form, what must you select first?
Which is NOT an option of the Picture Size Mode property?
Which mode sizes an image to fit the control while maintaining the proportions of the original image?
Which of the following views is used to graphically summarize and analyze data in a recordset?
Which of the following statements about criteria in a query is NOT true?
Which of the following statements does NOT hold true for the Top Values property?
Which of the following statements about calculated fields is NOT true?
Using the keyword _______________ will return records in which the field value equals a defined text.
What is the process of eliminating redundant fields by separating data into tables called?
Which of the following statements about PivotChart View is NOT true?
Which of the following search criteria is invalid?
In a query, using the keyword _______________ will return records in which the field value is between two numbers.
Which of the following database objects extracts information from one or more tables or queries?
Referential integrity cannot be set for _______________ relationships.
A relationship is created between how many tables?
. The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
No comments:
Post a Comment