Creating a table in ms access

Learn how to create a table in MS Access. PPT created by 8th grader for his school project.

1. By- Arunoday Katiyar (8 th A) Creating a Table in ms access P P T

2. CREATING A TABLE IN MS ACCESS A TABLE CAN BE CREATED IN VARIOUS WAYS: THEY ARE CREATING TABLES IN DESIGN VIEW CREATING TABLES BY USING TEMPLATES CREATING TABLES IN DATASHEET VIEW

3. CREATING A TABLE IN MS ACCESS IN DATEBASE WINDOW, CLICK ON THE CREATE TAB AND SELECT THE TABLE OPTION IN THE TABLES GROUP. A NEW TABLE WILL BE CREATED IN THE DATABASE. CLICK ON THE VIEW BUTTON DROP-DOWN ARROW IN THE VIEWS GROUP AND CHOOSE DESIGN VIEW FROM THE DROP-DOWN MENU. THE SAVE AS DIALOG BOX APPEARS . DEFINE THE TABLE NAME AND CLICK ON THE OK BUTTON.

4. CREATING A TABLE IN MS ACCESS A BLANK TABLE WILL OPEN IN THE DESIGN VIEW, DISPLAYING THE THREE COLUMNS, NAMES FIELD NAME, DATA TYPE, AND DESCIPTION. A NEW TAB, DESIGN APPEARS ON THE RIBBON. ACCES AUTOMATICALLY CREATES A PRIMARY KEY AND ASSIGNS IT A FIELD NAME- ‘ID’ AND THE DATA TYPE – ‘AUTONUMBER’. YOU WILL NOTICE THAT KEY SYMBOL APPERAS NEXT TO THE FIELD. ENTER THE NAME FOR THE OTHER FIELDS IN THE FIELD NAME COLUMN, PRESS THE TAB KEY TO MOVE TO THE DATA TYPE COLUMN.

5. CREATING A TABLE IN MS ACCESS BY DEFAULT, AUTO NUMBER APPEARS IN THE DATA TYPE COLUMN. CLICK ON THE DROP-DOWN ARROW THAT APPREARS WHEN YOU CLICK IN THE DATA TYPE FIELD. SELECT THE DESIRED DATA TYPE FROM THE DISPLAYED LIST.

6. CREATING A TABLE IN MS ACCESS PRESS THE TAB KEY TO MOVE THE DESCRIPTION COLUMN. IN THIS COLUMN, YOU CAN GIVE ANY COMMENTS RELATED TO THE FIELD. THIS IS AN OPTIONAL STEP. PRESS THE TAB KEY AGAIN AND THE CURSOR WILL MOVE TO THE FIELD NAME COLUMN IN THE NEXT ROW. REPEAT THIS PROCESS UNTIL YOU CREATE ALL THE REQUIRED FIELDS OF A TABLE AND SET THEIR PROPERTIES.

7. You made it this far, here’s a cookie for you Thank you for your time