MS Access 2003 - Lesson 9: Delete records and save information
At the beginning of this chapter, you learned how to add records to the table. At the end, you may want to delete one or more records. For example, if you disagree with a friend and want to remove him from the ' My Friends ' database.
To delete a record, follow these steps:
1. Use the mouse to select a record you want to delete. Do this by moving the mouse over the gray area on the left side of the log. When the mouse points to this area, it changes the cursor to an arrow to the right.
2. Click your mouse to highlight the record.
Press DEL or select Delete from the Edit menu. Access displays a dialog box (shown in Figure 1) that prompts a prompt to determine whether to delete this record:
Figure 1: You need to specify the record to be deleted.
Click Yes to delete the record, or No to not delete.
Note : Make sure you really want to delete the selected record before clicking Yes. You cannot undo when the record has been deleted. In addition, Access allows pehps to select multiple records at once to delete. To select those records, hold down the Shift key while selecting a record, which will select all records between the two selected records. To select non-contiguous records, hold down the Ctrl key and select each record in turn.
Save creation and editing information
When adding and changing a record, a pencil icon will appear on the left side of the record. This icon marks which record is being edited and changed but has not been recorded. When you use the arrow keys to move to another record board. Access will automatically save the changes. Therefore, in fact there are no statements that need to be used to save the data.
Access automatically saves data this way to protect your information. If in case of a sudden power outage or shutdown, only the currently edited record is missing information (the log has a pencil icon). Access will save all the information you edited earlier.
Note : The correct operation of this data storage case is that the first information will be saved on the disk's buffer in the computer memory. When the buffer is full or when the program is closed, new information is saved on the disk. Although this arrangement speeds up computer performance, it also has risks. Information in the buffer (not saved to disk) will be lost if you accidentally shut down the computer. The only way to avoid this is to have a backup power supply and never press the Power button.
You should read it
- MS Access 2003 - Lesson 37: Summary of chapter 9
- MS Access 2003 - Lesson 5: Chapter 2: Access Learning in 1 hour
- MS Access 2003 - Lesson 19: Filtering data
- MS Access 2003 - Lesson 3: Consider working
- MS Access 2003 - Chapter 9: Creating Form
- MS Access 2003 - Lesson 22: Using Query Wizards
- Steps to export Microsoft Access data to Word documents
- MS Access 2003 - Lesson 25: Chapter 7: Printing tables
May be interested
- Ms Excel - Lesson 13: Use conditional formatting in Excelconditional formatting in excel allows you to apply different formatting formats, such as color formatting to one or more cells based on the data of those cells.
- Easily with MS Office 2007 'Search Command' Addonthere are still many commands and features in ms office products that are not easy to find. would you like to have a search feature for your request.
- MS Excel - Lesson 14: Install and remove free Excel Add-insexcel add-in is an extension in excel programs. when installing, it is a small application, it will add a function so that excel can easily perform complex operations.
- MS Access 2003 - Lesson 11: Chapter 3: Customizing componentsin the previous chapter, you learned how to create a database and create a table, as well as how to enter and edit information in the table. in this chapter, you will set up on the basis of chapter 2.
- MS Access 2003 - Lesson 12: Working with a tableyou have learned how to create and design tables in access. and now it's time to learn how to manipulate all tables.
- How to use the AutoText format of Microsoft Wordautotext automatic input function of microsoft word and outlook saves you a lot of time if you need to type a paragraph repeatedly.