Working with Database
A database is an organized collection of data. Database Management System (DBMS) is a software application that is used for creating and managing databases. To open an already existing database, select Open an existing file from the Access window and then select a particular database from the dropdown list. Now, select the desired database by double clicking it from the Open dialog box.
While working with a MS Access table, Record Navigation Buttons are used for entering a new record, or going to a specific record or deleting a record. Access supports 254 tables to be opened together for the editing purpose. Record validation rules are the rules enforced whenever the data is added or edited. These rules are controlled when the entire record is saved. Sorting is the arrangement of records in a specific order of a value. Records may be arranged in ascending or descending order. Indexing refers to the creation of a separate file that stores the order of records on the basis of a field’s value. Shortcut keys are the keys or combination of keys performing the same task, i.e., done by clicking appropriate option or an icon in MS Access.