MS Access 2003 Test

MS Access 2003 Test

 

Which property of a table is used to locate the back-end database to which the table is linked?

a. Dependencies Property

b. Table Defs Connect property

c. Link Chitd Fields Property

d. Table Defs order by property

Which of the following statements is correct regarding Crosstab queries?

a. Multiple Value fields can be specified

b. Multiple Column Headings can be specified

c. Multiple Row headings can be specified

Using ADO or DAO, how are the records fetched from a recordset?

a. Use a For Loop with Next, without Move Next, while checking for EOF

b. Use a D..Loop with Move Next, while checking for EOF

c. Use While Loop with Wend, while not checking for EOF

How is data in a single record kept together on a page (for a report) or on a column (for a form)?

a. By setting the Keep Together property to Yes

b. By setting the Single Page Print property to Yes

c. By setting the Data Together property to Yes

d. This feature is currently not available in Access

In a report with grouping, how can you display the count of records in each group?

a. Add a text box to the group’s Page Footer, and its control source to “=Count(*)”

b. Add a text box to the group’s Footer section, and its control source to “=[RecordCount]”

c. Add a text box to the group’s Report Footer, and its control source to “=[RecordCount]”

d. Add a text box to the group’s Footer section, and its control source to “=Count(*)”

In Access 2003, one can control the user access to data, through permissions. The Update data permission allows a user to:

a. view and modify but not insert or delete data

b. view, modify, insert and delete data

c. view, modify and insert but not delete data

d. view but not modify, insert or delete data

Which of the following is not a section of a report?

a. Summary

b. Detail

c. Group Footer

d. Report Footer

What does an Access Data Projects (ADP) offer that an MDB/ACCDB doesn’t?

a. It can perform heterogeneous queries across a variety of data sources

b. It is tied directly to one SQL Server database and can create and modify SQL Server objects

c. It supports temporary tables or links to other data sources beyond the single SQL Server database

Which of the following is not done when you compact a database?

a. Restructuring table records and objects, and then stores them in successive memory blocks

b. Database linked to the compacted database are compacted and repaired

c. Restores table records into their primary key order, if a primary key exists in the table

d. Reduces the physical size of your database by making an exact duplicate of the database

Which of the following statements about Report Snapshots is unture?

a. The Snapshot Viewer allows you to share Access reports with people who do not have Access installed

b. Report Snapshots can only be viewed from within Access or the Access Runtime

c. A Report Snapshot preserves the two-dimensional layout, graphics, and other embedded objects of the report

d. Report Snapshots allow you to share reports electronically

What is the function of Format Painter?

a. It copies a Table Design to the buffer for later use

b. It copies a control’s format to another control

c. It helps to format a report so that it looks tidy and presentable

d. It copies a report design to the buffer for later use

If a table named students has a column called Student name storing the names of the students, what will be the correct query to display the names of the students in reverse alphabetical order?

a. Select Student name from students reverse

b. Select Student name from students reverse name

c. Select Student name from students order by name descending

d. Select Student name from students order by name Reverse

e. Select Student name from students order by Student name desc

f. Select desc Student name from Students   

g. Select Reverse Student name from Students

What does an MDB/ACCDB offer that isn’t available in an ADP?

a. It can create client/server applications

b. It can create and modify SQL Server objects

c. It can perform heterogeneous queries across a variety of data sources

d. None of the above

If a relationship has the ‘Cascade Update Related Field’s option on, which of the following is true?

a. Data in linked fields cannot be updated

b. When a parent record is updated, all child records in the linked table are updated

c. Null or blank values cannot be entered into the table

d. Data in the linked tables can be updated, but new data cannot be added

If a user has a database opened in the Exclusive mode, what will happen if another user attempts to open the same database?

a. The second user will receive the ‘Permission denied’ message

b. 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

c. The second user receives the ‘File already in use’ message

d. Both users will receive the ‘Permission denied’ message

Which of the following is the easiest and fastest method to manipulate records on a subform?

a. Using a Record set Type Property

b. Using a Record Set Clone Property

c. Using a Record Selectors Property

d. Using a References Property

What will be the result of the following:

SELECT InStr(1, “John”, “0”);

a. 1

b. 2

c. True

d. False

