Results 1 to 6 of 6
  1. #1
    BeagleJimmy is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2013
    Posts
    3

    Post Complete short task, please

    Hi, I'm having a test in few days and it will be almost the same but with different words o r w/e, so i translated it for you (sorry for my bad english :/)~
    *Make database called Blabla and save it on the desktop
    *Tables are Professor(IDProfessor, Name, Lname, Salary), Subject(IDSubject, Name, Literature) and table Teaching(IDTeaching, IDSubject, IDProfessor, NumberofClasses)


    *Make Query with following atributes: From table Professor (Name, Lname,Salary), from table Subject(Name, Literature) and from table Teaching(NumberofClasses) and sort them by salary-descending
    *Make form and put 2informations in each table

    I haven't been on classes cuz of my illness and i can't follow tutorials on youtube, so compared to this i'll learn how to do things we're currently on on classes and will keep following in future, please don't call me lazy :/

    You can either post here dl file or send me a link, thank you a lot!!!

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Quote Originally Posted by BeagleJimmy View Post
    Stage 1) *Make database called Blabla and save it on the desktop
    Stage 2) *Tables are Professor(IDProfessor, Name, Lname, Salary), Subject(IDSubject, Name, Literature) and table Teaching(IDTeaching, IDSubject, IDProfessor, NumberofClasses)

    Stage 2a) Building the Relationships between the tables.

    Stage 3) *Make Query with following atributes: From table Professor (Name, Lname,Salary), from table Subject(Name, Literature) and from table Teaching(NumberofClasses) and sort them by salary-descending
    Stage 4) *Make form and put 2informations in each table
    Which stage is troubling you ? Post what is it that you are not able to get thro & some one should be able to guide you.

    Thanks

  3. #3
    BeagleJimmy is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2013
    Posts
    3
    I was wondering if some1 could do this in access and send me a document

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    And what would you learn from that?
    If you want to learn how to build tables and relationships and a database from business facts, then see this tutorial
    http://www.rogersaccesslibrary.com/T...lationship.zip

    Good luck

  5. #5
    BeagleJimmy is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2013
    Posts
    3
    I really appreciate your attempt to help, but tbh im not trying to learn anything, i just need this to be done so i can send doc to the teacher

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    Jimmy,
    It's been a few days. I was wondering how the test went?

    I'm not sure why you would take a test when you say
    but tbh im not trying to learn anything
    .

    Your comment brings to mind an old story ---
    "Dear Mr. Charles Atlas, I've taken your course. Now, please send me the muscles."

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating Short Cut Keys
    By djclntn in forum Access
    Replies: 1
    Last Post: 11-21-2012, 04:41 PM
  2. Dealing with Short Time format
    By hawkins in forum Access
    Replies: 0
    Last Post: 08-16-2011, 11:46 AM
  3. Short Cut Keys To Run Query
    By orcinus in forum Queries
    Replies: 5
    Last Post: 07-12-2011, 09:58 PM
  4. Short date comparison
    By andy101 in forum Programming
    Replies: 2
    Last Post: 03-17-2011, 04:36 AM
  5. CTRL +' Short Cut Key
    By desireemm1 in forum Access
    Replies: 2
    Last Post: 09-10-2009, 03:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums