tab . In the pane that appears, you can view the objects that depend on the object selected in the navigation pane and the objects it depends on . After Access creates the name maps, you can see which objects depend on others by choosing Object Dependencies on the Database Tools tab. Tip Name AutoCorrect is not suitable for every situation because the feature does affect database performance to some degree and can also increase the size of a database . You might want to keep the option turned off for a database whose structure is unlikely to change or when you need to maintain a smaller file size . Tip Name AutoCorrect also works at the level of fields and controls (such as text boxes) . ➤ To rename an object 1. Display the navigation pane . 2. Right-click the object you need to rename, and then click Rename 3. Type a new name for the object, and then click OK
334 Exam 77-885 Microsoft Access 2010 Specialist ➤ To enable and use name AutoCorrect 1. Click File , Options 2. In the Access Options dialog box, click Current Database , and then scroll to the Name AutoCorrect Options section . 3. Select the Track name AutoCorrect Info check box . 4. Select the Perform Name AutoCorrectcheck box . 5. Select the Log name AutoCorrect changes check box to maintain a log of changes . Deleting Objects In a database, especially in a relational database system such as Access, you need to take care before you delete an object . In fact, Access won’t let you delete some objects with- out taking prior steps . For example, you can’t delete a table that has a relationship with another table before you remove the relationship . Access prevents this action because deleting a table can produce orphan records—a book with no author, for example, or orders with no customer . When you right-click an object in the navigation pane and choose Delete, Access displays a message prompting you to confirm that you want to delete the object . If you click Yes in this message, you’ll see another message if the object you are deleting is related to another . In this message, Access prompts you to confirm that Access should delete the relationship and then delete the object . Importing and Exporting Data from the Navigation Pane Two of the other operations you can perform from the navigation pane are importing and exporting data . When you choose Import or Export from the shortcut menu, Access displays a list showing data formats such as XML File, SharePoint List, Text File, and others . When you import many formats, Access displays a Get External Data dialog box that contains fields in which you specify required information, such as the file name and location, whether you want to import the data to a new table or append records to the select object, or the name of a SharePoint site . In the Export dialog box, Access requires the destination where you want to save the data you are exporting, export options that control format- ting and layout, and similar types of information . You can also use the commands on the External Data tab to import and export data .
You've reached the end of your free preview.
Want to read all 200 pages?
- Spring '13
- Romeo and Juliet, Microsoft Corporation, Objective Review