?Explain database record maintenance in Microsoft Access 2016.

What will be an ideal response?


Answers will vary. Designing and creating a database is just the beginning. Once the database structure is developed, the ongoing work of record keeping begins. Data is constantly changing. People regularly get new phone numbers and email addresses. Invoices are sent and then paid. Customer activity is ongoing, and tracking this accurately leads to developing new strategies for promoting services. So, no matter what kind of information the database contains-customer, contract, invoice, or asset data, to name just a few-the information must be accurate and current to be of value. This requires continual and diligent entering and updating of records. Maintaining a database involves adding new records, updating the field values of existing records, and deleting outdated records to keep the database current and accurate.?Deleting a record removes all of the field values for that record from the database. Before you delete a record, you must select the entire row for the record in the datasheet. Then, you can delete the selected record using the Delete button in the Records group on the Home tab or the Delete Record command on the shortcut menu. Keep in mind that the deletion of a record is permanent and cannot be undone. Please see the section "Maintaining Database Records" for more information.

Computer Science & Information Technology

You might also like to view...

To perform an arbitrary task when a property’s value changes, you can register a property ________.

a. inquirer b. follower c. listener d. spectator

Computer Science & Information Technology

E-mail messages arrive in your electronic Inbox, where they can be stored for later use.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Which of the following is not a section break?

A) Next Page B) Even Page C) Continuous D) Contiguous

Computer Science & Information Technology

The technique in which playback of a video starts as soon as enough data has transferred to the user’s computer to sustain this playback is called ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology