I don’t need to apply any sorting in this case so I can move onto the next step by clicking on ‘Next’. The next stage allows me to adjust the width of the field but the default width is okay so I move onto the next stage by clicking on ‘Next’. At the final stage of the wizard the default values shown in the screenshot are okay for the purpose of this lookup so I click ‘Finish’ to complete the process. When the information box appears to save the table I click ‘Yes’. I now carry out a similar process to create the remaining table relationships. Relationships prevent unnecessary duplicate data within the database and make searching for data much easier in the future. After making all the table relationships I can take a look at a summary of the relationships in the database currently to see how everything links together: Step 4 – Creating Now that I have created the tables I can creating forms to allow users to enter new data into the existing tables. At this stage it is important to ensure that the user interface I develop is clear and easy to use. The first tables that I will create will be tblNewHost, and tblNewConsultant, these tables are created in a similar way to the process I will be outlining: I click on ‘Create’ in the ribbon then on ‘Form Wizard’ from the ‘Forms’ category. When the ‘Form Wizard’ window appears I select ‘tblHosts’ from the drop-down ‘HostID’ menu and select all the fields apart from since this is an autonumber so will be created automatically:
I don’t need to apply any sorting in this case so I can move onto the next step by clicking on ‘Next’. The next stage allows me to adjust the width of the field but the default width is okay so I move onto the next stage by clicking on ‘Next’. At the final stage of the wizard the default values shown in the screenshot are okay for the purpose of this lookup so I click ‘Finish’ to complete the process. When the information box appears to save the table I click ‘Yes’. I now carry out a similar process to create the remaining table relationships. Relationships prevent unnecessary duplicate data within the database and make searching for data much easier in the future. After making all the table relationships I can take a look at a summary of the relationships in the database currently to see how everything links together: Step 4 – Creating Now that I have created the tables I can creating forms to allow users to enter new data into the existing tables. At this stage it is important to ensure that the user interface I develop is clear and easy to use. The first tables that I will create will be tblNewHost, and tblNewConsultant, these tables are created in a similar way to the process I will be outlining: I click on ‘Create’ in the ribbon then on ‘Form Wizard’ from the ‘Forms’ category. When the ‘Form Wizard’ window appears I select ‘tblHosts’ from the drop-down menu and select all the fields apart from ‘HostID’ since this is an autonumber so will be created automatically:
database-implementation.docx