|
Teaching GuideTerm Higher Technical University College of Nautical Science and Naval Engines |
| Grao en Náutica e Transporte Marítimo |
 Subjects |
| Applied Informatics |
| Contents |
|
|
| Identifying Data | 2020/21 | |||||||||||||
| Subject | Applied Informatics | Code | 631G01501 | |||||||||||
| Study programme |
|
|||||||||||||
| Descriptors | Cycle | Period | Year | Type | Credits | |||||||||
| Graduate | 2nd four-month period |
Third | Optional | 6 | ||||||||||
|
||||||||||||||
| Topic | Sub-topic |
| 1. FORMS, CONTROLS & DRAWING OBJECTS | 1.1. INTRODUCTION 1.2. FORMS 1.3. CONTROLS 1.4. ADDING INTERACTIVITY 1.5. DRAWING OBJECTS |
| 2. MACROS | 2.1. INTRODUCTION 2.2. ADDING THE DEVELOPER TAB 2.3. ENABLE MACROS 2.4. STARTING EXCEL MACRO RECORDER 2.5. MACRO RECORDER OPTIONS 2.6. RECORDING THE MACRO 2.7. RUNNING THE MACRO 2.8. EDITING THE MACRO |
| 3. VBA BASICS | 3.1. LANGUAGE 3.2. VBA EDITOR 3.3. EXCEL VBA OBJECTS 3.4. VARIABLES 3.5. CONSTANTS 3.6. DIALOG BOXES |
| 4. PROGRAMMING | 4.1. THE CODE 4.2. CONTROLLING CODE EXCECUTION 4.3. MANIPULATING OBJECTS & COLLECTIONS 4.4. USEFUL APPLICATION PROPERTIES 4.5 RANGE OBJECTS |
| 5. PROCEDURES | 5.1. SUB PROCEDURES 5.2. FUNCTION PROCEDURES 5.3. PROCEDURE ARGUMENTS |
| 6. USER FORMS | 6.1. ALTERNATIVES 6.2. CREATING A USERFORM |
| 7. EXCEL & ACCESS INTEGRATION | 7.1. INTRODUCTION 7.2. ADO 7.3. FROM ACCESS TO EXCEL 7.4. FROM EXCEL TO ACCESS 7.5. SQL 7.6. RECORDSET OBJECT |
| 8. CUSTOMIZE | 8.1. EXCEL RIBBON 8.2. ADD-IN |
| 9. BLOGS | 9.1 INTRODUCTION 9.2. PUBLICATION 9.3. MARINA MERCANTE BLOG 9.4. WORDPRESS |
| 10. SOCIAL NETWORKS | 10.1 INTRODUCTION 10.2. LINKEDIN |
|
