A company has the following departments: Finance, Accounts, Human Resources, Administration There is a table named Company having a column named Department, and the above values are stored in that...
The query will return "Accounts, Human Resource" 0.0%
The query will return "Accounts, Administration ,Human Resource" 0.0%
The query will return "Administration" 0.0%
Strings cannot be compared using the < operator 50.0%
The query will return "Accounts, Administration" 50.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.0%
Only the data of the Orders table will be retrieved. 0.0%
An error will be generated. 100.0%
The data will be successfully retrieved. 0.0%
A query that uses the BETWEEN syntax for two numbers is identical to:
>= and <= 100.0%
> and < 0.0%
>= and < 0.0%
> and <= 0.0%
No such syntax 0.0%
An .mde file is a special version of an Access .mdb file and contains information related to a database. Which of the following is true about an .mde file?
It contains compiled VBA code to prevent users from viewing code. 100.0%
It allows users to view, but not modify VBA code 0.0%
It can be saved as an .mdb file in order to make design changes. 0.0%
It allows users to import forms and reports from other databases 0.0%
How a form can be made Read-only?
In the form properties window, set the form's Read only property to Yes 0.0%
In the form properties window, set the AllowEdits property to No, set the AllowAdditions to No and set the AllowDeletions property to No 100.0%
In the form properties window set the form's Data entry property to No 0.0%
How can the duplicate data on a report be hidden?
By Setting the HideDuplicates property to Yes 100.0%
By Setting the DuplicateRecords property to No 0.0%
By Setting the DuplicateRecords property to No and setting the GrpKeepTogether property to Per Page 0.0%
Duplicate Data should be handled at the time of data entry and cannot be controlled while reporting 0.0%
How can you tell if a report has no records to display or print?
NotInList event is triggered 0.0%
ApplyFilter event is triggered 0.0%
NoData event is triggered 100.0%
Filter event is triggered 0.0%
How do you create a report for a crosstab query if certain column headings are missing?
Set the Value field in the crosstab 0.0%
Set the Column Heading field in the crosstab 100.0%
Set the Row Heading field in the crosstab 0.0%
Explicitly set the Pivot list in the crosstab 0.0%
How do you customize the text on a form or report's window frame or tab?
TabIndex Property 100.0%
Text Property 0.0%
Form Property 0.0%
Caption Property 0.0%
How do you import a portion of an Excel spreadsheet into Access?
TransformXML Method 0.0%
ImportXML Method 0.0%
TransferSpreadsheet Method 100.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.0%
Set the database's AllowBypassKey property to False 100.0%
Set the database's AllowBuiltInToolbars property to False 0.0%
Set the database's StartupShowDBWindow property to False 0.0%
How do you start an Access application so that the user can't see or use the database container?
Set the Access Option to hide the navigation pane, and press CTRL+F11 special keys. 0.0%
Set the Access Option to hide the navigation pane, and press ALT+F1 special keys. 0.0%
Set the Access Option to hide the navigation pane, and turn off special keys to prevent F11. 100.0%
Set the Access Option to hide the navigation pane, and press CTRL+G special keys . 0.0%
How is data in a single record kept together on a page (for a report) or on a column (for a form)?
By setting the KeepTogether property to Yes 100.0%
By setting the SinglePagePrint property to Yes 0.0%
By setting the DataTogether property to Yes 0.0%
This feature is currently not available in Access 0.0%
If a relationship has the 'Cascade Update Related Fields' option on, which of the following is true?
Data in linked fields cannot be updated. 0.0%
When a parent record is updated, all child records in the linked table are updated. 100.0%
Null or blank values cannot be entered into the table. 0.0%
Data in the linked tables can be updated, but new data cannot be added. 0.0%
If a table named students has a column called Studentname storing the names of the students, what will be the correct query to display the names of the students in reverse alphabetical order?
Select Studentname from students reverse 0.0%
Select Studentname from students reverse name 0.0%
Select Studentname from students order by name descending 0.0%
Select Studentname from students order by name Reverse 0.0%
Select Studentname from students order by Studentname desc 100.0%
Select desc Studentname from Students 0.0%
Select Reverse Studentname from Students 0.0%
If a user has a database opened in the Exclusive mode, what will happen if another user attempts to open the same database?
The second user will receive the 'Permission denied' message 0.0%
The second user can make changes to the file that has been opened by the first user, and the first user will receive the "File is being modified by another user" message 0.0%
The second user receives the 'File already in use' message 100.0%
Both users will receive the 'Permission denied' message 0.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 Page Footer, and its control source to "=Count(*)" 0.0%
Add a text box to the group's Footer section, and its control source to "=[RecordCount]" 0.0%
Add a text box to the group's Report Footer, and its control source to "=[RecordCount]" 0.0%
Add a text box to the group's Footer section, and its control source to "=Count(*)" 100.0%
In Access 2003, one can control the user access to data, through permissions. The Update data permission allows a user to:
view and modify but not insert or delete data 100.0%
view, modify, insert and delete data 0.0%
view, modify and insert but not delete data 0.0%
view but not modify, insert or delete data 0.0%
In which of the following ways does choosing an appropriate datatype help while designing a table in Access?
It saves space in your database 0.0%
It can improve join operations 0.0%
It could lead to fast data retrieval and updates 0.0%
All of the above 100.0%
On which event do you place code to validate the entry of an entire record?
BeforeUpdate 100.0%
Initialize 0.0%
Load 0.0%
Click 0.0%
Password protected databases offer:
Only one password with full rights 100.0%
Different user rights for different logins/passwords 0.0%
Options for data editing rights versus the right to change designs 0.0%
Integrated security with Active Directory 0.0%
State whether True or False. Access 2003 provides theme support to Microsoft Windows XP.
State whether True or False. When a table from an Access database is exported to another database format, Microsoft Access exports the table data and data definitions, as well as its properties (i...
The Database Splitter is one of the database utilities. Which of the following is true about the Database Splitter?
This utility splits a Microsoft Access database into three files 0.0%
This utility breaks up the information in the tables into a compacted format for faster retrieval 0.0%
This utility segregates the tables from the queries, forms, reports, macros, and modules 100.0%
All of the above 0.0%
The primary key index does not allow ________ data in a field.
numeric 0.0%
character 0.0%
date 0.0%
duplicate 100.0%
Under the Advanced options for the Access system, there is an option entitled Open Databases Using Record Level Locking. Which of the following are true when this option is checked?
Microsoft Access locks the row that is being updated 100.0%
Microsoft Access locks the page that is being updated 0.0%
Microsoft Access locks the table that is being updated 0.0%
Microsoft Access locks the database that is being updated 0.0%
Under the Advanced options in Access 2003, there is a Default Open Mode Group option which includes the options Shared and Exclusive. Which of the following is true when the Shared option is selected?
All users have the query owner's permission to view or run the query 0.0%
Only the query owner can save changes to the query and other networked users cannot use the open database simultaneously 0.0%
It enables other network users to use the open database simultaneously 100.0%
Only the query owner can change the ownership of the query 0.0%
Using ADO or DAO, how are the records fetched from a recordset?
Use a For Loop with Next, without MoveNext, while checking for EOF 0.0%
Use a Do..Loop with MoveNext, while checking for EOF 100.0%
Use a While Loop with Wend, while not checking for EOF 0.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.0%
It is tied directly to one SQL Server database and can create and modify SQL Server objects 100.0%
It supports temporary tables or links to other data sources beyond the single SQL Server database 0.0%
What does an MDB/ACCDB offer that isn't available in an ADP?
It can create client/server applications 0.0%
It can create and modify SQL Server objects 0.0%
It can perform heterogeneous queries across a variety of data sources 0.0%
None of the above 100.0%
What is Option Explicit?
It is a Database object 0.0%
Requires variable declarations 100.0%
It contains all of the data access pages that are currently open in a Microsoft Access project. 0.0%
It contains all open standard modules and class modules in a Microsoft Access database. 0.0%
What is the advantage of a Class module over Regular module, in Access database solution?
Encapsulation, inheritance 0.0%
Data Abstraction 0.0%
Polymorphism 100.0%
Reusability 0.0%
What is the file extension of an Access Project?
.adp 100.0%
.xml 0.0%
.mdb 0.0%
.mdf 0.0%
What is the function of a Format Painter?
It copies a Table Design to the buffer for later use 0.0%
It copies a control's format to another control 0.0%
It helps to format a report so that it looks tidy and presentable 100.0%
It copies a report design to the buffer for later use 0.0%
What property for a table is used to locate the back-end database, to which the table is linked?
Dependencies Property 0.0%
TableDefs Connect property 100.0%
LinkChildFields Property 0.0%
TableDefs orderbyon property 0.0%
What role does Strcomp function perform in Microsoft Access 2003?
It compares the length of two strings and returns the value 1 if the difference is even and the value 0 if the difference is odd 0.0%
It compares the number of capital letters, small letters and spaces in two strings and returns the result as an integer between 0 and 255 0.0%
It compares the number of blank spaces contained in two different strings and returns the difference as an integer 0.0%
It compares two strings for equivalence and returns the integer result of the comparison 100.0%
What type of query do you use to modify existing records
Insert query 0.0%
Delete query 0.0%
Update query 100.0%
Select query 0.0%
What will be the result of the following: SELECT InStr(1, "John", "o");
1 0.0%
2 100.0%
True 0.0%
False 0.0%
When a user has a database open in Exclusive mode, what will happen when another user attempts to open the database?
The second user receives a 'Permission denied' message 0.0%
The second user can make the changes to the file that has already being opened by the first user and first user receives the "File is being modified by another user" 0.0%
The second user receives a 'File already in use' message 100.0%
Both the user will receives a 'Permission denied' message 0.0%
Which clause will be used to display the rows of a table in an ascending order of a particular column?
Where 0.0%
Order By 100.0%
Group By 0.0%
Having 0.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 100.0%
The Indexed property for the Primary key and the Foreign key fields should be set to 'Yes' 0.0%
The common fields must have a unique index 0.0%
All of the above 0.0%
Which datatype would be the most suitable to store a hyperlink in a field of an Access 2003 table?
Memo 0.0%
varchar 0.0%
Text 0.0%
Hyperlink 100.0%
char 0.0%
hyperlink datatype 100.0%
nchar 0.0%
nvarchar 0.0%
Which form property determines whether the current record has been modified since it was last saved?
Dirty property 100.0%
LocationOfComponents Property 0.0%
Dependencies Property 0.0%
ServerFilterByForm Property 0.0%
Which of the following enhanced security features are included in Access 2003?
Enhanced security features to help decrease the chances of Access 2003 being targeted in malicious attacks 0.0%
Enhanced security features for Microsoft Jet functions 0.0%
Digital signatures 0.0%
All of the above 100.0%
Which of the following is not a section of a report?
Summary 100.0%
Detail 0.0%
Group Footer 0.0%
Report Footer 0.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.0%
Databases linked to the compacted database are compacted and repaired. 100.0%
Restores table records into their primary key order, if a primary key exists in the table 0.0%
Reduces the physical size of your database by making an exact duplicate of the database. 0.0%
Which of the following is the easiest and fastest method to manipulate records on a subform?
Using a RecordsetType Property 0.0%
Using a RecordSetClone Property 0.0%
Using a RecordSelectors Property 0.0%
Using a References Property 100.0%
Which of the following options most clearly defines the meaning of a bound HTML Control on a Data Access Page?
A Control that is bound to the HTML code residing online on a Web Server 0.0%
A Control that displays information in the HTML code which is later used for publishing data on the internet 0.0%
A Control that is bound to the HTML code showcasing the data from a particular field of a table 100.0%
A Control that computes user defined expressions and stores the result in a table in the form of the HTML code. 0.0%
Which of the following statements about Report Snapshots is untrue?
The Snapshot Viewer allows you to share Access reports with people who do not have Access installed. 0.0%
Report Snapshots can only be viewed from within Access or the Access Runtime. 100.0%
A Report Snapshot preserves the two-dimensional layout, graphics, and other embedded objects of the report. 0.0%
Report Snapshots allow you to share reports electronically. 0.0%
Which of the following statements is correct regarding Crosstab queries?
Multiple Value fields can be specified 0.0%
Multiple Column Headings can be specified 100.0%
Multiple Row headings can be specified 0.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.0%
Limit to List 0.0%
Input Mask 100.0%
Allow Value List Edits 0.0%
Which of these functions determines if a phrase exists in a longer string?
InStr 100.0%
Len 0.0%
Trim 0.0%
Left 0.0%
Which property of a table is used to locate the back-end database to which the table is linked?
Dependencies Property 0.0%
TableDefs Connect property 100.0%
LinkChildFields Property 0.0%
TableDefs orderbyon property 0.0%
Which property of the Group Header, group footer, or detail section should be changed if we want each group or record in a report to start on a new page?
NewRowOrCol property 0.0%
ForceNewPage property 100.0%
SetNewPage property 0.0%
ForceNewRow property 0.0%
Which query will you use to count the number of records in a result set?
Select count(*) as total from students 100.0%
Select count(amount) as total from students 0.0%
Select total from students 0.0%
Select * from students 0.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?
Text Format 0.0%
CanGrow 100.0%
Control Source 0.0%
Name 0.0%