{"id":1118,"date":"2013-08-10T14:56:26","date_gmt":"2013-08-10T12:56:26","guid":{"rendered":"http:\/\/www.ramses.de\/?page_id=1118"},"modified":"2026-01-05T14:24:51","modified_gmt":"2026-01-05T12:24:51","slug":"access-planung-des-datenbank-designs","status":"publish","type":"page","link":"https:\/\/www.ramses.de\/?page_id=1118","title":{"rendered":"Access &#8211; Planung des Datenbank Designs"},"content":{"rendered":"\n<div class=\"gbp-section\">\n<div class=\"gbp-section__inner gb-element-07f99790\">\n<div class=\"gb-element-8182ca99\">\n<h1 class=\"gb-text gbp-section__headline\">Der Gedanke des Datenbank Designs<\/h1>\n\n\n\n<p class=\"gb-text gbp-section__text\">Beim Bau eines Hauses wird zuerst der Bauplan erstellt, er ist die Grundlage f\u00fcr die praktische Umsetzung.<\/p>\n\n\n\n<p class=\"gb-text gbp-section__text\">Auch bei einer Datenbank beginnen wir mit der theoretischen Planung der Datenbank. Lernen Sie in diesem Seminar die Idee der Normalisierungsverfahren.<\/p>\n<\/div>\n\n\n\n<a href=\"https:\/\/www.ramses.de\/wp-content\/uploads\/AccessX.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"427\" height=\"357\" class=\"gb-media-8b786c0c\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/AccessX.jpg\" title=\"AccessX\" alt=\"\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/AccessX.jpg 427w, https:\/\/www.ramses.de\/wp-content\/uploads\/AccessX-300x251.jpg 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/a>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gbp-section gb-element-35d0d05d\">\n<div class=\"gbp-section__inner\">\n<div class=\"gb-element-c3fde83b\">\n<h2 class=\"gb-text gbp-section__headline\">Mein Konzept f\u00fcr Ihre Schulung<\/h2>\n\n\n\n<p class=\"gb-text gbp-section__text\">Seit mehr als 30 Jahren bin ich als IT Trainer in ganz Deutschland unterwegs. Ob Gruppen- oder Einzelschulung, wir erarbeiten ein Konzept f\u00fcr Sie und Ihr Team!<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gbp-section__inner gb-element-2d563692\">\n<div>\n<h3 class=\"gb-text gbp-section__headline\">Flexibilit\u00e4t<\/h3>\n\n\n\n<p class=\"gb-text gbp-section__text\">Ich schule die Programme in jeder Version, von der Grund- \u00fcber die Aufbauschulung bis zur Programmierung.<\/p>\n<\/div>\n\n\n\n<div>\n<h3 class=\"gb-text gbp-section__headline\">Vor Ort oder Online<\/h3>\n\n\n\n<p class=\"gb-text gbp-section__text\">Wenn ich die Wahl habe, komme ich gerne zu Ihnen. Selbstverst\u00e4ndlich biete ich alle Konzepte auch Online an.<\/p>\n<\/div>\n\n\n\n<div>\n<h3 class=\"gb-text gbp-section__headline\">Diverse Schulungsformen<\/h3>\n\n\n\n<p class=\"gb-text gbp-section__text\">Ob normale Team Schulung oder eine Einzelschulung als Training on the Job, wir besprechen Ihre Ideen.<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gbp-section gb-element-02e34898\">\n<div class=\"gbp-section__inner gb-element-9711777a\">\n<div class=\"gb-element-d4ade0f6\">\n<h2 class=\"gb-text gbp-section__headline\">Mein Kurskonzept f\u00fcr das Datenbank Design<\/h2>\n\n\n\n<div class=\"gb-text gbp-section__text\">Sprechen sie mich gerne an, wenn ich Ihnen ein individuelles Konzept erstellen darf.<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gbp-section__inner gb-element-3459b0b5\">\n<div class=\"gb-accordion\">\n<div class=\"gb-accordion__item gb-accordion__item-ec21a81d\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-efb3fdc5\" id=\"gb-accordion-toggle-efb3fdc5\">\n<h3 class=\"gb-text gbp-card__title gb-text-269be1c4\"><strong>Zielgruppe<\/strong><\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-cdc94d58\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-763f3c80\">\n<div class=\"gb-element-ff2db6dd\">\n<p class=\"gb-text\">Alle Personen, die eine Datenbank planen oder in die Planung einer Datenbank eingebunden sind.<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gb-accordion__item gb-accordion__item-50cdbd1c\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-05c81b78\" id=\"gb-accordion-toggle-05c81b78\">\n<h3 class=\"gb-text gbp-card__title gb-text-97866468\"><strong>Kursziele<\/strong><\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-caf3e98b\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-f1729551\">\n<div class=\"gb-element-a8d350fa\">\n<p class=\"gb-text\">Der Kurs soll die Verfahren zeigen, mit denen eine relationale Datenbank geplant wird.<br>Es soll vermittelt werden, welche \u201eRegeln\u201c f\u00fcr das Designen von Datenbanken zu beachten sind.<br>ACHTUNG : Dieser Kurs ist in erster Linie Theorie !!<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gb-accordion__item gb-accordion__item-771b4deb\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-f498744c\" id=\"gb-accordion-toggle-f498744c\">\n<h3 class=\"gb-text gbp-card__title gb-text-11c6b350\"><strong>Voraussetzungen<\/strong><\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-2a0c93a7\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-0f98d202\">\n<div class=\"gb-element-7e0b435d\">\n<p class=\"gb-text\">Logisches Denken und abstraktes Vorstellungsverm\u00f6gen sind von Vorteil.<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gb-accordion__item gb-accordion__item-4fdd4e86\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-3a1e45f6\" id=\"gb-accordion-toggle-3a1e45f6\">\n<h3 class=\"gb-text gbp-card__title gb-text-b7269be9\"><strong>Dauer<\/strong><\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-03a42201\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-cc543610\">\n<div class=\"gb-element-2cdccc23\">\n<p class=\"gb-text\">Das Kurskonzept sieht eine Dauer von 3 Tagen voraus.<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gb-accordion__item gb-accordion__item-16d18ff3\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-ef8d7bda\" id=\"gb-accordion-toggle-ef8d7bda\">\n<h3 class=\"gb-text gbp-card__title gb-text-247c8acb\"><strong>Kursinhalte<\/strong><\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-b6d3364f\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-213ec7c9\">\n<div class=\"gb-element-a7c48610\">\n<ul class=\"wp-block-list\">\n<li>Prinzip der relationalen Datenbanken<\/li>\n\n\n\n<li>Das Phasenmodell<\/li>\n\n\n\n<li>ER (Entity-Relationship) \u2013 Diagramme<\/li>\n\n\n\n<li>Entscheidungsbaum-Verfahren<\/li>\n\n\n\n<li>Normalisierungsverfahren<\/li>\n\n\n\n<li>Top-Down contra Bottom-Up Methode<\/li>\n\n\n\n<li>Praxisorientierte Verfahren zum DB \u2013 Design<\/li>\n\n\n\n<li>Datenredundanzen \/ Dateninkonsistenzen<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gb-accordion__item gb-accordion__item-6d8d4e53\">\n<div role=\"button\" tabindex=\"0\" class=\"gb-accordion__toggle gb-accordion__toggle-8f1c57d0\" id=\"gb-accordion-toggle-8f1c57d0\">\n<h3 class=\"gb-text gbp-card__title gb-text-b122e703\"><strong>Downloads<\/strong><\/h3>\n\n\n\n<span class=\"gb-accordion__toggle-icon gb-accordion__toggle-icon-de72dd60\"><span class=\"gb-accordion__toggle-icon-open\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"208 96 128 176 48 96\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><span class=\"gb-accordion__toggle-icon-close\"><svg aria-hidden=\"true\" viewBox=\"0 0 256 256\"><rect width=\"256\" height=\"256\" fill=\"none\"><\/rect><polyline points=\"48 160 128 80 208 160\" fill=\"none\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"16\"><\/polyline><\/svg><\/span><\/span>\n<\/div>\n\n\n\n<div class=\"gb-accordion__content\" id=\"gb-accordion-content-0da1f15b\">\n<div class=\"gb-element-122d34e5\">\n<p class=\"gb-text\">Das Kurskonzept zum Download<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.ramses.de\/files\/RAMSES_ACCESS_ER.pdf\" data-type=\"link\" data-id=\"https:\/\/www.ramses.de\/files\/RAMSES_EXCEL_GRUNDLAGEN.pdf\">Kurskonzept<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gbp-section gb-element-54483256\">\n<div class=\"gbp-section__inner\">\n<div class=\"gb-element-938cd203\">\n<h2 class=\"gb-text gbp-section__headline\">Unsere Seminare<\/h2>\n<\/div>\n<\/div>\n\n\n\n<div class=\"gbp-section__inner gb-element-ade024c1\">\n<div><div class=\"gb-looper-50506af0\">\n<div class=\"gb-loop-item post-7559 post type-post status-publish format-standard has-post-thumbnail hentry category-allgemein category-seminare tag-excel resize-featured-image\">\n<a href=\"https:\/\/www.ramses.de\/?p=7559\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"369\" alt=\"\" data-media-id=\"7205\" class=\"gb-media-ecc76230\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Excel-2-768x369.jpg\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Excel-2-768x369.jpg 768w, https:\/\/www.ramses.de\/wp-content\/uploads\/Excel-2-300x144.jpg 300w, https:\/\/www.ramses.de\/wp-content\/uploads\/Excel-2.jpg 1022w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a>\n\n\n\n<p class=\"gb-text gbp-card__meta-text\">16. April 2026<\/p>\n\n\n\n<h2 class=\"gb-text gbp-card__title\"><a href=\"https:\/\/www.ramses.de\/?p=7559\">Microsoft Office &#8211; F\u00fcrsten-Reform Braunschweig<\/a><\/h2>\n\n\n\n<p class=\"gb-text\">F\u00fcrsten Reform, Dr. med. Hans Pl\u00fcmer, Nachfolger GmbH &amp; Co. KG Office in Brauschweig Feature Einf\u00fchrung in das Microsoft Office Microsoft Office spielt in allen&#8230;<\/p>\n\n\n\n<a class=\"gb-text gb-text-6f16db8b\" href=\"https:\/\/www.ramses.de\/?p=7559\">Read More<\/a>\n<\/div>\n\n<div class=\"gb-loop-item post-7513 post type-post status-publish format-standard has-post-thumbnail hentry category-allgemein category-seminare tag-excel resize-featured-image\">\n<a href=\"https:\/\/www.ramses.de\/?p=7513\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"367\" alt=\"\" data-media-id=\"7211\" class=\"gb-media-ecc76230\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Project-3-768x367.jpg\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Project-3-768x367.jpg 768w, https:\/\/www.ramses.de\/wp-content\/uploads\/Project-3-300x143.jpg 300w, https:\/\/www.ramses.de\/wp-content\/uploads\/Project-3.jpg 1024w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a>\n\n\n\n<p class=\"gb-text gbp-card__meta-text\">10. April 2026<\/p>\n\n\n\n<h2 class=\"gb-text gbp-card__title\"><a href=\"https:\/\/www.ramses.de\/?p=7513\">Microsoft Project &#8211; K\u00e4hler Bau B\u00fcsum<\/a><\/h2>\n\n\n\n<p class=\"gb-text\">K\u00e4hler Bau GmbH &amp; Co. KG Project in B\u00fcsum Feature Einf\u00fchrung in das Microsoft Project Die expert SE mit Sitz in Langenhagen ist eine Handelsverbundgruppe&#8230;<\/p>\n\n\n\n<a class=\"gb-text gb-text-6f16db8b\" href=\"https:\/\/www.ramses.de\/?p=7513\">Read More<\/a>\n<\/div>\n\n<div class=\"gb-loop-item post-7507 post type-post status-publish format-standard has-post-thumbnail hentry category-allgemein category-seminare tag-excel resize-featured-image\">\n<a href=\"https:\/\/www.ramses.de\/?p=7507\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"369\" alt=\"\" data-media-id=\"7205\" class=\"gb-media-ecc76230\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Excel-2-768x369.jpg\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Excel-2-768x369.jpg 768w, https:\/\/www.ramses.de\/wp-content\/uploads\/Excel-2-300x144.jpg 300w, https:\/\/www.ramses.de\/wp-content\/uploads\/Excel-2.jpg 1022w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a>\n\n\n\n<p class=\"gb-text gbp-card__meta-text\">10. April 2026<\/p>\n\n\n\n<h2 class=\"gb-text gbp-card__title\"><a href=\"https:\/\/www.ramses.de\/?p=7507\">Microsoft Excel &#8211; Bistum Hildesheim<\/a><\/h2>\n\n\n\n<p class=\"gb-text\">Bistum Hildesheim Excel in Hildesheim Feature Einf\u00fchrung in das Microsoft Excel Die expert SE mit Sitz in Langenhagen ist eine Handelsverbundgruppe f\u00fcr Consumer Electronics, Informationstechnologie,&#8230;<\/p>\n\n\n\n<a class=\"gb-text gb-text-6f16db8b\" href=\"https:\/\/www.ramses.de\/?p=7507\">Read More<\/a>\n<\/div>\n<\/div><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Der Gedanke des Datenbank Designs Beim Bau eines Hauses wird zuerst der Bauplan erstellt, er ist die Grundlage f\u00fcr die praktische Umsetzung. Auch bei einer &#8230; <a title=\"Access &#8211; Planung des Datenbank Designs\" class=\"read-more\" href=\"https:\/\/www.ramses.de\/?page_id=1118\" aria-label=\"Mehr Informationen \u00fcber Access &#8211; Planung des Datenbank Designs\">Weiterlesen &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":690,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1118","page","type-page","status-publish"],"_links":{"self":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/pages\/1118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1118"}],"version-history":[{"count":5,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/pages\/1118\/revisions"}],"predecessor-version":[{"id":7441,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/pages\/1118\/revisions\/7441"}],"up":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/pages\/690"}],"wp:attachment":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}