{"id":392,"date":"2011-04-29T12:44:02","date_gmt":"2011-04-29T12:44:02","guid":{"rendered":"http:\/\/eric.univ-lyon2.fr\/~jdarmont\/wp\/?page_id=392"},"modified":"2025-03-21T09:41:03","modified_gmt":"2025-03-21T07:41:03","slug":"maitrise-de-sciences-economiques-visual-basic-bases-de-donnees","status":"publish","type":"page","link":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/?page_id=392","title":{"rendered":"Ma\u00eetrise de Sciences \u00c9conomiques &#8211; Visual Basic &#038; Bases de donn\u00e9es"},"content":{"rendered":"<p><a href=\"https:\/\/web.archive.org\/web\/20190802214724\/https:\/\/eco.univ-lyon2.fr\/\">Facult&eacute; de Sciences &Eacute;conomiques et de Gestion<\/a>, <a href=\"https:\/\/www.univ-lyon2.fr\">Universit&eacute; Lumi&egrave;re Lyon 2<\/a>, Ann&eacute;e 2000-2001.<\/p>\n<p><!-- Pre-requis --><\/p>\n<h3>Pr&eacute;-requis<\/h3>\n<ul>\n<li>Cours d&rsquo;algorithmique et de programmation de 2&egrave;me ann&eacute;e<\/li>\n<li>Cours d&rsquo;Excel avanc&eacute; de Licence<\/li>\n<li>Cours de bases de donn&eacute;es et d&rsquo;Access de Licence<\/li>\n<\/ul>\n<p><!-- Objectif --><\/p>\n<h3>Objectif du cours<\/h3>\n<p>Permettre la r&eacute;alisation en TD d&rsquo;un projet informatique complet en Visual Basic avec acc&egrave;s &agrave; une base de donn&eacute;es Access.<\/p>\n<p><!-- Plan --><\/p>\n<h3>Plan du cours<\/h3>\n<ol>\n<li>Objectifs<\/li>\n<li>Rappels de Visual Basic<\/li>\n<li>Connexion VB-Access<\/li>\n<li>Connexion Excel-Access<\/li>\n<\/ol>\n<p><!-- Organisation pedagogique --><\/p>\n<h3>Organisation p&eacute;dagogique<\/h3>\n<p>Cours magistral (10 h) + TD (15 h). En TD, 5 s&eacute;ances seront des TD classiques, 5 s&eacute;ances seront consacr&eacute;es uniquement au projet.<\/p>\n<p><!-- Evaluation --><\/p>\n<h3>Modalit&eacute;s d&rsquo;&eacute;valuation<\/h3>\n<p>Notation du projet : rapport &eacute;crit + d&eacute;mo.<\/p>\n<p><!-- Planning --><\/p>\n<h3>Planning des s&eacute;ances<\/h3>\n<table>\n<tr>\n<th>S&eacute;ance<\/th>\n<th>Date<\/th>\n<th>Horaire<\/th>\n<th>Salle<\/th>\n<th>Sujet<\/th>\n<\/tr>\n<tr>\n<td>Cours 1 (3h)<\/td>\n<td>lundi 25 septembre<\/td>\n<td>17h-20h<\/td>\n<td>Amphi 136<\/td>\n<td>Objectifs, Rappels de VB<\/td>\n<\/tr>\n<tr>\n<td>Cours 2 (2h)<\/td>\n<td>jeudi 28 septembre<\/td>\n<td>18h-20h<\/td>\n<td>Amphi 136<\/td>\n<td>Rappels de VB<\/td>\n<\/tr>\n<tr>\n<td>Cours 3 (3h)<\/td>\n<td>lundi 2 octobre<\/td>\n<td>17h-20h<\/td>\n<td>Amphi 136<\/td>\n<td>Connexion aux bases de donn&eacute;es<\/td>\n<\/tr>\n<tr>\n<td>TD 1 (1h40)<\/td>\n<td>semaine du 2 octobre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Discussion sur les sujets de projet, Visual Basic<\/td>\n<\/tr>\n<tr>\n<td>Cours 4 (2h)<\/td>\n<td>jeudi 5 octobre<\/td>\n<td>18h-20h<\/td>\n<td>Amphi 136<\/td>\n<td>Questions et &eacute;tudes de cas<\/td>\n<\/tr>\n<tr>\n<td>TD 2 (1h40)<\/td>\n<td>semaine du 9 octobre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Visual Basic<\/td>\n<\/tr>\n<tr>\n<td>TD 3 (1h40)<\/td>\n<td>semaine du 16 octobre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Visual Basic &amp; Access<\/td>\n<\/tr>\n<tr>\n<td>Remise des sujets<\/td>\n<td>20 octobre<\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>TD 4 (1h40)<\/td>\n<td>semaine du 23 octobre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Visual Basic<\/td>\n<\/tr>\n<tr>\n<td>TD 5 (1h40)<\/td>\n<td>semaine du 30 octobre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Visual Basic &amp; Access<\/td>\n<\/tr>\n<tr>\n<td>TD 6 (1h40)<\/td>\n<td>semaine du 6 novembre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Projet<\/td>\n<\/tr>\n<tr>\n<td>TD 7 (1h40)<\/td>\n<td>semaine du 13 novembre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Projet<\/td>\n<\/tr>\n<tr>\n<td>TD 8 (1h40)<\/td>\n<td>semaine du 20 novembre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Projet<\/td>\n<\/tr>\n<tr>\n<td>TD 9 (1h40)<\/td>\n<td>semaine du 27 novembre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>Projet<\/td>\n<\/tr>\n<tr>\n<td>TD 10 (1h40)<\/td>\n<td>semaine du 4 d&eacute;cembre<\/td>\n<td><\/td>\n<td>Salle 6<\/td>\n<td>D&eacute;mos<\/td>\n<\/tr>\n<\/table>\n<p><!-- En ligne --><\/p>\n<h3>Mat&eacute;riel en ligne<\/h3>\n<ul>\n<li><a href=\".\/docs\/old\/vb0001\/vb-maitrise.pdf\">Support de cours<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (190 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/cas_vbbd.pdf\">&Eacute;tude de cas<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (314 Ko) + <a href=\".\/docs\/old\/vb0001\/catalogue.zip\">Code VB<\/a> de l&rsquo;&eacute;tude de cas (compress&eacute; .zip, 3 Ko)<\/li>\n<li><a href=\"ftp:\/\/sceco-nte.univ-lyon2.fr\/goutte\/Maitrise\/Enonce.PDF\">TD n&#176; 1 et 2<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (114 Ko) + <a href=\"ftp:\/\/sceco-nte.univ-lyon2.fr\/goutte\/Maitrise\/Codes.PDF\">correction<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (20 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/td4.pdf\">TD n&#176; 4<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (112 Ko) + <a href=\".\/docs\/old\/vb0001\/td4.zip\">application VB<\/a> (compress&eacute;e .zip, 13 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/td6.pdf\">TD n&#176; 6<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (53 Ko) + <a href=\".\/docs\/old\/vb0001\/td6.zip\">application VB<\/a> (compress&eacute;e .zip, 3 Ko)<\/li>\n<\/ul>\n<ul>\n<li><a href=\"ftp:\/\/sceco-nte.univ-lyon2.fr\/boussaid\/Programmation\/Polycope de programmation.pdf\">Support de cours de VB de 2&egrave;me ann&eacute;e<\/a> de M. Boussa&iuml;d <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (229 Ko)<\/li>\n<\/ul>\n<h4>TD de bases de donn&eacute;es de Licence (corrig&eacute;s) :<\/h4>\n<ul>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td1.pdf\">TD 1<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (51 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td2.pdf\">TD 2<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (17 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td3.pdf\">TD 3<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (40 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td4.pdf\">TD 4<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (150 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td5.pdf\">TD 5<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (48 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td6.pdf\">TD 6<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (123 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td7.pdf\">TD 7<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (23 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td8.pdf\">TD 8<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (17 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td9.pdf\">TD 9<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (49 Ko)<\/li>\n<li><a href=\".\/docs\/old\/vb0001\/bd-td10.pdf\">TD 10<\/a> <img decoding=\"async\" src=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/wp-content\/uploads\/2011\/04\/pdf.gif\" alt=\"PDF\" \/> (58 Ko)<\/li>\n","protected":false},"excerpt":{"rendered":"<p>Facult&eacute; de Sciences &Eacute;conomiques et de Gestion, Universit&eacute; Lumi&egrave;re Lyon 2, Ann&eacute;e 2000-2001. Pr&eacute;-requis Cours d&rsquo;algorithmique et de programmation de 2&egrave;me ann&eacute;e Cours d&rsquo;Excel avanc&eacute; de Licence Cours de bases de donn&eacute;es et d&rsquo;Access de Licence Objectif du cours Permettre la r&eacute;alisation en TD d&rsquo;un projet informatique complet en Visual Basic avec acc&egrave;s &agrave; une\u2026 <span class=\"read-more\"><a href=\"https:\/\/eric.univ-lyon2.fr\/jdarmont\/?page_id=392\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":7,"featured_media":0,"parent":300,"menu_order":2070,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-392","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=392"}],"version-history":[{"count":6,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages\/392\/revisions"}],"predecessor-version":[{"id":8869,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages\/392\/revisions\/8869"}],"up":[{"embeddable":true,"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=\/wp\/v2\/pages\/300"}],"wp:attachment":[{"href":"https:\/\/eric.univ-lyon2.fr\/jdarmont\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}