1. Suppose you want to apply a calculated field on a TextBox control to concatenate the values of the firstName and lastName fields - with a space between them.Which of the following expressions will you enter in the Expression Builder?

2. Microsoft Access uses indexes in a table to find data. Which of the following field types cannot be indexed?

3. Which of the following is NOT possible when you link to an Excel worksheet from within Access?

4. Which of the following are reserved for use by SharePoint and is not supported on the Web?

5. Which of the following elements are mandatory for the CREATE INDEX command?

6. 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?

7. What is the function of the icon marked as A (see image) when you are creating Macros in Microsoft Access 2010?

8. Which of the following is incorrect about the Quick Access Toolbar?

9. A query that uses the BETWEEN operator for two numbers is identical to:

10. Password protected databases offer:

11. Which of the following is the correct way to enter the beginning or ending characters of the fields named (UnitPrice and CompanyName) in the AutoIndex onImport/Create field to create an Auto Index ?

12. Which of the following functions determines if a phrase exists in a longer string?

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

14. How do you create a report for a Crosstab Query if certain column values are missing?

15. Which one of the following correctly selects rows from the students table that have null in column1?

16. 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'

17. What could be the problem when an error message '#Error' is received in a query?

18. Using which of the following Microsoft Access 2010 database file formats - can we use the Package and Sign tool?

19. When you run the Compatibility Checker in Microsoft Access 2010 - in which of the following scenarios can you get the error- Access was unable to convert the query for use on the Web because it relies on an ORDER BY clause that is not supported on the Web?

20. What is the function of the 'Single Step' in Macros as shown in the image?

21. Which of the following conditions should be satisfied to create a one-to-one relationship between tables?

22. What will happen when you click on the icon marked as A (see image)?

23. If you want to encrypt a database by using a password - then the database must be opened in ________ mode.

24. Which textbox property in Microsoft Access 2010 determines that the text box is bound - unbound or calculated?

25. Suppose you have a table named Cars with fields that store the name - year - price - and condition of used cars that you are considering for purchase. Also suppose that the table has become large and that you frequently include the Year field in queries. You can create an index on the Year field so that your queries return results more quickly. Which syntax will you use to achieve this?