Client Details Spreadsheet for use in MS Access 2010

Hi guys my first post here and I am really struggling with my last major assessment for my Database course and I need to pass this question so I can start converting my spreadsheet into a form in access 2010. So here is the question:

Client table(s)
A client file for importing has been data entered from a manual paperbased system.
Notes:
• Known phone and fax numbers need to be in the format (99) 9999-9999
• Some clients old “customer number” have been included and this should not be lost data
• Differences in data entry mean some lastname and firstnames need to be generated from FirstnameLastname, or visa-versa.

Once again, use your judgement to specify relationships, input masks, validation, formatting, lookups etc

And I hope the SS file uploaded successfully... btw this question is referring to the "Client" tab on the spreadsheet, please any help will be appreciated.

What are you actually asking, since this is homework, we're more than happy to suggest/answer specific questions - but we can't do it for you.

Hint1. Forget about starting with the form, start with the tables (yes, there need to be more than 1) and think about the normalization
Hint2. This isn't an Excel question, it's a database/Access question, so think about relationships

I tried to format the phone numbers to be (02) ####-#### but nothing happens, I will try and figure out the rest.