Setting Up a Database
Setting up a database 1. Introduction
In order to complete my client’s needs I created a database and I started my work with Word Access 2010. This is how it looked at the beginning as I started my work today on the 5th of the October 2010. Today was our starting point for creating my clients database.
The screenshot above shows that I opened Access 2010 to begin creating my clients database.
2. Creating tables, setting fields + deciding on data types.
Once Microsoft Access was open I had to create my tables, simply by going into ‘View’ and switch into ‘design view’ and name my first table.
Firstly I had to name my tables in order ‘Customer Details’,’ Employees’, ’Product’ so that I know which one is which and on which one I am working. This is the screenshot of the design view of my first table with no data entered yet.
This is a design view of my first table
This is a design view of my first table
On the 5th of October as we started creating our database we also started designing the database and I created my first table that will provide me with my customer’s details. Firstly I created one of these tables manually on a blank sheet and I kept the sample in my folder. The fields in my first table include: customer ID number, first name, surname, address, contact number, town and post code and their sex. Also we can see I entered a primary Key to my first table and selected data type as an auto number.
After that in the same way I created my other two tables which were named ‘Employees’ and ‘Product’ - shown on the next page.
This is a screenshot of my second table that included employee’s information details. Both screenshots show the same table only the second one shows it in a design view. I had to add the following fields into design view where I included: employee ID number, employee first name, surname, employee contact number, street name, town and post code.
Additionally this screenshot presents the design view of the same table,
In order to complete my client’s needs I created a database and I started my work with Word Access 2010. This is how it looked at the beginning as I started my work today on the 5th of the October 2010. Today was our starting point for creating my clients database.
The screenshot above shows that I opened Access 2010 to begin creating my clients database.
2. Creating tables, setting fields + deciding on data types.
Once Microsoft Access was open I had to create my tables, simply by going into ‘View’ and switch into ‘design view’ and name my first table.
Firstly I had to name my tables in order ‘Customer Details’,’ Employees’, ’Product’ so that I know which one is which and on which one I am working. This is the screenshot of the design view of my first table with no data entered yet.
This is a design view of my first table
This is a design view of my first table
On the 5th of October as we started creating our database we also started designing the database and I created my first table that will provide me with my customer’s details. Firstly I created one of these tables manually on a blank sheet and I kept the sample in my folder. The fields in my first table include: customer ID number, first name, surname, address, contact number, town and post code and their sex. Also we can see I entered a primary Key to my first table and selected data type as an auto number.
After that in the same way I created my other two tables which were named ‘Employees’ and ‘Product’ - shown on the next page.
This is a screenshot of my second table that included employee’s information details. Both screenshots show the same table only the second one shows it in a design view. I had to add the following fields into design view where I included: employee ID number, employee first name, surname, employee contact number, street name, town and post code.
Additionally this screenshot presents the design view of the same table,