{"id":320,"date":"2022-12-01T20:32:28","date_gmt":"2022-12-01T20:32:28","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/creating-a-database\/"},"modified":"2022-12-01T20:32:28","modified_gmt":"2022-12-01T20:32:28","slug":"creating-a-database","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/creating-a-database\/","title":{"raw":"Creating a Database","rendered":"Creating a Database"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Create a blank database<\/li>\n<\/ul>\n<\/div>\nYou can open Access from the Start menu (or the Applications folder on a Mac) by clicking on the Access icon. The Access icon comes in a variety of forms depending on your OS and version of Access, but it always features the color red or maroon and the letter&nbsp;A.\n<div align=\"center\"><img class=\"alignnone wp-image-4412\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/31020405\/access1.png\" alt=\"Microsoft access logo\" width=\"200\" height=\"200\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<img class=\"alignnone wp-image-4413\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/31020410\/access2-300x295.png\" alt=\"Microsoft access logo\" width=\"204\" height=\"200\"><\/div>\n<h2>New Database<\/h2>\nThere are two easy ways to create a blank database in Access. One way is to click the <strong>Blank Database<\/strong> option in the welcome screen (Figure 1).\n\n[caption id=\"attachment_2838\" align=\"aligncenter\" width=\"822\"]<img class=\"wp-image-2838 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/18231559\/Picture1.png\" alt=\"Microsoft Access Welcome Screen with &quot;Blank desktop database&quot; button circled.\" width=\"822\" height=\"593\"> Figure 1.[\/caption]\n\nThe second way to create a new database is to use the <strong>File New<\/strong> option from the menu bar (Figure 2).\n\n<img class=\"aligncenter wp-image-2839 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/18233022\/Picture2.png\" alt=\"Microsoft Access datasheet with cursor hovering over the &quot;File&quot; tab in the upper left corner.\" width=\"816\" height=\"454\"> <img class=\"aligncenter wp-image-3702 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/17220016\/Picture11.png\" alt=\"Microsoft Access File tab open with the cursor hovering over the &quot;New&quot; button.\" width=\"974\" height=\"550\">\n<ol>\n \t<li>On the&nbsp;<strong>File&nbsp;<\/strong>tab, click&nbsp;<strong>New<\/strong>, and then click&nbsp;<strong>Blank Database<\/strong>.<\/li>\n \t<li>Type a file name in the&nbsp;<strong>File Name<\/strong>box. To change the location of the file from the default, click&nbsp;<strong>Browse for a location to put your database<\/strong>&nbsp; <img class=\"alignnone wp-image-3206\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/23182536\/Figure12_4.png\" alt=\"\" width=\"30\" height=\"30\">&nbsp;(next to the&nbsp;<strong>File Name<\/strong>&nbsp;box), browse to the new location, and then click&nbsp;<strong>OK<\/strong>.<\/li>\n \t<li>Click&nbsp;<strong>Create<\/strong>.<\/li>\n<\/ol>\nAccess creates the database with an empty table named Table1, and then opens Table1 in Datasheet view. The cursor is placed in the first empty cell in the&nbsp;<strong>Click to Add<\/strong>&nbsp;column.\n<ol start=\"4\">\n \t<li>Begin typing to add data, or you can paste data from another source, as described in the section.<\/li>\n<\/ol>\nEntering data in Datasheet view is designed to be very similar to working in an Excel worksheet. The table structure is created while you enter data. When you add a new column to the datasheet, a new field is defined in the table. Access automatically sets each field's data type, based on the data that you enter.\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/87480f93-2160-4401-8a33-3519db523012\n\n<\/div>\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\/1my9uAujaoGY1f-ov2WjW4mD32TBIL7zCmBWxjP-GYUY\" 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":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Create a blank database<\/li>\n<\/ul>\n<\/div>\n<p>You can open Access from the Start menu (or the Applications folder on a Mac) by clicking on the Access icon. The Access icon comes in a variety of forms depending on your OS and version of Access, but it always features the color red or maroon and the letter&nbsp;A.<\/p>\n<div style=\"margin: auto;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4412\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/31020405\/access1.png\" alt=\"Microsoft access logo\" width=\"200\" height=\"200\" \/>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4413\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/31020410\/access2-300x295.png\" alt=\"Microsoft access logo\" width=\"204\" height=\"200\" \/><\/div>\n<h2>New Database<\/h2>\n<p>There are two easy ways to create a blank database in Access. One way is to click the <strong>Blank Database<\/strong> option in the welcome screen (Figure 1).<\/p>\n<div id=\"attachment_2838\" style=\"width: 832px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2838\" class=\"wp-image-2838 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/18231559\/Picture1.png\" alt=\"Microsoft Access Welcome Screen with &quot;Blank desktop database&quot; button circled.\" width=\"822\" height=\"593\" \/><\/p>\n<p id=\"caption-attachment-2838\" class=\"wp-caption-text\">Figure 1.<\/p>\n<\/div>\n<p>The second way to create a new database is to use the <strong>File New<\/strong> option from the menu bar (Figure 2).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2839 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/18233022\/Picture2.png\" alt=\"Microsoft Access datasheet with cursor hovering over the &quot;File&quot; tab in the upper left corner.\" width=\"816\" height=\"454\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3702 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/17220016\/Picture11.png\" alt=\"Microsoft Access File tab open with the cursor hovering over the &quot;New&quot; button.\" width=\"974\" height=\"550\" \/><\/p>\n<ol>\n<li>On the&nbsp;<strong>File&nbsp;<\/strong>tab, click&nbsp;<strong>New<\/strong>, and then click&nbsp;<strong>Blank Database<\/strong>.<\/li>\n<li>Type a file name in the&nbsp;<strong>File Name<\/strong>box. To change the location of the file from the default, click&nbsp;<strong>Browse for a location to put your database<\/strong>&nbsp; <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3206\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/11\/23182536\/Figure12_4.png\" alt=\"\" width=\"30\" height=\"30\" \/>&nbsp;(next to the&nbsp;<strong>File Name<\/strong>&nbsp;box), browse to the new location, and then click&nbsp;<strong>OK<\/strong>.<\/li>\n<li>Click&nbsp;<strong>Create<\/strong>.<\/li>\n<\/ol>\n<p>Access creates the database with an empty table named Table1, and then opens Table1 in Datasheet view. The cursor is placed in the first empty cell in the&nbsp;<strong>Click to Add<\/strong>&nbsp;column.<\/p>\n<ol start=\"4\">\n<li>Begin typing to add data, or you can paste data from another source, as described in the section.<\/li>\n<\/ol>\n<p>Entering data in Datasheet view is designed to be very similar to working in an Excel worksheet. The table structure is created while you enter data. When you add a new column to the datasheet, a new field is defined in the table. Access automatically sets each field&#8217;s data type, based on the data that you enter.<\/p>\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_87480f93-2160-4401-8a33-3519db523012\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/87480f93-2160-4401-8a33-3519db523012?iframe_resize_id=assessment_practice_id_87480f93-2160-4401-8a33-3519db523012\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\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\/1my9uAujaoGY1f-ov2WjW4mD32TBIL7zCmBWxjP-GYUY\" 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\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-320\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Creating a Database. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":503070,"menu_order":3,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Creating a Database\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"93f932a8-c5a5-4319-b6a6-0b4740c1bf37, 7a72f425-7d62-4e9a-84eb-39493479d469","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-320","chapter","type-chapter","status-publish","hentry"],"part":317,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/320","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\/320\/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\/320\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=320"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=320"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=320"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}