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.

To Access the full content, Please Purchase

  • Q1

    What do you mean by sorting?

    Marks:1
    Answer:

    Sorting refers to the arrangement of records in a specific order.

    View Answer
  • Q2

    How many fields are stored in an Access table?

    Marks:1
    Answer:

    An Access table can store up to 255 fields.

    View Answer
  • Q3

    How many tables are stored in a single MDB file of Access database?

    Marks:1
    Answer:

    An Access database can store up to 32,768 tables in a single MDB file.

    View Answer
  • Q4

    Which feature is used to navigate in a table?

    Marks:1
    Answer:

    To navigate in the table, we use Record Navigation Buttons.

    View Answer
  • Q5

    How will you open an existing database?

    Marks:1
    Answer:

    An existing database can be opened by clicking on the Open icon on the database toolbar and then double clicking the desired database selected from the list.

    View Answer