A calculated control may be applied to a field by using:
Format 0%
RecordSource 0%
Default 0%
ControlSource 0%
A company has the following departments: Marketing , Designing , Production , Packing What will be the result of the following query? Select department from table where department < 'Marketing'
The query will return "Designing, Packing" 0%
The query will return "Designing, Production" 0%
The query will return "Production, Packing" 0%
The query will return "Designing" 0%
A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named Query1, which combines the data from the tables. If the Prod...
Only the data of the Products table will be retrieved. 0%
Only the data of the Orders table will be retrieved. 0%
An error will be generated. 0%
The data will be successfully retrieved. 0%
A query that uses the BETWEEN syntax for two numbers is identical to:
>= and <= 0%
> and < 0%
>= and < 0%
> and <= 0%
No such syntax 0%
By using ADO or DAO, how can you fetch the records from a recordset?
By using a For Loop with Next, without MoveNext, while checking for EOF 0%
By using a Do..Loop with MoveNext, while checking for EOF 0%
By using a While Loopwith Wend, while checking for EOF 0%
Choose the appropriate Query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in the descending order of th...
Select * from Products order by CurrentStock,ProductGroup 0%
Select * from Products order by CurrentStock DESC,ProductGroup 0%
Select * from Products order by ProductGroup,CurrentStock 0%
Select * from Products order by ProductGroup,CurrentStock DESC 0%
None of the above 0%
Consider the following tables: Books --------- BookId BookName AuthorId SubjectId PopularityRating (the Popularity of the book on a scale of 1 to 10) Language (such as French, English, G...
Select bookname from books where language='German' and popularityrating =(Select popularityrating from books where language='French') 0%
Select bookname from books where language='German' and popularityrating > (Select popularityrating from books where language='French') 0%
Select bookname from books where language='French' and popularityrating > (Select max(popularityrating) from books where language='German') 0%
Select bookname from books where language='German' and popularityrating >(Select max(popularityrating) from books where language='French') 0%
From Access 2007 you can link to SharePoint and:
can view data in read-only mode 0%
can view and edit data 0%
can modify field definitions 0%
From the figure, how would you filter the table to return only the students whose last name begins with 'a', 'o', or 'y'?
Select lastname from students where lastname like '[a,o, y]*' 0%
Select lastname from students where lastname like '*[a, o, y]' 0%
Select lastname from students where lastname not like '*[a, o, y]' 0%
Select lastname from students where lastname not like '[a,o, y]*' 0%
Select lastname from students where lastname='a' or lastname='o'or lastname='y' 0%
How can you tell if a report has no records to display or print?
NotInList event is triggered 0%
ApplyFilter event is triggered 0%
NoData event is triggered 0%
Filter event is triggered 0%
How do you create a report for a crosstab query if certain column values are missing?
Set the Value field in the crosstab 0%
Set the Column Heading field in the crosstab 0%
Explicitly set the Pivot list in the crosstab 0%
How do you customize the text on a form or report's window frame or tab?
TabIndex Property 0%
Text Property 0%
Form Property 0%
Caption Property 0%
How do you import a portion of an Excel spreadsheet into Access?
TransformXML Method 0%
ImportXML Method 0%
TransferSpreadsheet Method 0%
How do you prevent a user from skipping the startup routines when opening an application?
Set the database's AllowBreakIntoCode property to False 0%
Set the database's AllowBypassKey property to False 0%
Set the database's AllowBuiltInToolbars property to False 0%
Set the database's StartupShowDBWindow property to False 0%
How do you start an Access application so that the user can't see or use the Navigation Pane (or database container)?
Set the Access Option to hide the navigation pane, and press CTRL+F11 special keys. 0%
Set the Access Option to hide the navigation pane, and press ALT+F1 special keys. 0%
Set the Access Option to hide the navigation pane, and turn off special keys to prevent F11. 0%
Set the Access Option to hide the navigation pane, and press CTRL+G special keys . 0%
How does a column with the AutoNumber data type make a good primary key?
It ensures that no IDs are the same 0%
It never allows users to enter whatever value they want to use as the ID. 0%
It can be left blank or null if desired 0%
It allows two rows to have the same primary key 0%
How many databases can be opened at one time in a single instance of Access 2007?
One 0%
Two 0%
Ten 0%
Unlimited 0%
If you want an image on a report to stay the same size, regardless of the size of the image control, what value should you choose for the Size Mode property?
Stretch 0%
Clip 0%
Zoom 0%
All of the above 0%
In a report with grouping, how can you display the count of records in each group?
Add a text box to the group's Footer section, and its control source to "=Count(*)" 0%
Set the report's "Group Count" property to True 0%
Add a label to the group's Header section, and set the Caption property to "Count Rows" 0%
Add a Summary control to the report's Footer section. 0%
In the given picture, a total is accumulated from record to record across a group. Which feature has been used to achieve this result?
Cumulative property 0%
Totals property 0%
Running sum property 0%
None of the above 0%
In which of the following form sections is a Title control placed?
Detail 0%
Form Header 0%
Page Header 0%
Page Footer 0%
On which event do you place code to validate the entry of an entire record?
BeforeUpdate 0%
Initialize 0%
Load 0%
Click 0%
Out of the following, which one can be used as a comparison operator?
Password protected databases offer:
Only one password with full rights 0%
Different user rights for different logins/passwords 0%
Integrated security with Active Directory 0%
Refer to the given picture and fill up the blank. "Count Values" are not available for fields of the _________ data type(s) while using the Layout view.
Memo 0%
OLE Object 0%
Hyperlink 0%
Memo, OLE Object and Hyperlink 0%
State whether the following statement is true or false: By default, Access deletes the related data when records from a table are deleted.
State whether true or false. In Access 2007, a Checkbox cannot be used as a calculated control
State whether true or false. OLE Object fields cannot be searched.
Suppose you have a table which has a field that looks up a value from a second table called Product. The second table, Product has 2 fields - product name and product id (a number). Using the looku...
Column Heads 0%
Column Widths 0%
Column Count 0%
Bound Column 0%
The Database Splitter is one of the database utilities. Which of the following is true about the Database Splitter?
This utility segregates the tables from the queries, forms, reports, macros, modules, and shortcuts to the Data Access Pages 0%
This utility splits a Microsoft Access database into three files 0%
This utility breaks up the information in the tables into a compacted format for faster retrieval 0%
What can you do in report view that you can't do in print preview?
You can Filter, copy, search, etc. 0%
You can make most, but not all, changes to your report 0%
You can display the structure of your report 0%
What does an Access Data Projects (ADP) offer that an MDB/ACCDB doesn't?
It can perform heterogeneous queries across a variety of data sources 0%
It is tied directly to one SQL Server database and can create and modify SQL Server objects 0%
It supports temporary tables or links to other data sources beyond the single SQL Server database 0%
What does an MDB/ACCDB offer that isn't available in an ADP?
It can create client/server applications 0%
It can create and modify SQL Server objects 0%
It can perform heterogeneous queries across a variety of data sources 0%
What is Option Explicit?
It is a Database object 0%
Requires variable declarations 0%
It contains all of the data access pages that are currently open in a Microsoft Access project 0%
It contains all open standard modules and class modules in a Microsoft Access database 0%
What is the function of the 'Single Step' tool in macros as shown in the picture?
When the macro is run in this mode, each expression is saved one at a time 0%
When the macro is run in this mode, each action is performed one at a time 0%
When this option is clicked, all queries are saved in a single step 0%
When this option is clicked, all reports are saved in a single step 0%
What type of query do you use to modify existing records
Insert query 0%
Delete query 0%
Update query 0%
Select query 0%
What will be the output of the following query in Access 2007? select 10/0
Divide by zero error encountered. 0%
#Error 0%
The denominator of a calculated field is zero 0%
When a report is opened in Design view, which of the following statements is true:
Sub-reports contained in the report are opened as separate windows. 0%
Sub-reports contained in the report can be modified in the same window as the parent report. 0%
Sub-reports contained in the report can be viewed, but cannot be modified. 0%
Sub-reports contained in the report are hidden in design view. 0%
When a user has a database open in Exclusive mode (as shown in the given picture), what will happen when another user attempts to open the database?
The second user can open the database and make changes to objects and data. 0%
The second user receives a 'File already in use' message. 0%
The second user receives a 'File is deleted' message. 0%
The second user can open the database and make changes to data, but not to objects. 0%
When does the Switch function return a value that is Null?
When none of the expressions is true 0%
When the first True expression has a corresponding value that is Null 0%
Both a and b 0%
Neither a nor b 0%
Which condition should be satisfied to help create a one-to-one relationship between tables?
The Primary key and the Foreign key fields must have a unique index 0%
The Indexed property for the Primary key and the Foreign key fields should be set to 'Yes' 0%
The common fields must have a unique index 0%
All of the above 0%
Which datatype would be the most suitable to store a Hyperlink in a field of an Access 2007 table?
char 0%
varchar 0%
hyperlink 0%
nchar 0%
Which form property determines whether the current record has been modified since it was last saved?
Cycle property 0%
Dirty property 0%
Filter property 0%
FilterOn property 0%
Which lookup field property determines the value from the RowSource that is stored in the lookup column?
Column Heads 0%
Column Widths 0%
Column Count 0%
Bound Column 0%
Which of the following clauses is not allowed in a sub-query?
is Null 0%
where 0%
order by 0%
Which of the following data types does bound text box support?
Memo 0%
Currency 0%
Hyperlink 0%
All of the above 0%
Which of the following function returns an array, when a string is split using a delimiter?
Str function 0%
String function 0%
StringParts function 0%
Split function 0%
Which of the following functions returns an array, when a string is split using a delimiter?
Str function 0%
String function 0%
StringParts function 0%
Split function 0%
Which of the following is not a section of a report?
Summary 0%
Detail 0%
Group Footer 0%
Report Footer 0%
Which of the following is not done when you compact a database?
Restructuring table records and objects, and then stores them in successive memory blocks. 0%
Databases linked to the compacted database are compacted and repaired. 0%
Restores table records into their primary key order, if a primary key exists in the table 0%
Reduces the physical size of your database by making an exact duplicate of the database. 0%
Which of the following is not true regarding naming a file?
File names are case sensitive 0%
File names can be up to 255 characters long including any file name extension 0%
Either uppercase or lowercase letters can be used in file names 0%
Some keyboard characters can cause unexpected results if used in file names 0%
Which of the following is the easiest and fastest method to manipulate records on a subform?
Using a RecordsetType Property 0%
Using a RecordSetClone Property 0%
Using a RecordSelectors Property 0%
Using a References Property 0%
Which of the following is true about the Ribbon interface?
Ribbons can be dragged and dropped to be on the side or the bottom of the screen. 0%
Ribbons can be minimized or collapsed 0%
Ribbons can be replaced with command bars 0%
Which of the following options clears a sort order without affecting the current filter?
"Clear All Sorts" button on the Home tab, in the Sort and Filter group. 0%
"Unsort" button on the Database Tools tab, in the Records group. 0%
"Sorted" button at the bottom of the Object window, next to the Record Navigator. 0%
Which of the following options lets you resize multiple controls at the same time to maximum fitted control size?
Select the controls, click on the Arrange tab, and click the "Equal Horizontal" button in the Position group 0%
Select the controls, click on the Arrange tab, and click the "Equal Vertical" button in the Position group 0%
Select the controls, click on the Arrange tab, and click the "To Grid" button in the Size group 0%
Select the controls, click on the Arrange tab, and click the "To Widest" button in the Size group 0%
Which of the following placeholders and literal characters can be used in an input mask?
L 0%
? 0%
. , : ; - / 0%
All of the above 0%
Which of the following statements is correct regarding Crosstab queries?
Multiple Value fields can be specified 0%
Multiple Column Headings can be specified 0%
Multiple Row headings can be specified 0%
Which of the following statements is not true about the "Work Offline" option in an Access database linked to SharePoint:
Working offline allows you to work on SharePoint data locally. 0%
Within Access, only SharePoint users have the permissions to view data. 0%
"Discard Changes" lets you reject all changes made while offline. 0%
Which of the following table properties defines criteria to display only matching rows in the Datasheet view?
SubdatasheetName 0%
ValidationText 0%
ValidationRule 0%
Filter 0%
Which of the following table views allows editing of records in a table?
Datasheet 0%
Design 0%
PivotChart 0%
PivotTable 0%
Which of the given text field properties should you set in order to force a user to enter a date value specifically in MM-DD-YYYY format?
Indexed 0%
Limit to List 0%
Input Mask 0%
Allow Value List Edits 0%
Which of the given text field properties you should set in order to force a user to enter a date value specifically in MM-DD-YYYY format?
Indexed 0%
Limit to List 0%
Input Mask 0%
Allow Value List Edits 0%
Which of these functions determines if a phrase exists in a longer string?
InStr 0%
Len 0%
Trim 0%
Left 0%
Which one of the following correctly selects rows from the table myTable that have null in column1?
Select * from myTable where column1 is null 0%
Select * from myTable where column1 = null 0%
Select * from myTable where column1 EQUALS null 0%
Select * from myTable where column1 NOT null 0%
Select * from myTable where column1 CONTAINS null 0%
Which Text box property should be set to expand the text box to display the whole text when there is too much text to be accommodated in the text box in Access reports?
CanGrow 0%
Reading Order 0%
Display When 0%
None of the above 0%
Which textbox property determines that the text box is bound?
ControlSource 0%
RowSource 0%
RecordSource 0%
FieldSource 0%
Which type of Control Layout does the given picture display?
Tabular 0%
Stacked 0%
Static 0%
Tab 0%
Which view should be chosen for form modification when form sections (such as the form header or the detail section) have to be resized?
Layout view 0%
Design view 0%
PivotTable view 0%
Any of the above 0%
You want to create a table that includes a Description field. If you want to ensure that the Description field accepts rich text formatting, which datatypes should you use?
OLE Object 0%
Memo 0%
Attachment 0%
Text 0%