{"id":321,"date":"2022-12-01T20:32:28","date_gmt":"2022-12-01T20:32:28","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/naming-databases\/"},"modified":"2022-12-01T20:32:28","modified_gmt":"2022-12-01T20:32:28","slug":"naming-databases","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/naming-databases\/","title":{"raw":"Naming Databases","rendered":"Naming Databases"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Name the database and location<\/li>\n \t<li>Discuss the role of tables in access<\/li>\n \t<li>Differentiate among types of tables<\/li>\n<\/ul>\n<\/div>\n<img class=\"alignnone wp-image-3208 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/23182608\/Figure12_5.png\" alt=\"Microsoft Access Blank database screen with Field &quot;File Name&quot; filled with the name &quot;Database1.accdb&quot;. File folder button is to the right of the File Name field. This button allows the user to edit the location of the database.\" width=\"974\" height=\"460\">\n\nEnter the name of your database in the \u201cFile Name\u201d field. &nbsp;The database location can be changed by selecting the box to the right of the \u201cFile Name\u201d field and browsing to the location of your choice.\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/5e9ed519-b222-46c7-8f7d-d3e8cd4d4322\n\n<\/div>\n<h2>Understanding Tables<\/h2>\nTables are one of the key objects in Access. Access uses tables to store data. To store data, you create one table for each type of information that you track. Types of information might include customer information, products, or order details.\n\nThe example below is taken from the Microsoft Access \u201cNorthwind Traders\u201d sample database. It is a table containing a list of orders for the fictitious company with reference to Order Number, Order Date, Order Status, etc.\n\n<img class=\"alignnone wp-image-3210 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/23182742\/Figure12_6.png\" alt=\"Microsoft Access \u201cNorthwind Traders\u201d sample database titled &quot;Order List&quot;.\" width=\"974\" height=\"387\">\n<h2>Types of Tables<\/h2>\nThere are three types of tables in Access: an object table, a transaction table, and a join table. Object tables contain data relating to a real-world object, like a company or a customer or a product. Transaction tables store information pertaining to events, like when an order is placed for a product or an invoice is sent to a customer. Finally, join tables are used to establish a relationship between two tables, like a product table and a customer table.\n\nWe will focus on object tables in this section.\n<div class=\"textbox tryit\">\n<h3>Practice Questions<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/9d868233-4e2f-4d38-b9eb-5fbcfe20654f\n\nhttps:\/\/assess.lumenlearning.com\/practice\/f8aae8a6-ab49-41d3-9491-546f7706f563\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\/1521p73cbVe_q5-hyX3ZRGYxG0HXm1him5jBeSvv6Ud8\" 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>Name the database and location<\/li>\n<li>Discuss the role of tables in access<\/li>\n<li>Differentiate among types of tables<\/li>\n<\/ul>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3208 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/23182608\/Figure12_5.png\" alt=\"Microsoft Access Blank database screen with Field &quot;File Name&quot; filled with the name &quot;Database1.accdb&quot;. File folder button is to the right of the File Name field. This button allows the user to edit the location of the database.\" width=\"974\" height=\"460\" \/><\/p>\n<p>Enter the name of your database in the \u201cFile Name\u201d field. &nbsp;The database location can be changed by selecting the box to the right of the \u201cFile Name\u201d field and browsing to the location of your choice.<\/p>\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_5e9ed519-b222-46c7-8f7d-d3e8cd4d4322\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/5e9ed519-b222-46c7-8f7d-d3e8cd4d4322?iframe_resize_id=assessment_practice_id_5e9ed519-b222-46c7-8f7d-d3e8cd4d4322\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Understanding Tables<\/h2>\n<p>Tables are one of the key objects in Access. Access uses tables to store data. To store data, you create one table for each type of information that you track. Types of information might include customer information, products, or order details.<\/p>\n<p>The example below is taken from the Microsoft Access \u201cNorthwind Traders\u201d sample database. It is a table containing a list of orders for the fictitious company with reference to Order Number, Order Date, Order Status, etc.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3210 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/23182742\/Figure12_6.png\" alt=\"Microsoft Access \u201cNorthwind Traders\u201d sample database titled &quot;Order List&quot;.\" width=\"974\" height=\"387\" \/><\/p>\n<h2>Types of Tables<\/h2>\n<p>There are three types of tables in Access: an object table, a transaction table, and a join table. Object tables contain data relating to a real-world object, like a company or a customer or a product. Transaction tables store information pertaining to events, like when an order is placed for a product or an invoice is sent to a customer. Finally, join tables are used to establish a relationship between two tables, like a product table and a customer table.<\/p>\n<p>We will focus on object tables in this section.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Questions<\/h3>\n<p>\t<iframe id=\"assessment_practice_9d868233-4e2f-4d38-b9eb-5fbcfe20654f\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/9d868233-4e2f-4d38-b9eb-5fbcfe20654f?iframe_resize_id=assessment_practice_id_9d868233-4e2f-4d38-b9eb-5fbcfe20654f\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<p>\t<iframe id=\"assessment_practice_f8aae8a6-ab49-41d3-9491-546f7706f563\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/f8aae8a6-ab49-41d3-9491-546f7706f563?iframe_resize_id=assessment_practice_id_f8aae8a6-ab49-41d3-9491-546f7706f563\" 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\/1521p73cbVe_q5-hyX3ZRGYxG0HXm1him5jBeSvv6Ud8\" 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-321\">\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>Naming Databases. <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":4,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Naming Databases\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"93f932a8-c5a5-4319-b6a6-0b4740c1bf37, 4622d235-cf34-41cf-808d-4b6379d988ec, 3863b214-2884-4ab2-8445-07d2908a4862, a214e3d2-e9a9-476d-959e-12e15fafc0ae","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-321","chapter","type-chapter","status-publish","hentry"],"part":317,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/321","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\/321\/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\/321\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=321"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=321"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=321"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}