This is an easy database project. We have 3 x Excel files that contain emails.
Spreadsheet 1 – this is the main email table that we want to maintain
Spreadsheet 2 and Spreadsheet 3 – the contain emails that may also be in table 1
Create a Database structure in Open Office. The database structure will contain 3 tables. Each table will be fed by an individual Excel spreadsheet. Automatically import the data from the excel spreadsheet into the table.
Spreadsheet 1 = import into Table 1
Spreadsheet 2 = import into Table 2
Spreadsheet 3 = import into Table 3
Then run a query that will:
• Check emails that are in the main Table 1 and to see if they feature in Table 2. If there are matches then remove them from Table 2 only.
• Check emails that are in the main Table 1 and to see if they feature in Table 3. If there are matches then remove them from Table 3 only.
After running this query, Table 1 will contain unique emails. There will be no email in Table 1 that is in either Table 2 or in Table 3.
I need the completed database structure and an easy way to run this query again and again.
Please respond with evidence of your capabilities. Once I select a coder, I will send you the spreadsheet files.