+ Reply to Thread
Results 1 to 3 of 3

Client Details Spreadsheet for use in MS Access 2010

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    2

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,180

    Re: Client Details Spreadsheet for use in MS Access 2010

    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

  3. #3
    Registered User
    Join Date
    05-29-2013
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    2

    Re: Client Details Spreadsheet for use in MS Access 2010

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1