{"id":332,"date":"2022-12-01T20:32:33","date_gmt":"2022-12-01T20:32:33","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/putting-it-together-microsoft-access-basic-skills\/"},"modified":"2022-12-01T20:32:33","modified_gmt":"2022-12-01T20:32:33","slug":"putting-it-together-microsoft-access-basic-skills","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/putting-it-together-microsoft-access-basic-skills\/","title":{"raw":"Putting It Together: Microsoft Access Basic Skills","rendered":"Putting It Together: Microsoft Access Basic Skills"},"content":{"raw":"\nLearning about Microsoft Access teaches us much about relational databases in general. Databases are made up of tables containing information organized into columns and rows. The rows are records and the columns are fields that have specific formats. Information is divided into multiple tables based on category\u2014for example, a table for Customers, one for Orders, one for Products, etc. These tables are linked through the use of primary keys.\n\nIn this section we have learned how to use Access to create a database. Some of the important basics covered are: naming the database and designating its location; creating a new table; working with table fields; understanding data types; understanding field properties; setting table primary keys; and, understanding and creating indexes.\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1b9t62egZ1zEGBP6-CjZe_e8FlWZeBZNwfd4m2UFI2MM\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","rendered":"<p>Learning about Microsoft Access teaches us much about relational databases in general. Databases are made up of tables containing information organized into columns and rows. The rows are records and the columns are fields that have specific formats. Information is divided into multiple tables based on category\u2014for example, a table for Customers, one for Orders, one for Products, etc. These tables are linked through the use of primary keys.<\/p>\n<p>In this section we have learned how to use Access to create a database. Some of the important basics covered are: naming the database and designating its location; creating a new table; working with table fields; understanding data types; understanding field properties; setting table primary keys; and, understanding and creating indexes.<\/p>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1b9t62egZ1zEGBP6-CjZe_e8FlWZeBZNwfd4m2UFI2MM\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\n","protected":false},"author":503070,"menu_order":15,"template":"","meta":{"_candela_citation":"[]","CANDELA_OUTCOMES_GUID":"6ac95f61-d970-40d2-8f04-88097b5f24cf","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-332","chapter","type-chapter","status-publish","hentry"],"part":317,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/332\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/317"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/332\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=332"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=332"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=332"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}