{"id":20321,"date":"2020-11-02T12:15:06","date_gmt":"2020-11-02T12:15:06","guid":{"rendered":"https:\/\/www.apen.es\/?page_id=20321"},"modified":"2025-07-14T11:03:16","modified_gmt":"2025-07-14T11:03:16","slug":"microsoft-access","status":"publish","type":"page","link":"https:\/\/www.apen.es\/ca\/glosario-de-informatica\/microsoft-access\/","title":{"rendered":"Microsoft Access"},"content":{"rendered":"<h2 class=\"wp-block-heading\">QU\u00c8 \u00c9S MICROSOFT ACCESS?<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"225\" src=\"https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access-300x225.png\" alt=\"\" class=\"wp-image-20322\" title=\"Microsoft Access. Qu\u00e8 \u00e9s Microsoft Access?\" srcset=\"https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access-300x225.png 300w, https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access-768x576.png 768w, https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access.png 1000w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure>\n<\/div>\n\n\n<p>Microsoft Access \u00e9s una eina d&#039;administraci\u00f3 d&#039;informaci\u00f3 per emmagatzemar informaci\u00f3 que es pot utilitzar com a refer\u00e8ncia, per a informes o an\u00e0lisis. Amb Microsoft Access ser\u00e0 m\u00e9s senzill analitzar grans quantitats d&#039;informaci\u00f3 i administrar dades, per la qual cosa \u00e9s una opci\u00f3 m\u00e9s eficient que Microsoft Excel o altres aplicacions de fulls de c\u00e0lcul.<\/p>\n\n\n\n<p>Generalment, el dubte ve en q\u00fcestionar si Microsoft Access \u00e9s una millor opci\u00f3 que <a href=\"https:\/\/www.apen.es\/ca\/glossari-dinformatica\/microsoft-excel\/\"><strong>Excel<\/strong><\/a>.<\/p>\n\n\n\n<p>Microsoft Excel \u00e9s f\u00e0cil d&#039;entendre, nom\u00e9s cal establir els noms de columnes, introduir les vostres dades i crear les f\u00f3rmules. Com a full de c\u00e0lcul, \u00e9s una eina excel\u00b7lent per mantenir i calcular petits conjunts dinformaci\u00f3. Es poden ordenar, filtrar i formatar les dades de manera r\u00e0pida i senzilla.<\/p>\n\n\n\n<p>No obstant aix\u00f2, els fulls de c\u00e0lcul no s\u00f3n ideals per gestionar centenars de registres. \u00c9s molt f\u00e0cil introduir errors en un full de c\u00e0lcul, cosa que fa que l&#039;an\u00e0lisi, la suma i la generaci\u00f3 d&#039;informes siguin molt dif\u00edcils.<\/p>\n\n\n\n<p>Davant d&#039;aix\u00f2, el valor que pot proporcionar qualsevol base de dades \u00e9s emmagatzemar informaci\u00f3 relacionada en un sol lloc i despr\u00e9s permetre connectar diverses coses diferents (anomenades \u00abentitats\u00bb en el llenguatge de la base de dades). Amb aix\u00f2 estar\u00e0 emmagatzemant una versi\u00f3 per disposar en un cas determinat, com ara un client o una comanda.<\/p>\n\n\n\n<p>En utilitzar bases de dades es presenten menys errors i inconsist\u00e8ncies, es mant\u00e9 una versi\u00f3 per al rastreig que pot ser presentada en casos particulars i que minimitza la possibilitat de valors inconsistents. A m\u00e9s, en poder treballar m\u00e9s d&#039;una persona a la base de dades s&#039;augmenta la productivitat, ja que nom\u00e9s necessitar\u00e0 un canvi en un sol registre i aquest es veur\u00e0 reflectit a tota la base de dades.<\/p>\n\n\n\n<p>A aix\u00f2 se suma que les bases de dades brinden m\u00e9s seguretat i control, en brindar una ubicaci\u00f3 central per emmagatzemar, protegir i controlar les dades. El Microsoft Access inclou la capacitat de xifrar i protegir amb contrasenya els fitxers de la base de dades.<\/p>\n\n\n\n<p>Potser un dels punts m\u00e9s forts d&#039;aquesta opci\u00f3 \u00e9s que com que \u00e9s una font \u00fanica en un format estandarditzat, es pot tenir una perspectiva millor i prendre millors decisions en analitzar la base de dades, afegint tend\u00e8ncies hist\u00f2riques i filtre de les consultes m\u00e9s importants.<\/p>\n\n\n\n<p>Microsoft Access funciona de la mateixa manera que qualsevol base de dades, emmagatzemant informaci\u00f3 relacionada en conjunt i permetent crear connexions (comunament anomenades relacions) entre diferents coses. Les relacions entre dues coses diferents a Microsoft Access poden ser molt simples (com un contacte en un client i el client mateix) o complexes.<\/p>\n\n\n\n<p>Les dades s&#039;emmagatzemen en taules de Microsoft Access, que s\u00f3n com a mini fulls de c\u00e0lcul que guarden nom\u00e9s un tipus de coses. Una taula pot tenir molts camps, com les columnes al full de c\u00e0lcul. Cada camp d&#039;una taula es pot configurar per permetre o evitar que els usuaris introdueixin a certa informaci\u00f3.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u00bfQU\u00c9 ES MICROSOFT ACCESS? Microsoft Access es una herramienta de administraci\u00f3n de informaci\u00f3n para almacenar informaci\u00f3n que se puede utilizar como referencia, para informes o an\u00e1lisis. Con Microsoft Access ser\u00e1 m\u00e1s sencillo el analizar grandes cantidades de informaci\u00f3n y administrar datos, por lo que es una opci\u00f3n m\u00e1s eficiente que Microsoft Excel u otras aplicaciones&#8230;<\/p>","protected":false},"author":4,"featured_media":0,"parent":6185,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-landing-glosario.php","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"class_list":["post-20321","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Access - Apen Inform\u00e1tica<\/title>\n<meta name=\"description\" content=\"\u00bfQU\u00c9 ES MICROSOFT ACCESS? Microsoft Access es una herramienta de administraci\u00f3n de informaci\u00f3n para almacenar informaci\u00f3n que se puede utilizar como\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.apen.es\/ca\/glossari-dinformatica\/microsoft-access\/\" \/>\n<meta property=\"og:locale\" content=\"ca_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Access - Apen Inform\u00e1tica\" \/>\n<meta property=\"og:description\" content=\"\u00bfQU\u00c9 ES MICROSOFT ACCESS? Microsoft Access es una herramienta de administraci\u00f3n de informaci\u00f3n para almacenar informaci\u00f3n que se puede utilizar como\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.apen.es\/ca\/glossari-dinformatica\/microsoft-access\/\" \/>\n<meta property=\"og:site_name\" content=\"Apen Inform\u00e1tica\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/apensolucions\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-14T11:03:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access-300x225.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Temps estimat de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minuts\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/microsoft-access\\\/\",\"url\":\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/microsoft-access\\\/\",\"name\":\"Microsoft Access - Apen Inform\u00e1tica\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/microsoft-access\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/microsoft-access\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/logo_microsoft_access-300x225.png\",\"datePublished\":\"2020-11-02T12:15:06+00:00\",\"dateModified\":\"2025-07-14T11:03:16+00:00\",\"description\":\"\u00bfQU\u00c9 ES MICROSOFT ACCESS? Microsoft Access es una herramienta de administraci\u00f3n de informaci\u00f3n para almacenar informaci\u00f3n que se puede utilizar como\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/microsoft-access\\\/#breadcrumb\"},\"inLanguage\":\"ca\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/microsoft-access\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/microsoft-access\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/logo_microsoft_access-300x225.png\",\"contentUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/logo_microsoft_access-300x225.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/microsoft-access\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/www.apen.es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Glosario de inform\u00e1tica\",\"item\":\"https:\\\/\\\/www.apen.es\\\/glosario-de-informatica\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Access\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#website\",\"url\":\"https:\\\/\\\/www.apen.es\\\/\",\"name\":\"Apen Inform\u00e1tica\",\"description\":\"Mantenimiento Inform\u00e1tico , Software de Gesti\u00f3n, Soluciones de impresi\u00f3n\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.apen.es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ca\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#organization\",\"name\":\"Apen: Soluciones inform\u00e1ticas\",\"url\":\"https:\\\/\\\/www.apen.es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/logo-apenok-231x82-1.png\",\"contentUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/logo-apenok-231x82-1.png\",\"width\":231,\"height\":82,\"caption\":\"Apen: Soluciones inform\u00e1ticas\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/apensolucions\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/ApenCentreInformatic\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1021771?trk=tyah&trkInfo=clickedVerticalcompanyclickedEntityId1021771idx2-1-2tarId1464195271196tasapenin\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Access - Apen Inform\u00e0tica","description":"QU\u00c8 \u00c9S MICROSOFT ACCESS? Microsoft Access \u00e9s una eina d&#039;administraci\u00f3 d&#039;informaci\u00f3 per emmagatzemar informaci\u00f3 que es pot utilitzar com a","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.apen.es\/ca\/glossari-dinformatica\/microsoft-access\/","og_locale":"ca_ES","og_type":"article","og_title":"Microsoft Access - Apen Inform\u00e1tica","og_description":"\u00bfQU\u00c9 ES MICROSOFT ACCESS? Microsoft Access es una herramienta de administraci\u00f3n de informaci\u00f3n para almacenar informaci\u00f3n que se puede utilizar como","og_url":"https:\/\/www.apen.es\/ca\/glossari-dinformatica\/microsoft-access\/","og_site_name":"Apen Inform\u00e1tica","article_publisher":"https:\/\/www.facebook.com\/apensolucions","article_modified_time":"2025-07-14T11:03:16+00:00","og_image":[{"url":"https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access-300x225.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Temps estimat de lectura":"3 minuts"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.apen.es\/glosario-de-informatica\/microsoft-access\/","url":"https:\/\/www.apen.es\/glosario-de-informatica\/microsoft-access\/","name":"Microsoft Access - Apen Inform\u00e0tica","isPartOf":{"@id":"https:\/\/www.apen.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.apen.es\/glosario-de-informatica\/microsoft-access\/#primaryimage"},"image":{"@id":"https:\/\/www.apen.es\/glosario-de-informatica\/microsoft-access\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access-300x225.png","datePublished":"2020-11-02T12:15:06+00:00","dateModified":"2025-07-14T11:03:16+00:00","description":"QU\u00c8 \u00c9S MICROSOFT ACCESS? Microsoft Access \u00e9s una eina d&#039;administraci\u00f3 d&#039;informaci\u00f3 per emmagatzemar informaci\u00f3 que es pot utilitzar com a","breadcrumb":{"@id":"https:\/\/www.apen.es\/glosario-de-informatica\/microsoft-access\/#breadcrumb"},"inLanguage":"ca","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apen.es\/glosario-de-informatica\/microsoft-access\/"]}]},{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/www.apen.es\/glosario-de-informatica\/microsoft-access\/#primaryimage","url":"https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access-300x225.png","contentUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2020\/11\/logo_microsoft_access-300x225.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.apen.es\/glosario-de-informatica\/microsoft-access\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.apen.es\/"},{"@type":"ListItem","position":2,"name":"Glosario de inform\u00e1tica","item":"https:\/\/www.apen.es\/glosario-de-informatica\/"},{"@type":"ListItem","position":3,"name":"Microsoft Access"}]},{"@type":"WebSite","@id":"https:\/\/www.apen.es\/#website","url":"https:\/\/www.apen.es\/","name":"Apen Inform\u00e0tica","description":"Manteniment inform\u00e0tic , programari de gesti\u00f3, solucions d&#039;impressi\u00f3","publisher":{"@id":"https:\/\/www.apen.es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.apen.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ca"},{"@type":"Organization","@id":"https:\/\/www.apen.es\/#organization","name":"Apen: Solucions inform\u00e0tiques","url":"https:\/\/www.apen.es\/","logo":{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/www.apen.es\/#\/schema\/logo\/image\/","url":"https:\/\/www.apen.es\/wp-content\/uploads\/2022\/08\/logo-apenok-231x82-1.png","contentUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2022\/08\/logo-apenok-231x82-1.png","width":231,"height":82,"caption":"Apen: Soluciones inform\u00e1ticas"},"image":{"@id":"https:\/\/www.apen.es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/apensolucions","https:\/\/www.youtube.com\/user\/ApenCentreInformatic","https:\/\/www.linkedin.com\/company\/1021771?trk=tyah&trkInfo=clickedVerticalcompanyclickedEntityId1021771idx2-1-2tarId1464195271196tasapenin"]}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"marqueting","author_link":"https:\/\/www.apen.es\/ca\/blog\/author\/marqueting\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/pages\/20321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/comments?post=20321"}],"version-history":[{"count":1,"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/pages\/20321\/revisions"}],"predecessor-version":[{"id":56560,"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/pages\/20321\/revisions\/56560"}],"up":[{"embeddable":true,"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/pages\/6185"}],"wp:attachment":[{"href":"https:\/\/www.apen.es\/ca\/wp-json\/wp\/v2\/media?parent=20321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}