Part 1 Tutorial : Create Database
1. Start MS Access
From the Start menu click on
> Programs
> Microsoft Office
> Microsoft Access 2003
2. Note the Getting Started task pane on the right side of your screen.
3. Click on Create a new file.
4. The New File task pane will appear. Under New, click on Blank Database.
5. Name the database contact_management and choose Desktop as the location. Click the Create button.
A. Create Table in Design View
1. The contact_management : Database window opens. Double click the Create table in design view item. The Table1 : Table opens.
2. Begin entering field names starting with Call_ID.
Click in the Data Type box and from the pull down menu select AutoNumber.
3. Click the Primary Key button on the Table Design toolbar. Each table MUST have a Primary Key.
4. A Foreign Key field must be included to establish a relationship. A foreign key field is a primary key taken from a foreign table (for example, the customer_ID field from the Customers table would establish the relationship between the Customers table and the Calls table). Give it a Number Data Type.
5. Continue adding field names from your preliminary field list until all are added.
6. Click the Save button. The Save As window opens. Name the table Calls. Click the OK button.
You have created the table structure for the Calls table from scratch. Let’s take a look.
7. From the Table Design toolbar, select the Datasheet View icon.
The table datasheet window opens. Check your list of fields for accuracy.
8. Close the table by clicking the X in the upper right corner.
9. You now see the contact_management : Database window. Now you will create tables by
importing data from a Microsoft Excel spreadsheet
read more and download
1. Start MS Access
From the Start menu click on
> Programs
> Microsoft Office
> Microsoft Access 2003
2. Note the Getting Started task pane on the right side of your screen.
3. Click on Create a new file.
4. The New File task pane will appear. Under New, click on Blank Database.
5. Name the database contact_management and choose Desktop as the location. Click the Create button.
A. Create Table in Design View
1. The contact_management : Database window opens. Double click the Create table in design view item. The Table1 : Table opens.
2. Begin entering field names starting with Call_ID.
Click in the Data Type box and from the pull down menu select AutoNumber.
3. Click the Primary Key button on the Table Design toolbar. Each table MUST have a Primary Key.
4. A Foreign Key field must be included to establish a relationship. A foreign key field is a primary key taken from a foreign table (for example, the customer_ID field from the Customers table would establish the relationship between the Customers table and the Calls table). Give it a Number Data Type.
5. Continue adding field names from your preliminary field list until all are added.
6. Click the Save button. The Save As window opens. Name the table Calls. Click the OK button.
You have created the table structure for the Calls table from scratch. Let’s take a look.
7. From the Table Design toolbar, select the Datasheet View icon.
The table datasheet window opens. Check your list of fields for accuracy.
8. Close the table by clicking the X in the upper right corner.
9. You now see the contact_management : Database window. Now you will create tables by
importing data from a Microsoft Excel spreadsheet
read more and download
Posts
0 comments:
Post a Comment