Basic Operations Performed in MS Access

MS Access is a database management system that can be used for creating databases. We can perform various operations in MS Access for storing the data in an efficient manner. The following arc some of the key operations that can be performed in MS Access:

• Creating a database
• Creating a database table
• Defining relationships
• Creating a database query

Creating a database: We can create a database in MS Access by performing the following steps:

• Open the Microsoft Access window.
• Select the Start option and click all programs and select the MS Access.
• Open New MS Access
• Select the location from the Save in list for saving the database.
• Enter the name of the database such as Student Database in the File name text box and click the Create button to create the Student Database.

Create table by using wizard: This option provides some sample tables to the user. These sample tables are divided into two categories, business and personal. After selecting a sample table and its fields, the users can enter data in to the newly created table.

Creating a database table: We can create a table in MS Access using any of the following three options available in the Student Database: Database (Access 2000 rile format) window:

Create table in Design view: This option allows us to first create the design of the table, i.e. the fields of the table along with its data type and then enter data into it.

Create Taby by using wizard: This option provides some samples tables to the user. These sample tables are divided into two categories, business and personal. After selecting a sample table and its field, the user can enter data into the newly created table.

Questionnaire:

• What are the basic operations performed in MS access?