Sunday , August 25 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, …

17 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. 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!

Leave a Reply

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