Embedded Files
In this page we will use MS-Access and the Personnel Database container we created previously to create an Employee Table.
Physical Design
Physical Design
The last stage is to "Implement the logical design and document any changes made to overcome the short-comings of the technology chosen".
Employee Entity
Employee Entity
Using the Data Dictionary we can create an Employee table in the MS-Access Personnel Database Container.
Data Dictionary
Data Dictionary
Entity Diagram
Entity Diagram
Creating an Employee Table in MS-Access
Creating an Employee Table in MS-Access
If you have just created your database you should have a blank table showing
Change the view of the default table from Datasheet to design (Ribbon bar, button on far left)
Access should popup the Save As window
Change the Table Name to tblEmployee, then click [OK]
Using the Data Dictionary add the attributes to the Employee Table
EmpID will default to an Autonumber and be created as a Primary Key (key symbol on the left)
For EmpTitle Add
validation rule: In ("","Mr","Mrs","Ms","Dr")
validation text : Please enter one of "","Mr","Mrs","Ms","Dr"
When you have finished your table should look like
Change back to DataSheet view (You will be prompted to save the table (click [Yes])
To test your table add some sample data
When you have done this your table should look like.
Google Sites
Report abuse