New To access
Results 1 to 8 of 8

Thread: New To access
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default New To access

    Ok, im very new to Microsoft Access. My database knowledge comes from trail and error on SQL databases for Forums Like "PHP FUSION" I can pretty much do what ever i want using the sql command box. SO for my very first newbie question out of many to come im sure!

    Can you use sql santax in Access to create databases, add fields ect?

  2. #2
    Board Regular
    Join Date
    May 2008
    Location
    Austria
    Posts
    1,082
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New To access

    Hi,
    Yes you can. )
    Silentwolf



    I use MS Office 2010 and Windows 7

  3. #3
    New Member
    Join Date
    Jan 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New To access

    Quote Originally Posted by silentwolf View Post
    Hi,
    Yes you can. )
    Ok can you tell me where i find the sql command box in access? BTW Thank you for the fast reply

  4. #4
    Board Regular
    Join Date
    May 2008
    Location
    Austria
    Posts
    1,082
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New To access

    Hi,
    In Access you wirte SQL Statements with queries.. So if you look at the ribbons you find Queries once you have selected those queries you can find a button SQL
    Basically you can write SQL Statemenst rather then queries.
    Or you can use in Access VBA also SQL Statements to perform what ever you need to do.

    HTH
    Silentwolf



    I use MS Office 2010 and Windows 7

  5. #5
    New Member
    Join Date
    Jan 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Re: New To access

    I dont see an attach Snippet for this forum or i would upload a picture of the database i been building with excel. It looks nice, but Im not happy with it, in order to improve it i need to know more about MS Access

  6. #6
    New Member
    Join Date
    Jan 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New To access

    Nice!!! Thank you @silentwolf

  7. #7
    New Member
    Join Date
    Jan 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New To access

    Quote Originally Posted by BobbyMaynard View Post
    I dont see an attach Snippet for this forum or i would upload a picture of the database i been building with excel. It looks nice, but Im not happy with it, in order to improve it i need to know more about MS Access
    Building with ACCESS not excel. Got to many things going on at once i guess.

  8. #8
    Board Regular
    Join Date
    May 2008
    Location
    Austria
    Posts
    1,082
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New To access

    Hi,
    no Problem.. do as the chinese say small permanent improvements
    Silentwolf



    I use MS Office 2010 and Windows 7

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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