Study at City
  1. Courses
  2. Applying
  3. Fees and funding
  4. Living in London
  5. Visit us & online events
  6. Student support
  7. International students
  8. Order a prospectus
  9. Ask a student
  1. Short courses
  2. Courses
Study at City

Microsoft Access Database Short Course

Key information

Choose a start date
To be confirmed
To be confirmed
To be confirmed
To be confirmed
Course Code:
To be confirmed
To be confirmed
Booking Deadline:
To be confirmed
To be confirmed
Covid-19 update: The learning doesn't have to stop, join our online community. We will be delivering courses remotely until further notice. Live tutor support and virtual lessons will take place during advertised teaching hours. The classes are taught in small groups, so you'll get lots of support from your tutor. Book now.

Learn how to manage your data and create detailed reports simply and easily.

Why choose this course?

This highly popular short course is ideal for anyone in an Access database developer's/administrator's role, or where Access is a component of a diverse data management solution.

The Microsoft Access Database Access short course is for everyone who uses data and would like to quickly create reports without the need for programming knowledge.

The short course is tutored by a professional academic at the University and provides a great introduction to programming with Access.

This practical short course takes the form of a series of evening classes taking place once a week in our Central London location.

Course overview

Starting from the fundamentals of how to design and build databases in Microsoft Access, the Microsoft Access Database short course is a fully hands-on evening class that moves swiftly to cover tables, relationships, forms, queries, reports and macros.

The short course ends with an introduction to modules and Access programming.

What will I learn?

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.



Prerequisite knowledge

Working knowledge of Excel is an advantage.

English requirements

You must be proficient in written and spoken English.

Teaching & assessment

Teaching & assessment

Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.

Tutor information

  • George K. Lekeas

    George K. Lekeas is a visiting lecturer at City, University of London in the Department of Computer Science in the School of Mathematics, Computer Science & Engineering. He is also working as a Systems Administrator with University College London, where part of his duties includes administration of Office365 solutions, including SharePoint, and is a 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 has taught courses at all levels in software development methods, programming, and software engineering in general (C#, C, C++, Unix, Systems Administration, PHP, Perl, Java, Oracle, MySQL, XML, CMS, Web Services) and other areas of computing. He also works as a freelance Unix and web scripting languages consultant.

Next steps

This Microsoft access VBA Programming Short Evening Course develops your existing Access knowledge and enables you to develop professional VBA programming skills.…