Friday , December 6 2019
Home / DCA / Access / Microsoft Access and its features

Microsoft Access and its features

Microsoft Access and its features

Microsoft Access is a powerful relation data base management system (“RDBMS”) package and is the part of Microsoft Office and it is developed by Microsoft Corporation here, it is to be clear that Access package provide collection of control to create Table, Form, Query, Report etc. In the MS Access package you can use both front end and back end to developed small Software. The extension of Ms Access file is “.accdb” (Access-2007) or “.mdb” (Access-2003).

Microsoft Access and its features

Feature of Ms Access:-

  1. You can create more then one relation.
  2. You can create relationship such as one to many and many to one to one between the table.
  3. Access also provides to create a report where reports is a material that will print.
  4. You can also protect access file with password

Import and Export are one of the best feature of Access by which you can export the data from Access to Excel to Other database and also you can import Excel data or Oracle data to the Access.

Read :- history-of-computer

Q:- What is record.?

Ans:- It is the collection of data having different datatype arranged in horizontal form is called record. It is also called row.

Q:- What is Field.

Ans:- It hold collection of data having same datatype arranged in vertical form is called field. It is called column.

Q:- What is table.

Ans:- Table is the combination of row and column. It is also called relation. In the Access file all tables should have Unique table.

Q:- What is primary key.

Ans:- It is use uniquely identify the record.

Q:- What is foreign key.

Ans:- It is the type of attribute which is use to identify the field will uniquely identify the record or the field is referenced will another table.

I hope that you understand my post. if you like this post then share my post, and comment on my post if you have any suggestion or Queries related to MS Access. thank you!

Check Also

Download And Activate Microsoft Office for lifetime

Download And Activate Microsoft Office for lifetime Microsoft Office is a family of client software, …

