A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

Destinyyyy

  • one year ago

Has anyone on here used Access?

  • This Question is Closed
  1. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Ive never heard of it before and I have to do two assignments on it. Can you please help me?

  2. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

  3. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

  4. appleduardo
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    access is a painful databases tool! but uhmm, well check this tutorial so u can get going.: https://www.youtube.com/watch?v=gg-oz8jjrR4 aint that hard, is too easy and saves u a ton of time compared to sql server and mysql,

  5. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Alright Ill look at it

  6. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I completed the second step.. The next one says this- Change the data type of the ID field to Short Text, rename the ID field to Project ID. Hint: To rename the ID field, double-click ID. On the TABLE TOOLS FIELDS tab, in the Formatting group, click Data Type. I double-clicked ID to change it but short text is not an option. It only shows long text does that mean its already in short text?

  7. appleduardo
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    Yes, by default when you do not specify the text length, it gives you a string 256 characters long, so... If its text already, then its short text .

  8. appleduardo
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    Yes, by default when you do not specify the text length, it gives you a string 256 characters long, so... If its text already, then its short text .

  9. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Okay.. I figured that out.. Now im stuck on step 5

  10. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Sorry step 6. Append the records from the downloaded Excel file go_a01_grader_h3_Projects.xlsx to the Projects table. Hint: On the EXTERNAL DATA tab, in the Import & Link group, click Excel to begin the import. In the Get External Data - Excel Spreadsheet dialog box, use the Append option.

  11. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I dont see Import & Link group

  12. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Do I click on import excel sheet?

  13. appleduardo
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    Hey looks like for short text there's a so-called option http://www.tomsguide.com/faq/id-1877873/change-default-short-text-length-access-2013.html . And yeah I think you should click on there

  14. appleduardo
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    Hey looks like for short text there's a so-called option http://www.tomsguide.com/faq/id-1877873/change-default-short-text-length-access-2013.html . And yeah I think you should click on there

  15. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Okay.. I did that

  16. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    step 8-- Switch the Projects table to Design view. For the Project ID field, enter a description of Enter the Project ID using the format P-### and then change the field size to 5. Save the table. Hint: On the HOME tab, in the Views group, click the top half of the View button. Enter the description and use the Field Properties pane to change the field size.

  17. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I changed the field size to 5... But "For the Project ID field, enter a description of Enter the Project ID using the format P-### " ??

  18. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Do I just remove Project ID and put Enter the Project ID using the format P-### in its place?

  19. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I think I figured it out.. Project ID using the format P-### goes in the description bar next to data type which is next to field name

  20. appleduardo
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    Hehe yaa I guess you have it, lol sorry if I'm not being a big help, I'm not an access user, I'm an SQL server one.

  21. appleduardo
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    Hehe yaa I guess you have it, lol sorry if I'm not being a big help, I'm not an access user, I'm an SQL server one.

  22. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Step 10.. Ohhh well your helping a bit

  23. Destinyyyy
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Im guessing on everything.. Usually my professor has an example to look at but the example makes no sense to me it looks broken

  24. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.