77-885 무료 덤프문제 온라인 액세스

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 is opened in the Datasheet view?

• A.Record
• B.Text Formatting
• C.Clipboard
• D.Find

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 Institutes created in Microsoft Office Access 2010. You want to import a word document named Students to an Access file named Library. What will you do to accomplish the task?

• A.Save the document as a text file and then import it.
• B.Copy and paste the word document to the destination file.
• C.Choose the Word Merge option from the Import & Link group.
• D.Link the word document to the Access file.

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?

• A.Select query
• B.Parameter query
• C.Action query
• D.Crosstab query

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.

• A.Create relationships between the tables while designing the database.
• B.Modify the default join behavior.
• C.Select two tables for the query that have a field in common.
• D.Use the Object Dependencies pane available on the Relationships group.

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

• A.QBE grid
• B.Quick Access Toolbar
• C.Title bar
• D.Navigation Pane