DATABASE COMPONENTS IN MS ACCESS

DATABASE COMPONENT MS ACCESS

There are seven database components in Microsoft access.

Tables

Tables are the fundamental data building blocks. All the data is stored in tables. A table stores data in a row and column format. Every table deals with one subject at a time.


Queries

The query features of Access create a search based on the requirements.

Forms

Forms present the data from a tale or a query in the way you want it to be represented. Forms enable you to view, edit and print data in a customized format. Data entry forms are designed to be user-friendly, so that you can enter information into a database table easily.

Reports

Reports are the printed results of a table or query. Different types of report can be created with a DBMS. For example, you can generate a report that lists only selective records, such as the students who stay in west UP.

Macros

Macros allow you to manipulate data, open forms and reports and automate any tasks that are repetitive or complex. It lets you to perform common tasks without intervention and you can speed up the way a database works.

Modules

A module stores programming code written in MS Access database.

Pages

Pages are used to add, edit or view data from a website on internet. They provide user interface for the database stored in remote computer.

ENTERING DATA in Database

When you have finished the table structure in the design view, double click on the table name, e.g. table1 icon in the Database window.

Table window will open up in the datasheet view, with the cursor in the first field.

Now, you can enter data into the table.



You can use the alternatively way by using he mouse. Now, enter the data of your choice below each field one by one and press ‘tab key’ on the keyboard.

If you want to move from one field or record to another, you can use the directional arrows keys. You can also use some keys separately or in combination with other keys, which give quick movement.

The scroll bars are used to scroll database table up and down or left and right, similar to other windows based programs.

After opening a blank database, you can easily enter the data by following the steps given below:

Step 1: open a blank database.

Step 2: click on the data type box and select any option.

Step 3: type the data in the table.

SAVING A DATABASE

To save a database, follow the steps:

Step 1: click on the file tab. The backstage view appears.

2: click on save option save as box appears.

Step 3: type the table name in the table name box.

Step 4: click OK.




OPENING AN EXISTING DATABASE

You can easily open a database file that is present in your computer.

To open a database file, follow the steps given below:

1: click on the file tab. The backstage view appears.

Step 2: click on open. The open dialog box appears.

Step 3: Select the name of the file you want to open.

Step 4: Then click open.