{"id":2373,"date":"2015-03-12T08:45:28","date_gmt":"2015-03-12T08:45:28","guid":{"rendered":"http:\/\/www.isunshare.com\/blog\/?p=2373"},"modified":"2023-04-15T08:53:20","modified_gmt":"2023-04-15T08:53:20","slug":"3-ways-to-create-access-database","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/3-ways-to-create-access-database\/","title":{"rendered":"3 Ways to Create Access 2007-2013 Database"},"content":{"rendered":"<p>Microsoft Access is undoubtedly easy for both personal user and enterprise to create a database for saving important and systematic data.<\/p>\n<p>So now in this article, three ways are summarized and shared to <strong>create Access database in Microsoft Access 2007\/2010\/2013<\/strong>. If you have any questions about access database creation, please follow the literal statement and image description below to do.<\/p>\n<p><strong>Three ways to create Access 2007\/2010 database:<\/strong><\/p>\n<ul>\n<li><a href=\"#way1\">Way 1: Create Access database with templates<\/a><\/li>\n<li><a href=\"#way2\">Way 2: Create a blank Access database with &#8220;Blank database&#8221; or &#8220;Blank Web database&#8221; command<\/a><\/li>\n<li><a href=\"#way3\">Way 3: Import existing data into Microsoft Access and save as Access database<\/a><\/li>\n<\/ul>\n<h2 id=\"way1\">Way 1: Create Access database with templates<\/h2>\n<p>1. Click <strong>File &#8211; New<\/strong> tab in Microsoft Access.<\/p>\n<p>2. In the middle pane of Access interface, <strong>Available Templates<\/strong> are provided. <strong>Recent Templates<\/strong>, <strong>Sample Templates<\/strong>, <strong>My Templates<\/strong> and <strong>Office.com Templates<\/strong> are available for you to choose.<\/p>\n<p>2-1 Click Recent Templates, Sample Templates or My Templates and select the template you want.<br \/>\nClick the folder icon next to the File Name box and browse to a location where you want to create the database. Then click <strong>Create<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-sample-templates1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"394\" class=\"alignnone wp-image-2392 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-sample-templates1.png\" alt=\"create access database with sample templates\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-sample-templates1.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-sample-templates1-300x204.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>2-2 Click templates under Office.com Templates, and select template you want. In the lower right corner, you can choose a folder to save access database created with template. Then click <strong>Download<\/strong> to download the template from Office.com.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-office-templates1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"397\" class=\"alignnone size-full wp-image-2393\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-office-templates1.png\" alt=\"create access database with office templates\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-office-templates1.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-office-templates1-300x205.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>Tips: If you don\u2019t indicate a specific location, Access will create the database in the default location that is displayed below the File Name box.<\/p>\n<p>3. Do more about new database created with templates.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-user-for-new-access-database-login.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"440\" class=\"alignnone size-full wp-image-2389\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-user-for-new-access-database-login.png\" alt=\"create login user for new access databse\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-user-for-new-access-database-login.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-user-for-new-access-database-login-300x228.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<ul>\n<li>If Access displays a <strong>Login<\/strong> dialog box, create a new user with wizard and Save &amp; Close. Then login Access database with this user.<\/li>\n<li>If Access displays a Security warning, click &#8220;Enable edit&#8221;.<\/li>\n<li>If Access displays &#8220;Getting Started&#8221;, you can follow introduction to learn how to configure and use the database.<\/li>\n<li>If Access displays empty database spreadsheet, you can type data on it or import data into spreadsheet.<\/li>\n<\/ul>\n<p>Don\u2019t need to save what you have done, access database has been created and saved automatically.<\/p>\n<h2 id=\"way2\">Way 2: Create a blank Access database with &#8220;Blank database&#8221; or &#8220;Blank Web database&#8221; command<\/h2>\n<p>If the templates don\u2019t demand your requirements, get this way to <strong>create access database<\/strong>.<\/p>\n<p>1. Tab <strong>File &#8211; New<\/strong> in Microsoft Access.<\/p>\n<p>2. Under Available Templates, select <strong>Blank database<\/strong> or <strong>Blank web database<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-blank-access-database-with-command.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"399\" class=\"alignnone size-full wp-image-2391\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-blank-access-database-with-command.png\" alt=\"create blank access database with command\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-blank-access-database-with-command.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-blank-access-database-with-command-300x206.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>3. If you want to change new access database location, click Folder icon next to <strong>File Name<\/strong> box, and browse to computer and choose a location to save access database.<\/p>\n<p>4. Click <strong>Create<\/strong> button under &#8220;File Name&#8221; box.<\/p>\n<h2 id=\"way3\">Way 3: Import existing data into Microsoft Access and save as Access database<\/h2>\n<p>1. Open Microsoft Access and tab <strong>File &#8211; Open<\/strong>.<\/p>\n<p>2. When Open window appears, select the data type you want to import in the drop-down list next to &#8220;File name&#8221; or select &#8220;All Files&#8221;.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/open-exiting-data-in-access.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"405\" class=\"alignnone size-full wp-image-2394\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/open-exiting-data-in-access.png\" alt=\"open existing excel data in access\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/open-exiting-data-in-access.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/open-exiting-data-in-access-300x209.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>3. Browse to the location where the data save. Select it and click &#8220;Open&#8221;.<\/p>\n<p>4. Follow wizard to make sure imported data format adjust to Access and click &#8220;Finish&#8221;.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/adjust-data-format-to-access.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"411\" class=\"alignnone size-full wp-image-2395\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/adjust-data-format-to-access.png\" alt=\"adjust imported data format to access database\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/adjust-data-format-to-access.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/adjust-data-format-to-access-300x213.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>If you want to change data, make changes and save access database. If not, access database has been created and saved in the same location where exiting data is saved.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-existing-data.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"363\" class=\"alignnone wp-image-2397 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-existing-data.png\" alt=\"create access database with existing data successfully\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-existing-data.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-database-with-existing-data-300x188.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>To speak of, Access database creation in Access 2013 is similar to in Access 2007\/2010. There are mainly two ways to create access database in Access 2013. Create database with templates and create a blank database with &#8220;Blank desktop database&#8221; command.<\/p>\n<p>Because of the similarity to use templates to build access database in Access 2007, 2010 and 2013, now let\u2019s only specially introduce how to <strong>build an access database 2013<\/strong> with command.<\/p>\n<h2>How to create a database in Access 2013?<\/h2>\n<p>1. Open Microsoft Access 2013, and tab <strong>File &#8211; New<\/strong>. Or click <strong>Blank desktop database<\/strong> directly in Access interface.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/access-2013-database-choices.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"338\" class=\"alignnone size-full wp-image-2396\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/access-2013-database-choices.png\" alt=\"choose a way to create access 2013 database\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/access-2013-database-choices.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/access-2013-database-choices-300x175.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>2. A new dialog appears with new database default name and location. You can retype a new name for access database, and click the folder icon next to File Name to set a new location for new access database.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-2013-database.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"280\" class=\"alignnone size-full wp-image-2399\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-2013-database.png\" alt=\"create access 2013 database\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-2013-database.png 580w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/03\/create-access-2013-database-300x145.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>3. Click <strong>Create<\/strong> button at last.<\/p>\n<p>Next, it\u2019s time for you to set database table, indexes, field and data type.<\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/access-password\/how-to-encrypt-and-decrypt-access-database.html\">How to Encrypt and Decrypt Access Database<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-open-access-database-without-access-privileges\/\">How to Open Access Database without Access Privileges<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/data-recovery\/undelete-access-database-file-lost-from-recycle-bin.html\">How to Undelete Access Database File Lost from Recycle Bin<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/mdb-password-recovery-after-password-forgot-or-lost\/\">MDB\/ACCDB Password Recovery after Forgot or Lost<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-set-security-level-in-ms-access-2010\/\">How to Set Security Level in MS Access 2010 with Security Features<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-backup-access-database-and-restore-data-or-objects\/\">How to Backup Access Database and Restore Data or Objects<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-manage-user-level-security-in-mdb-file-in-access-2010\/\">How to Set, Manage or Remove User-Level Security from MDB File in Access 2010<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Access is undoubtedly easy for both personal user and enterprise to create a database for saving important&#8230;<\/p>\n","protected":false},"author":1,"featured_media":126297,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-2373","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=2373"}],"version-history":[{"count":6,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2373\/revisions"}],"predecessor-version":[{"id":6740,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2373\/revisions\/6740"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126297"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=2373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=2373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=2373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}