Which Text box property should be set to expand the text box to display the whole text when there is too much to be accommodated in the text box in Access reports?

a. Text Format

b. CanGrow

c. Control Source

d. Name

Which of the following enhanced security features are included in Access 2003?

a. Enhanced security features to help decrease the chances of Access 2003 being targeted in malicious attacks

b. Enhanced security features for Microsoft Jet functions

c. Digital signatures

d. All of the above

Which datatype would be the most suitable to store a hyperlink in a field of an Access 2003 table?

a. Memo

b. varchar

c. Text

d. Hyperlink

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?

a. Microsoft Access locks the row that is being updated

b. Microsoft Access locks the page that is being updated

c. Microsoft Access locks table that is being updated

d. Microsoft Access locks the database that is being updated

Which of the following options most clearly defines the meaning of a bound HTML Control on a Data Access Page?

a. A Control that is bound to the HTML code residing online on a Web Server

b. A Control that displays information in the HTML code which is later used for publishing data on the internet

c. A Control that is bound to the HTML code showcasing the data from a particular field of a table

d. A Control that computes user defined expressions and stores the result in a table in the form of the HTML code  

What is the file extension of an Access Project?

a. .adp

b. .xml

c. .mdb

d. .mdf

What role does Strcomp function perform in Microsoft Access 2003?

a. 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

b. 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

c. It compares the number of blank spaces contained in two different strings and returns the difference as an integer

d. It compares two strings for equivalence and returns the integer result of the comparison

Which condition should be satisfied to help create a one-to-one relationship between tables?

a. The Primary key and the Foreign key fields must have a unique index

b. The Indexed property for the Primary key and the Foreign key fields should be set to ‘Yes’

c. The common fields must have a unique index

d. All of the above

Password protected databases offer:

a. Only one password with full rights

b. Different user rights for different logins/passwords

c. Options for data editing rights versus the right to change designs

d. Integrated security with Active Directory

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?

a. Indexed

b. Limit to List

c. Input Mask

d. Allow Value List Edits

An .mde file is a special version of an Access .mdb file and contains information related to a database. Which of the following is ture about an .mde file?

a. It contains complied VBA code to prevent uses from viewing code

b. It allows users to view, but not modify VBA code

c. It can be saved as an .mdb file in order to make design changes

d. It allows users to import forms and reports from other databases

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?

a. All users have the query owner’s permission to view or run the query

b. Only the query owner can save changes to the query and other networked users cannot use the open database simultaneously

c. It enables other network users to use the open database simultaneously

d. Only the query owner can change the ownership of the query

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 (including constraints, relationships, and indexes).

a. True

b. False

The primary key index does not allow ___________ data in a field.

a. numeric

b. character

c. date

d. duplicate

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 column.

What will be the result of the following query?

Select Department from Company where Department < ‘Finance’

a. The query will return “Accounts, Human Resource”

b. The query will return “Accounts, Administration, Human Resource”

c. The query will return “Administration”

d. Strings cannot be compared using the < operator

e. The query will return “Accounts, Administration”

A query that uses the BETWEEN syntax for two numbers is identical to:

a. >= and <=

b. > and <

c. >= and <

d. > and <=

e. No such syntax

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?

a. NewRowOrCol property

b. ForceNewPage property

c. SetNewPage property

d. ForceNewRow property

Which datatype would be the most suitable to store a Hyperlink in a field of an Access 2003 table?

a. char

b. varchar

c. hyperlink datatype

d. nchar

e. nvarchar

Which of these functions determines if a phrase exists in a longer string?

a. InStr

b. Len

c. Trim

d. Left

Which clause will be used to display the rows of a table in an ascending order of a particular column?

a. Where

b. Order By

c. Group By

d. Having

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 Products table is deleted, what will happen when users run Query1?

a. Only the data of the Products table will be retrieved

b. Only the data of the Orders table will be retrieved

c. An error will be generated

d. The data will be successfully retrieved

What is the advantage of a Class module over Regular module, in Access database solution?

a. Encapsulation, inheritance

b. Data Abstraction

c. Polymorphism

d. Reusability

How can you tell if a report has no records to display or print?

a. NotlnList event is triggered

b. ApplyFilter event is triggered

c. NoData event is triggered

d. Filter event is triggered