MS Access Database

City University London
Em Islington (Reino Unido)

Preço a consultar

Informação importante

  • Short course
  • Islington (Reino Unido)
  • Quando:
    à escolha
Descrição

Starting from the fundamentals of how to design and build databases in Microsoft Access, this fully hands-on course moves swiftly to cover tables, relationships, forms, queries, reports and macros. It ends with an introduction to modules and Access programming. Course Information Start DateStart TimeDurationCostCourse CodeApply Thursday 6 October 2016 18:30 - 20:30 10 weekly classes £430.00 CS1594 Apply Now Monday 16 January 2017 18:30 - 20:30 10 weekly classes £430.00 CS1594 Apply Now Wednesday 3 May 2017 18:30 - 20:30 10 weekly classes £430.00 CS1594 Apply Now Tutor Info George K. Lekeas is a visiting lecturer with the Department of Computer Science in the School of Mathematics, Computer Science & Engineering and research collaborator with the University of Athens. He holds a PhD in Computing and conducts research in the area of Multi-Agent Systems and Web Services. He taught extensively at all levels courses in software development methods, programming and software engineering in general (C#, C, C++, Unix, Systems Administration, PHP, Perl, Java, Oracle, MySQL, XML, CMS) and other computing areas. He also works as a freelance Unix and Web Scripting Languages consultant. Eligibility Working knowledge of Excel is an advantage. English Requirements Applicants must be proficient in written and spoken English.

Informação importante
Instalações

Instalações e datas

Início Localização
à escolha
Islington
Northampton Square, EC1V 0HB , London, Reino Unido
Ver mapa

O que se aprende nesse curso?

Access
Computing
C++
Unix
IT
Database
Database training
English
Design
Web
systems
Engineering
Programming

Programa

What will I learn?
  • Introduction: Course overview, a quick overview of MS Access for windows. Database theory: Define a database, table, record, field, data types, key fields, indexes and object in Access.
  • Creating tables I: Define the table structure, data entry.
  • Creating tables II: Copying and restructuring the table design, modifying the field properties, using formats and input masks. Renaming and deleting tables.
  • Importing and Exporting Data Relationships Database Management organisation: Data sorting, indexing and validation.
  • Creating Forms: Creating forms from scratch, changing the field properties on the form, calculations on forms, data entry forms.
  • Using the form wizards.
  • Creating Queries: Introduction to the different query types. Writing Select queries using: Logical Operators: And, Or, Not and Null. Mathematical operators and calculations.
  • Creating queries for: Global Delete, change and insert, Making Tables and Appending Tables.
  • Creating Reports: Creating reports from scratch, Report headers and footers, calculations on reports. Using the form wizards to create mailing lists.
  • Creating Advanced/complex Forms/Reports: Creating Main/ Sub-reports from scratch. Graphs in reports/forms.
  • Macros: Creating and running macros.
  • Modules: Creating VBA code.
  • Database Administration and Security.

Informação adicional

Teaching and Assessment

Assessment will be by completion of set exercises.The tutor will also record the student's progress.