Docstoc

Implementation

Document Sample
Implementation Powered By Docstoc
					Implementation - Task 3 | Hannah Fenton



                                                               The first thing that I
                                                               did to create my
                                                               database was open
                                                               Microsoft Access.




                          Once it had opened
                          I clicked on ‘Blank
                          Database’, to start a
                          new database.




                                         I then had to name
                                         my database, and
                                         clicked create.




                                            The next thing that I needed to
                                            do was to import the data that
                                            was saved on Excel. To do this I
                                            clicked on ‘External Data’ and
                                            then ‘text file’.




                                                                               Page | 1
Implementation - Task 3 | Hannah Fenton




                                          Once this screen had I
                                          appeared I needed to click on
                                          browse and locate the data, I
                                          then clicked Open and then
                                          OK.




                                             Once I had clicked OK, the
                                             screen on the left is what
                                             appeared, I didn’t need to
                                             do anything to this so I just
                                             clicked next.




                                                               Page | 2
Implementation - Task 3 | Hannah Fenton




                                          On the next screen I
                                          needed to make sure that
                                          I had clicked on ‘comma’
                                          and on ‘First Row
                                          Contains Field Names’. I
                                          then clicked Next.




                                            I didn’t need to
                                            change anything on
                                            the next screen I
                                            just clicked next.




                                                       Page | 3
Implementation - Task 3 | Hannah Fenton




                                             On the next screen I
                                             needed to make sure that
                                             I had clicked on ‘Choose
                                             my own primary key’. I
                                             then clicked next.




                                          On this screen I needed
                                          to give my Table a title. I
                                          labelled mine
                                          ‘Appointments’. I then
                                          clicked finish.




                                              On the last screen I
                                              didn’t need to do
                                              anything so I just
                                              clicked ‘Close’.




                                                                  Page | 4
Implementation - Task 3 | Hannah Fenton


              I then needed to import more data. I did this the same as
              how I did for the appointments table. I imported data for
              the Health specialists, Patients and Medical conditions.




                                       The next thing that I needed
                                       to do was create the
                                       relationships. To do this I
                                       clicked on ‘Database Tools’
                                       and then ‘Relationships’.




                                                                          Page | 5
Implementation - Task 3 | Hannah Fenton




                                          Page | 6

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:9/18/2012
language:Unknown
pages:6