database
extensive testing
importing the dummy data set
I am going to import the dummy data set exactly as I will be importing the real data: by using the import feature and an append query.
Firstly I clicked 'File' and 'Get External Data' and selected 'Import' from the options. A new window opened asking me to find the data, I then navigated to the directory where the dummy data set was, I selected the testdummy.txt file and clicked 'Import'. A new window then opened like below:
I clicked next and made sure that the comma radio was checked and that the 'First Row contains Field Names' box was checked. I then pressed next and checked that the create new table radio was checked and then pressed next and pressed it again. Then the following screen appeared:
I selected the 'No primary key' option and then pressed next. Access then asked me to name the table, so I named it Test Data set and it was created.
No problems so far, now I need to append this data to the two entities. This is done by creating two new queries in design view. The first one is for appending the data to the CD entity, the second is for appending the correct data to the Order entity.
So to create the first one I opened a new query in design view and added the Test data set to it. Then I added the fields: CD Number, CD_Title and Artist to the query. I then clicked the sum button to group all the data and then clicked 'Query' and selected 'Append query', a new window appeared:
I scrolled down the list to 'CD' and pressed the 'OK' button. This query when run will now append those three fields to the 'CD' entity. I then repeated the whole process but instead of adding the CD Number, CD_Title and Artist, I added all the remaining fields and told this query to append them to the Order entity.
When both these querys are run, 5 should pass and 5 should be rejected. So I ran both queries and both time the same sequence of events happened. At first, a new window popped up, it is shown below:
I clicked 'Yes' and shortly after another window appeared:
I clicked yes again, and an error message appeared stating that:
It could only append five of the records to the Order and CD Tables and it carefully put the other five in a new table called 'Rejected Records'. This is just what I expected - thankfully my database has passed my dummy data set import test. However they're still plently more checks to be done to complete the test for efficiency and correct behaviour.
Click next to continue...