ALL >> Computers >> View Article
Editing Records In Related Tables In Ms Access Database
This article throws light on steps for editing records, saving and deleting records in related tables of MS Access .mdb database file.
For adding or editing Data in a Datasheet (Table or Query) or in a Form, follow the given below steps:
Open a table or a query in Datasheet view or a form in Form view.
Do one of the following:
To add a new record, point to Go to on the Edit menu, and then click New Record. Type the data, and then press TAB to go to the next field. At the end of the record, press TAB to go to the next record.
To edit data within a field, click in the field that you want to edit, and then type the data.
To replace the entire value, move the mouse pointer to the leftmost part of the field until the pointer changes into the plus pointer, and then click. Type the data.
For saving a record in MDB file:
MS Access automatically saves the record that you are adding or editing as soon as you move the insertion point to a different record or close the form or table that you are working on. However, to explicitly save the data in a record while you are editing it, click ...
... Save Record on the Records menu.
Deleting a record from MDB file is very much simple, just go with the following steps:
Open a table or a query in Datasheet view or open a form in Form view.
Click the record that you want to delete.
On the Edit menu, click Delete Record. When you delete data, you might want to delete related data in other tables. For example, if you delete a supplier, you probably want to delete the products that the supplier supplies. In some cases, you can make sure that the proper data is deleted by enforcing referential integrity and turning on cascade deletions.
If you want to Undo Changes made in the database, then you can do so by any one of the following methods:
Simply click Undo from the Edit menu and all recent changes get reverted.
If you have already saved changes to the current record or have moved to another record, click Undo Saved Record on the Edit menu.
When MS Access database .MDB file is corrupt, you can't access it and can't do editing, addition, deletion to the database. So it's extremely important to have healthy Access database but corruption leaves it impotent. But you can now Repair Access File easily and effectively with Access file recovery software. Software is extensively designed to repair Access file that is corrupted or damaged.
URL:
http://www.repairaccessfile.net/
http://www.nucleusdatarecovery.org/
Add Comment
Computers Articles
1. Exploring How Ai In The Cloud Can Transform Your BusinessAuthor: TechDogs
2. The Power Of Cloud And Ai: A New Era Of Collaboration
Author: TechDogs
3. Get Business Insights Using Expedia & Booking. Com Review Data Scraping
Author: DataZivot
4. Top 10 Reasons A Strong Communication Strategy Drives Prm Program Success
Author: Archi
5. Achieve Scalable Web Scraping With Aws Lambda
Author: Devil Brown
6. Overcoming Common Challenges In Iso 27001 Implementation
Author: Jenna Miller
7. Basic Computer Course: Your Gateway To Skill Development | The Institute Of Professional Accountants
Author: Tipa Institute
8. Top 7 Advantages Of React Js
Author: Bella Stone
9. Top 7 App Marketing Tools For Mobile Success
Author: Bella Stone
10. Revolutionizing Education Management With Samphire It Solution Pvt Ltd’s Erp Software
Author: CONTENT EDITOR FOR SAMPHIRE IT SOLUTIONS PVT LTD
11. Top 10 Healthcare Technology Trends
Author: goodcoders
12. "building Tomorrow’s Factories: The Role Of Automation & Robotics In Modern Manufacturing"
Author: andrew smith
13. The Ultimate Guide To The Best Ecommerce Plugin For Wordpress
Author: Rocket Press
14. Xsosys Erp: A Scalable Solution For Businesses In Any Industry
Author: Xsosys Technology(S) Pte. Ltd.
15. Rental Management Software: A Complete Solution For Car, Property, And Coworking Space
Author: RentAAA