54 comments

  1. I simply couldn’t leave your site before suggesting that I really loved the usual information a person provide for your guests? Is going to be back continuously in order to check out new posts

  2. Acha hai sir ji

  3. My developer is trying to convince me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using WordPress on a number of websites for about a year and am anxious about switching to another platform. I have heard great things about blogengine.net. Is there a way I can import all my wordpress content into it? Any help would be greatly appreciated!

  4. Wow, wonderful blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is wonderful, as well as the content!

  5. Columbus Mentzer

    I do not know whether it’s just me or if everybody else experiencing issues with your website. It appears as if some of the text on your content are running off the screen. Can someone else please provide feedback and let me know if this is happening to them too? This may be a problem with my browser because I’ve had this happen before. Kudos

  6. Hi Dear, are you truly visiting this web site on a regular basis,
    if so after that you will absolutely take nice experience.

  7. Hello! I know this is kind of off topic but I was wondering which
    blog platform are you using for this website? I’m getting sick and tired of
    Wordpress because I’ve had issues with hackers and I’m looking at alternatives
    for another platform. I would be awesome if you could point me in the direction of a good platform.

  8. I’m pretty pleased to discover this website. I wanted to thank you for ones time
    due to this fantastic read!! I definitely loved every part
    of it and i also have you book marked to look at new information on your website.

  9. It’s very effortless to find out any topic on net as
    compared to textbooks, as I found this piece of writing at this website.

  10. Hi, i think that i saw you visited my weblog so
    i got here to return the prefer?.I am attempting to in finding things to enhance my website!I guess its ok to make use of some of your ideas!!

  11. Heya! I just wanted to ask if you ever have any problems with
    hackers? My last blog (wordpress) was hacked and I ended up losing
    months of hard work due to no back up. Do you have any solutions to prevent hackers?

  12. Hello all, here every person is sharing such experience, thus it’s good to read this weblog, and I used to
    go to see this blog every day.

  13. What’s up it’s me, I am also visiting this web page
    regularly, this website is in fact nice and the visitors are actually sharing nice thoughts.

  14. Can you tell us more about this? I’d care to find out more details.

  15. Excellent goods from you, man. I have understand your stuff previous to and you’re just too wonderful.
    I actually like what you have acquired here, certainly like what
    you’re saying and the way in which you say it. You make it entertaining
    and you still care for to keep it sensible. I can not
    wait to read much more from you. This is actually a
    great website.

  16. quest bars cheap

    Link exchange is nothing else except it is only placing the other person’s web site link on your page at proper place and other person will also do similar in favor
    of you.

  17. quest bars cheap

    What’s up, I log on to your new stuff on a regular basis.
    Your humoristic style is awesome, keep up the good work!

  18. Heya just wanted to give you a quick heads up and let you know a few of the images aren’t loading correctly.
    I’m not sure why but I think its a linking issue. I’ve tried it in two different internet browsers and both show the same results.

  19. With havin so much content do you ever run into any issues of plagorism
    or copyright infringement? My site has a lot of completely unique
    content I’ve either written myself or outsourced but it looks like a lot of it is popping it up all over
    the web without my authorization. Do you know any
    methods to help reduce content from being ripped off?
    I’d truly appreciate it.

  20. I do not even know how I ended up here, but I thought this post was
    good. I do not know who you are but definitely you’re
    going to a famous blogger if you are not
    already 😉 Cheers!

  21. Somebody essentially help to make seriously articles I would state.

    That is the very first time I frequented your website page and up to now?

    I surprised with the research you made to make this particular submit
    extraordinary. Fantastic job!

  22. Hey there! Do you use Twitter? I’d like to follow you if that
    would be okay. I’m absolutely enjoying your blog and
    look forward to new updates.

  23. Pretty nice post. I just stumbled upon your weblog and wanted to say that I’ve really enjoyed surfing
    around your blog posts. In any case I will be subscribing
    to your rss feed and I hope you write again soon!

  24. Evedy weekend i used to go to see this web page, as i wish
    for enjoyment, for the reason that this this site conations truly
    nice funny stuff too.

  25. It’s really a great and useful piece of info. I’m glad that you shared this helpful info with us. Please keep us informed like this. Thank you for sharing.

  26. I don’t know whether it’s just me or if everyone else experiencing issues with
    your website. It seems like some of the text on your posts are running off the screen. Can someone else please provide
    feedback and let me know if this is happening to them as well?

    This could be a issue with my web browser because I’ve had this happen before.
    Many thanks

  27. Thank you for the good writeup. It in fact was a amusement account it.
    Look advanced to more added agreeable from you! By the way, how can we communicate?

  28. This is really interesting, You are a very skilled blogger.

    I have joined your feed and look forward to seeking more of your great post.
    Also, I have shared your website in my social networks!

  29. Everything is very open with a precise clarification of the issues.
    It was really informative. Your site is extremely helpful.
    Many thanks for sharing!

  30. After looking into a few of the articles on your site, I seriously like your technique of
    blogging. I bookmarked it to my bookmark webpage list and
    will be checking back in the near future. Take a look at my web
    site too and tell me your opinion.

  31. Wow! Finally I got a weblog from where I be able to
    genuinely take helpful data regarding my study and knowledge.

  32. No matter if some one searches for his required thing, therefore he/she needs to
    be available that in detail, thus that thing is maintained over here.

  33. I have fun with, cause I found just what I was taking a look for.
    You have ended my four day long hunt! God Bless you
    man. Have a great day. Bye

  34. It’s amazing for me to have a web page, which is valuable in favor of my knowledge.
    thanks admin

  35. A person essentially assist to make significantly articles I’d state.

    This is the first time I frequented your web page and thus
    far? I amazed with the research you made to make this particular submit amazing.
    Magnificent activity!

  36. Hello, I think your website might be having browser compatibility
    issues. When I look at your website in Ie, it looks fine but when opening in Internet Explorer,
    it has some overlapping. I just wanted to give you a quick heads
    up! Other then that, superb blog!

  37. It’s an remarkable paragraph in support of all the internet people; they will take benefit from
    it I am sure.

  38. I like the helpful information you provide in your articles.
    I’ll bookmark your weblog and check again here regularly.
    I’m quite certain I will learn a lot of new stuff right here!
    Best of luck for the next!

  39. Simply want to say your article is as surprising. The
    clarity in your post is simply excellent and i could assume you’re
    an expert on this subject. Fine with your permission allow
    me to grab your RSS feed to keep up to date with
    forthcoming post. Thanks a million and please carry on the enjoyable work.

  40. I’m gone to tell my little brother, that he should also pay a quick visit this blog on regular basis to obtain updated from latest news.

  41. I love looking through a post that will make people think.
    Also, thanks for permitting me to comment!

  42. I constantly spent my half an hour to read this web site’s content
    all the time along with a mug of coffee.

  43. Great work! This is the type of information that should be shared around the net.
    Disgrace on the search engines for no longer
    positioning this put up upper! Come on over and talk over with my
    web site . Thanks =)

  44. Hi there Dear, are you truly visiting this site regularly, if so afterward you will without doubt get good knowledge.

  45. you are actually a excellent webmaster. The website loading velocity
    is amazing. It sort of feels that you’re doing any unique trick.
    In addition, The contents are masterpiece. you’ve performed
    a fantastic activity in this subject!

  46. Yes! Finally something about quest bars cheap.

  47. This info is worth everyone’s attention. Where can I find
    out more?

  48. What’s Going down i’m new to this, I stumbled upon this I’ve found It absolutely useful and it has helped
    me out loads. I’m hoping to give a contribution & help other users like
    its aided me. Great job.

  49. Hey There. I found your blog using msn. This is an extremely well
    written article. I’ll be sure to bookmark it and return to
    read more of your useful information. Thanks for the post.

    I will definitely return.

  50. Hello, the whole thing is going well here and ofcourse every one is sharing information,
    that’s actually excellent, keep up writing.

  51. It’s very straightforward to find out any topic on net as compared to textbooks, as I found this article at this
    site.

  52. Greetings! Very useful advice in this particular post!
    It is the little changes that produce the greatest changes.
    Thanks for sharing!

  53. Oh my goodness! Amazing article dude! Thank you, However I
    am encountering troubles with your RSS. I don’t understand
    why I cannot subscribe to it. Is there anyone else getting identical RSS problems?
    Anyone who knows the answer will you kindly respond?
    Thanks!!

  54. I will immediately clutch your rss as I can’t to find
    your email subscription link or newsletter
    service. Do you’ve any? Kindly allow me recognize so that I may
    subscribe. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *