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 |
|