- Home
- Microsoft Certification
- 77-885 Exam
- Microsoft.77-885.dumpsfiles Dumps
Free Microsoft 77-885 Exam Dumps Questions & Answers
| Exam Code/Number: | 77-885Join the discussion |
| Exam Name: | MS Access 2010 |
| Certification: | Microsoft |
| Question Number: | 135 |
| Publish Date: | Jul 13, 2026 |
|
Rating
100%
|
|
Total 135 questions
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?
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 named Shippers and Orders created in Microsoft Office Access 2010. A one-to-many relationship is created between both tables. You want to delete a Shipper. The shipper that you want to delete has orders in the Orders table. When you delete the Shipper record, these orders will become "orphans". The orders will still include a shipper ID, but this ID will not be valid. What will you do to prevent these orphans?
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 network and multiple users work directly with the file simultaneously. The database file has a small risk of becoming corrupted. The risk of corruption is greater if users often modify data in Memo fields, and the risk grows over time. Which of the following will you use to mitigate this risk?
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 five main sections. By default, which of the following sections are present on the report?
Each correct answer represents a complete solution. Choose three.
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 macros and relationships between these objects.