Destinyyyy
  • Destinyyyy
Has anyone on here used Access?
Computer Science
  • Stacey Warren - Expert brainly.com
Hey! We 've verified this expert answer for you, click below to unlock the details :)
SOLVED
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
katieb
  • katieb
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
Destinyyyy
  • Destinyyyy
Ive never heard of it before and I have to do two assignments on it. Can you please help me?
Destinyyyy
  • Destinyyyy
Destinyyyy
  • Destinyyyy

Looking for something else?

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

More answers

appleduardo
  • appleduardo
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,
Destinyyyy
  • Destinyyyy
Alright Ill look at it
Destinyyyy
  • Destinyyyy
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?
appleduardo
  • appleduardo
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 .
appleduardo
  • appleduardo
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 .
Destinyyyy
  • Destinyyyy
Okay.. I figured that out.. Now im stuck on step 5
Destinyyyy
  • Destinyyyy
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.
Destinyyyy
  • Destinyyyy
I dont see Import & Link group
Destinyyyy
  • Destinyyyy
Do I click on import excel sheet?
appleduardo
  • appleduardo
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
appleduardo
  • appleduardo
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
Destinyyyy
  • Destinyyyy
Okay.. I did that
Destinyyyy
  • Destinyyyy
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.
Destinyyyy
  • Destinyyyy
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-### " ??
Destinyyyy
  • Destinyyyy
Do I just remove Project ID and put Enter the Project ID using the format P-### in its place?
Destinyyyy
  • Destinyyyy
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
appleduardo
  • appleduardo
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.
appleduardo
  • appleduardo
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.
Destinyyyy
  • Destinyyyy
Step 10.. Ohhh well your helping a bit
Destinyyyy
  • Destinyyyy
Im guessing on everything.. Usually my professor has an example to look at but the example makes no sense to me it looks broken

Looking for something else?

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