{"id":4701,"date":"2018-11-16T10:43:38","date_gmt":"2018-11-16T15:43:38","guid":{"rendered":"https:\/\/eduenligne.com\/?post_type=product&p=4701"},"modified":"2020-02-27T10:23:26","modified_gmt":"2020-02-27T15:23:26","slug":"microsoft-office-access-2010-basic","status":"publish","type":"product","link":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/","title":{"rendered":"Microsoft Office Access 2010 Basic"},"content":{"rendered":"

Access 2010 is a database application design and deployment tool<\/a>\u00a0that you can use to keep track of important information. You can keep your data on your computer, or you can publish to the Web\u00a0\u2014 so others can use your database with a web browser. Many people start using Access when the program that they are using to keep track of something gradually becomes less fit for the task. For example, suppose you are an event planner, and you want to keep track of all the details that you need to manage to make your events successful. If you use a word processor or spreadsheet program to do this, you can easily run into trouble with duplicate and inconsistent data. You can use calendaring software, but tracking financial information in a calendar isn’t a good fit.<\/p>\n

Sometimes you need a relational database to track such information\u00a0\u2014 a storehouse of data that has been separated into smaller collections of data (called tables) to eliminate redundancy, and then related together based on common bits of information (called fields). For example, an event planning relational database might contain a table with customer information, a table with vendor information, and a table with event information. The table with event information might have a field to relate it to the customer table, and a field to relate it to the vendor table. That way, for example, if a vendor’s phone number changed, the information could be changed once in the vendor table, instead of in every event that involved the vendor.Access is a tool that you can use to quickly and easily develop relational database applications that help you manage information. You can create a database to help you keep track of just about any kind of information, such as inventory, professional contacts, or business processes. In fact, Access comes with templates that you can use right away to track a variety of information, making things easy even for a beginner.<\/p>\n

Many people begin to explore Access after first building a list in Excel. Excel is a great place to start a list, but as the list grows, it becomes harder to organize and keep updated. Moving the list to Access is usually the next logical step.<\/p>\n

A database table is similar in structure to a worksheet, in that data is stored in rows and columns. As a result, it is usually easy to import a worksheet into a database table. The main difference between storing your data in a worksheet and storing it in a database is in how the data is organized. Simply importing your entire worksheet as a new table in a database will not solve the problems associated with organizing and updating your data, particularly if your worksheet contains redundant data. To solve those problems, you must split the spreadsheet data into separate tables, each one containing related data. For more information about how to arrange the data in your tables, see the article\u00a0Database design basics<\/a>. Access features the Table Analyzer Wizard, which can help you to complete this process. After importing your data into a table, the wizard helps you to split the table into separate tables, each of which contains data that is not duplicated in any of the other tables. The wizard also creates the necessary relationships between the tables.<\/p>\n<\/section>\n

<\/a><\/p>\n

<\/section>\n

<\/a><\/p>\n

<\/section>\n","protected":false},"excerpt":{"rendered":"

Here are some basic database tasks that you can do to help you learn how to use Microsoft Access 2010.<\/p>\n","protected":false},"featured_media":4702,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[76,99,149],"product_tag":[],"class_list":{"0":"post-4701","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-it","7":"product_cat-ms-office-2010","8":"product_cat-access-2010","9":"pa_access-to-training-12-months","10":"pa_duration-4-5-hours","11":"pa_language-english","13":"first","14":"instock","15":"sale","16":"virtual","17":"sold-individually","18":"taxable","19":"purchasable","20":"product-type-simple"},"yoast_head":"\nMicrosoft Office Access 2010 Basic - Edu Boutique<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Office Access 2010 Basic - Edu Boutique\" \/>\n<meta property=\"og:description\" content=\"Here are some basic database tasks that you can do to help you learn how to use Microsoft Access 2010.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/\" \/>\n<meta property=\"og:site_name\" content=\"Edu Boutique\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/edu.performance\/\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-27T15:23:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eduenligne.com\/wp-content\/uploads\/2018\/11\/access-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"421\" \/>\n\t<meta property=\"og:image:height\" content=\"260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@EduPerformance\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/\",\"url\":\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/\",\"name\":\"Microsoft Office Access 2010 Basic - Edu Boutique\",\"isPartOf\":{\"@id\":\"https:\/\/eduenligne.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eduenligne.com\/wp-content\/uploads\/2018\/11\/access-1.png\",\"datePublished\":\"2018-11-16T15:43:38+00:00\",\"dateModified\":\"2020-02-27T15:23:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#primaryimage\",\"url\":\"https:\/\/eduenligne.com\/wp-content\/uploads\/2018\/11\/access-1.png\",\"contentUrl\":\"https:\/\/eduenligne.com\/wp-content\/uploads\/2018\/11\/access-1.png\",\"width\":421,\"height\":260},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/eduenligne.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shop\",\"item\":\"https:\/\/eduenligne.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Office Access 2010 Basic\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/eduenligne.com\/#website\",\"url\":\"https:\/\/eduenligne.com\/\",\"name\":\"EduBoutique\",\"description\":\"Edu-Performance store\",\"publisher\":{\"@id\":\"https:\/\/eduenligne.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/eduenligne.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/eduenligne.com\/#organization\",\"name\":\"Edu-Boutique\",\"url\":\"https:\/\/eduenligne.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eduenligne.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/eduenligne.com\/wp-content\/uploads\/2019\/03\/Logo-Edu-boutique.png\",\"contentUrl\":\"https:\/\/eduenligne.com\/wp-content\/uploads\/2019\/03\/Logo-Edu-boutique.png\",\"width\":512,\"height\":181,\"caption\":\"Edu-Boutique\"},\"image\":{\"@id\":\"https:\/\/eduenligne.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/edu.performance\/\",\"https:\/\/x.com\/EduPerformance\",\"https:\/\/www.linkedin.com\/company\/1632801\",\"https:\/\/www.youtube.com\/channel\/UCU0b_VVdOoSbJ9_kvgiQpMg\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Office Access 2010 Basic - Edu Boutique","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:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Office Access 2010 Basic - Edu Boutique","og_description":"Here are some basic database tasks that you can do to help you learn how to use Microsoft Access 2010.","og_url":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/","og_site_name":"Edu Boutique","article_publisher":"https:\/\/www.facebook.com\/edu.performance\/","article_modified_time":"2020-02-27T15:23:26+00:00","og_image":[{"width":421,"height":260,"url":"https:\/\/eduenligne.com\/wp-content\/uploads\/2018\/11\/access-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@EduPerformance","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/","url":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/","name":"Microsoft Office Access 2010 Basic - Edu Boutique","isPartOf":{"@id":"https:\/\/eduenligne.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#primaryimage"},"image":{"@id":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#primaryimage"},"thumbnailUrl":"https:\/\/eduenligne.com\/wp-content\/uploads\/2018\/11\/access-1.png","datePublished":"2018-11-16T15:43:38+00:00","dateModified":"2020-02-27T15:23:26+00:00","breadcrumb":{"@id":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#primaryimage","url":"https:\/\/eduenligne.com\/wp-content\/uploads\/2018\/11\/access-1.png","contentUrl":"https:\/\/eduenligne.com\/wp-content\/uploads\/2018\/11\/access-1.png","width":421,"height":260},{"@type":"BreadcrumbList","@id":"https:\/\/eduenligne.com\/en\/product\/microsoft-office-access-2010-basic\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/eduenligne.com\/en\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/eduenligne.com\/en\/"},{"@type":"ListItem","position":3,"name":"Microsoft Office Access 2010 Basic"}]},{"@type":"WebSite","@id":"https:\/\/eduenligne.com\/#website","url":"https:\/\/eduenligne.com\/","name":"EduBoutique","description":"Edu-Performance store","publisher":{"@id":"https:\/\/eduenligne.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eduenligne.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/eduenligne.com\/#organization","name":"Edu-Boutique","url":"https:\/\/eduenligne.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eduenligne.com\/#\/schema\/logo\/image\/","url":"https:\/\/eduenligne.com\/wp-content\/uploads\/2019\/03\/Logo-Edu-boutique.png","contentUrl":"https:\/\/eduenligne.com\/wp-content\/uploads\/2019\/03\/Logo-Edu-boutique.png","width":512,"height":181,"caption":"Edu-Boutique"},"image":{"@id":"https:\/\/eduenligne.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/edu.performance\/","https:\/\/x.com\/EduPerformance","https:\/\/www.linkedin.com\/company\/1632801","https:\/\/www.youtube.com\/channel\/UCU0b_VVdOoSbJ9_kvgiQpMg"]}]}},"_links":{"self":[{"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/product\/4701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/comments?post=4701"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/media\/4702"}],"wp:attachment":[{"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/media?parent=4701"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/product_brand?post=4701"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/product_cat?post=4701"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/eduenligne.com\/en\/wp-json\/wp\/v2\/product_tag?post=4701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}