77-885 Exam Questions

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer contains a database na...

James works as a Database Designer for Tech Perfect Inc. He wants to prevent the Navigation Pane from appearing by default in Microsoft Office Access 2010. Which of the following s...

Which of the following groups includes commands that are required to display total, check spelling, freeze and hide columns, and change the row height and cell width when the form...

Which of the following datatypes is used to attach Microsoft Office files, graphics files, sound files, and pdf files to a table?

You are creating a report named Report1 in Microsoft Office Access 2010 using the Report Design feature. This feature opens a report layout on a design grid. The design grid has fi...

You are working on a home computer with Microsoft Office 2010 installed on it. You want to always open Microsoft Office Access 2010 with the database that you used the last time. W...

Which of the following is used to control values of a field entered by a database user?

You have a table named Projects created in Microsoft Office Access 2010. You are required to make some changes in the table's data. In which of the following views will you open th...

Which of the following Report Layout tools is used to specify the color, width, and line style for the outline of the selected field of a report?

You have created a form named Details in Microsoft Office Access 2010. You want to add new elements, change the header/footer, and apply a new theme to the form. Which of the follo...

In which of the following views does the program window open when a user starts Microsoft Office Access 2010 without opening a database?

Where can a user add any Access command as a button in Microsoft Access 2010?

You have two tables named Customers and Orders created in Microsoft Office Access 2010. In Orders table, each order has a customer ID. You want to correspond it to a record in the...

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named D...

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named I...

You are working on an Access form named Form-A. You have opened Property Sheet to view the form's properties and make the required changes. Property Sheet consists of five tabs wit...

You have created a database by clicking the Blank Web Database button in the Microsoft Backstage view. Which of the following types of view is available for designing forms?

You have a list of records where fields are empty in a certain column. You want to filter the list so that you get the non-empty fields only. What will you do to accomplish the tas...

Which of the following types of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times?

You have opened an Access form in the Design view. The form has header and footer. You want to save the entire form as the report. What will you do?

You want to customize the presentation of data extracted from queries or tables that are created in Microsoft Office Access 2010. Which of the following database objects will you u...

Which of the following text box properties is used to determine whether the text box is bound, unbound, or calculated?

Fill in the blank with the appropriate Access tool name. The has a set of commands or functions (save, undo/redo, and print) that are independent of the tab on the ribbon currently...

You are working on a table named Students created in Microsoft Office Access 2010. You are required to retrieve the addresses and phone numbers of all students from the table more...

Which of the following datatypes stores alphanumeric values and accepts text with rich text format, paragraphs, descriptions, etc?

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named O...

Which of the following is located along the left side of the Access screen and provides an interface for all database objects?

You are creating a report named Performance in Microsoft Office Access 2010 using the Report Design feature. This feature opens a report layout in the Design view. Which of the fol...

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a table named Table1 in Microsoft Office Access 2010. Table1 contains a sub-datashee...

You have a form named Assets created in Microsoft Office Access 2010. You have to make some changes in the formatting of the form. For this reason, you have opened the form in the...

Which of the following are the ways to create a join between two tables in Microsoft Access 2010? Each correct answer represents a complete solution. Choose all that apply.

Which of the following field properties allows you to enter a "" string in a field to indicate that there is no value for that field?

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to ensure that the databas...

Which of the following properties binds the forms and reports to a source from which data is to be retrieved?

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named C...

You are creating a form in Microsoft Office Access 2010. You want the created form to display a Form view and a Datasheet view of the same data at the same time. Which of the follo...

James works as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database name...

Which of the following restricts a user from entering invalid data in the table columns?

You are working on a home computer with Microsoft Office 2010 installed on it. You are creating a form in Microsoft Office Access 2010 in order to control the execution of Access d...

You have created a table named Books in Microsoft Office Access 2010. You have created a new field to enter the Book ID. For this purpose, you need to set the Number datatype for t...

You work as a Database Documenter for Tech Perfect Inc. You have a database named Database1 created in Microsoft Office Access 2010. This database contains three tables named Produ...

You want to perform the following tasks to manipulate data before importing it into Access: - Add fields. - Combine fields. - Use complex mathematical functions. Which of the follo...

Which of the following operators creates multiple conditions in expressions and always returns True, False, or Null?

Which of the following statements best describe the features of a primary key? Each correct answer represents a complete solution. Choose three.

An Access database, when splitted, is organized into two parts, i.e., back-end database and front- end database. Which of the following statements are true about the back-end datab...

You are working on a home computer with Microsoft Office 2010 installed on it. The computer has two tables named Projects and ProjectDetails created in Microsoft Access 2010. Both...

Which of the following steps will you take to create a blank database in Microsoft Office Access 2010?