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 two databases...

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

Which of the following options is used to package, digitally sign, and distribute a database in the .accdc file format while sharing an Access database file?

You work on a home computer with Microsoft Office 2010 installed on it. You have created a database named Database3 using Microsoft Office Access 2010. This database contains four...

Which of the following view types allows a user to manipulate data on the form created in Access 2010?

James works as a Database Designer for Tech Perfect Inc. He has to create a query that will extract the name and address of each customer who has made more than one order. Which of...

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 have a datasheet named Datasheet1 created in Microsoft Office Access 2010. You need to calculate the sum, average, and count for data. This data is grouped by two types of info...

Which of the following datatypes cannot be filtered by using common filters? Each correct answer represents a complete solution. Choose two.

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

You work as a Database Designer for Tech Perfect Inc. The company has a Windows based environment. A database file created in Microsoft Office Access 2010 is shared over the networ...

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 automate the import and...

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 create a blank report i...

Which of the following statements are true about an expression used in Microsoft Office Access 2010? Each correct answer represents a complete solution. Choose all that apply.

Which of the following properties allows a control to adjust its dimensions according to the contents present in the control?

Fill in the blank with the appropriate Access database object. A is a database object that includes custom procedures coded using Visual Basic and provides a more discrete flow of...

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a number of databases using Microsoft Access 2010. You have also created macros for...

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

Which of the following has a set of commands or functions (save, undo, and redo) that are independent of the tab on the ribbon currently displayed in MS Access 2010?

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a database named Database1 using Microsoft Access 2010. The database includes four d...

Which of the following parts of the Access Window provides a command interface by consolidating all tasks or entry points in one place?

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

Fill in the blank with the appropriate word. An is a file used to create a database application that includes all database objects, such as tables, forms, reports, queries, and mac...

Which of the following groups allows a user to change the appearance of the datasheet in the Datasheet view?

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 company uses a Microsoft Office...

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

You have a database named Database1 created in Microsoft Office Access 2010. This database contains several Access objects, such as form, table, query, and report. You want to crea...

You have created a database in Microsoft Access 2010 that contains several tables, queries, forms, and reports. This database is available for use by several organizations, but the...

Which of the following macro options allows MS Access to disable all macros and does not display any security warnings for enabling them?

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 are working on a database named...

Which of the following datatypes is used to specify whether a condition is true or false?

You are working on a home computer with Windows XP installed on it. Microsoft Office 2010 is also installed on the computer. By default, Access stores all the databases and project...

You are working on a table named Employees created in Microsoft Office Access 2010. You want to change the datatype of a previously defined field of the table to the AutoNumber dat...

Which of the following datatypes is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table?

Our 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 omputer has a database named De...

You are working on a form named Annexure-I created in Microsoft Office Access 2010. You need to view the control's Property Sheet in order to make some changes in the form control....

Which of the following components of Microsoft Access 2010 allows you to add icons that operate as shortcuts to command buttons on all ribbons and galleries?

Which of the following are the primary views of the query window? Each correct answer represents a complete solution. Choose three.

Which of the following groups allows you to specify a datatype for each field of a table?

Which of the following groups of the Client Settings page enables changing the number of recently used databases that are displayed in the Office button's gallery?

Which Access property is used to determine what appears in the default label attached to a control created by dragging the field from the field list onto a form or report?

Which of the following are the advantages of dragging a field from the Field List window? Each correct answer represents a complete solution. Choose three.

Which of the following types of Access queries performs operations on the records that match specified criteria?

Which of the following is a specialized form that is intended to provide user navigation through an application?

Which of the following ribbons available in Microsoft Office Access 2010 allows you to import, export, and link external data available in various formats?

Which of the following contains the names of the fields involved in the query and the criteria used to select records?

Which of the following features displays the fields of a form horizontally or vertically, and then calculates the total of the row or column?

You have a form named Annexure-1 created in Microsoft Office Access 2010. You have to split a cell horizontally into two smaller cells. The cell has a control. You want the control...

Which of the following contextual tabs consists of controls to select the initial layout of a form and the default positions of controls on the form?

Which of the following are the benefits of specifying a primary key for a table in Microsoft Office Access 2010? Each correct answer represents a complete solution. Choose all that...