{"id":747,"date":"2016-06-09T21:41:09","date_gmt":"2016-06-10T04:41:09","guid":{"rendered":"https:\/\/database.guide\/?p=747"},"modified":"2016-06-10T09:54:19","modified_gmt":"2016-06-10T16:54:19","slug":"microsoft-access-tutorial","status":"publish","type":"post","link":"https:\/\/database.guide\/microsoft-access-tutorial\/","title":{"rendered":"Microsoft Access Tutorial"},"content":{"rendered":"<p>This Microsoft Access\u00a0tutorial will show you how to use Microsoft Access\u00a0to\u00a0create a simple database with all the common\u00a0features\u00a0such as tables, forms, queries, and macros.<\/p>\n<p>This tutorial is for beginners. No prior database knowledge is assumed.<\/p>\n<p><!--more--><\/p>\n<p>This is a three-part tutorial. It consists of the following articles.<\/p>\n<h2><a href=\"https:\/\/database.guide\/microsoft-access-tutorial-part-1-databases-tables-fields\/\">Microsoft Access Tutorial (Part 1): Databases, Tables, &amp; Fields<\/a><\/h2>\n<p>Here&#8217;s what&#8217;s included in this article:<\/p>\n<ul>\n<li>Create a blank database.<\/li>\n<li>Create a table.<\/li>\n<li>Add four fields to the table, name\/rename them, and set up\u00a0their data type.<\/li>\n<\/ul>\n<h2><a href=\"https:\/\/database.guide\/microsoft-access-tutorial-part-2-design-view-field-properties-relationships\/\">Microsoft Access Tutorial (Part 2): Design View, Field Properties, &amp; Relationships<\/a><\/h2>\n<p>Here&#8217;s what&#8217;s included in this article:<\/p>\n<ul>\n<li>Design view.<\/li>\n<li>Add field properties to a field.<\/li>\n<li>Add two more tables (for the relationship)<\/li>\n<li>Set up a relationship between three tables.<\/li>\n<\/ul>\n<h2 class=\"p1\"><a href=\"https:\/\/database.guide\/microsoft-access-tutorial-part-3-queries-forms-macros\/\">Microsoft Access Tutorial (Part 3): Queries, Forms, &amp; Macros<\/a><\/h2>\n<p class=\"p1\">Here&#8217;s what&#8217;s included in this article:<\/p>\n<ul>\n<li class=\"p1\">Create a query (so you can &#8220;search\u00a0the database&#8221;).<\/li>\n<li class=\"p1\">Create a form for data entry.<\/li>\n<li class=\"p1\">Create a macro (so that a multi-step task can be done automatically &#8211; at the click of a button).<\/li>\n<\/ul>\n<h2>About Microsoft Access<\/h2>\n<p>Microsoft Access (commonly referred to as &#8220;MS Access&#8221; or just &#8220;Access&#8221;) is a <a href=\"https:\/\/database.guide\/what-is-an-rdbms\/\">relational database management system<\/a> (RDBMS). It allows you to create and maintain\u00a0relational <a href=\"https:\/\/database.guide\/what-is-a-database\/\">databases<\/a>.<\/p>\n<p>Access\u00a0provides an easy way for non-technical users to start building\u00a0databases. It\u00a0also provides an easy way to create forms for data entry, and reports for emailing and printing.<\/p>\n<p>Access even provides &#8220;wizards&#8221; that guide you\u00a0through\u00a0some of the most\u00a0common tasks.<\/p>\n<p>These features help make\u00a0Microsoft Access one of\u00a0the\u00a0easiest\u00a0database systems to learn.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This Microsoft Access\u00a0tutorial will show you how to use Microsoft Access\u00a0to\u00a0create a simple database with all the common\u00a0features\u00a0such as tables, forms, queries, and macros. This tutorial is for beginners. No prior database knowledge is assumed.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[8,33],"class_list":["post-747","post","type-post","status-publish","format-standard","hentry","category-microsoft-access","tag-ms-access","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/comments?post=747"}],"version-history":[{"count":7,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/747\/revisions"}],"predecessor-version":[{"id":810,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/747\/revisions\/810"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}