MS Access 2003, Databases

Question: What is the file extension of an Access Project?
A
.adp

B
.xml

C
.mdb

D
.mdf

Note: Not available
1. Report
Question: 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"

Note: Not available
1. Report
Question: If a relationship has the 'Cascade Update Related Fields' 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.

Note: Not available
1. Report
Question: 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.

Note: Not available
1. Report
Question: 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

Note: Not available
1. Report
Question: 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
Databases 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.

Note: Not available
1. Report
Question: 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

Note: Not available
1. Report
Question: Which query will you use to count the number of records in a result set?
A
Select count(*) as total from students

B
Select count(amount) as total from students

C
Select total from students

D
Select * from students

Note: Not available
1. Report
Question: The Database Splitter is one of the database utilities. Which of the following is true about the Database Splitter?
A
This utility splits a Microsoft Access database into three files

B
This utility breaks up the information in the tables into a compacted format for faster retrieval

C
This utility segregates the tables from the queries, forms, reports, macros, and modules

D
All of these

Note: Not available
1. Report
Question: 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(*)"

Note: Not available
1. Report

First Prev 1 2 3 4 Next Last

Question: What is the file extension of an Access Project?

Question: If a relationship has the 'Cascade Update Related Fields' option on, which of the following is true?

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

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

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

Question: 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?

Question: Which query will you use to count the number of records in a result set?

Question: The Database Splitter is one of the database utilities. Which of the following is true about the Database Splitter?

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