Database and Information Management for Administrators (AS-035) Training Course

Database and Information Management for Administrators

Contact lists, supplier records, membership data, asset registers, training records and request logs are central to administrative work. When information is scattered…

5 daysClassroom or online

49Upcoming dates

12Cities

£2,250Fees from

Course overview

Introduction

Contact lists, supplier records, membership data, asset registers, training records and request logs are central to administrative work. When information is scattered across spreadsheets, inboxes and paper files, it becomes hard to find, easy to duplicate and difficult to keep accurate.

This Database and Information Management for Administrators training course introduces practical ways to organise, maintain and use information effectively. Participants learn the basics of database design, data entry standards, data quality, searching and reporting, and how to choose between spreadsheets, simple database tools and organisational systems.

The course also covers data protection, access control, retention and the procedures needed to keep shared information reliable, so administrators can provide accurate information quickly and confidently.

Course Objectives

By the end of this training course, participants will be able to:

Explain the principles of organising information as structured data
Design simple tables and fields for common administrative records
Set data entry standards that improve consistency and accuracy
Use queries, filters and reports to retrieve and summarise information
Identify and correct duplicates, gaps and errors in records
Apply data protection, confidentiality and access principles
Manage information retention, archiving and secure disposal
Choose appropriate tools for different information management needs

Target Audience

This training course is suitable for a wide range of professionals, including:

Administrative officers and assistants
Records and information officers
Office managers and coordinators
HR, membership and customer administration staff
Data entry and registry staff
Project support officers
Staff responsible for maintaining shared registers

Training Methodology

Participants work hands-on with sample administrative data, designing simple databases, cleaning records, writing queries and building reports. Short explanations are followed by guided practice and a final project in which participants design an information management solution for a task from their own workplace.

Target Competencies

Data organisation
Database design basics
Data quality management
Information retrieval and reporting
Data protection awareness
Records lifecycle management

Course outline

1Day One: Information as an Asset

Why Information Management Matters: Efficiency, accuracy and compliance
Structured and Unstructured Information: Records, documents and messages
Common Problems: Duplicates, inconsistent entries and lost files
Spreadsheets, Databases and Business Systems: When to use each
Roles and Ownership: Who maintains which information
Mapping Information Flows in the Office
Exercise: Auditing a shared contact list

2Day Two: Designing Simple Databases

Tables, Records and Fields: Core database concepts
Choosing Field Types and Formats
Unique Identifiers and Avoiding Duplicate Records
Relationships Between Tables: Contacts, organisations and activities
Lookup Lists and Validation Rules
Forms for Accurate Data Entry
Practical Exercise: Designing a supplier and contract register

3Day Three: Data Quality and Maintenance

Data Entry Standards: Names, addresses, dates and codes
Finding and Merging Duplicate Records
Correcting Inconsistent and Missing Data
Regular Data Quality Checks and Audits
Change Control: Who can edit and how changes are recorded
Importing and Exporting Data Between Systems
Workshop: Cleaning a sample membership database

4Day Four: Retrieving and Reporting Information

Searching, Sorting and Filtering Records
Building Queries to Answer Common Questions
Creating Summary Reports and Simple Dashboards
Mail Merge for Letters, Labels and Emails
Scheduling Regular Reports for Managers
Presenting Information Clearly to Managers and Colleagues
Practical Exercise: Producing a monthly activity report

5Day Five: Protection, Retention and Improvement

Data Protection Principles for Administrative Records
Access Rights, Passwords and Sharing Controls
Retention Schedules, Archiving and Secure Disposal
Backups and Recovery of Important Information
Improving Information Processes in the Office
Personal Action Plan: Information management improvements
Final Project: Designing an information solution for a workplace task

Frequently asked questions

How long is the Database and Information Management for Administrators course?

The course runs over 5 days of classroom training, usually Monday to Friday.

When is the next Database and Information Management for Administrators course?

The next public date is 7 - 11 Dec 2026 in Barcelona. There are 49 upcoming dates in total.

Where is this course held?

Upcoming sessions run in Barcelona, Frankfurt, London, Madrid, Munich, Paris, Rome, Vienna, Cape Town, Dubai, Istanbul, Kuala Lumpur.

Can I take Database and Information Management for Administrators online?

Yes. Every date can also be joined live online in a virtual classroom with the trainer, for £1,280 per participant. Choose "Live online" in the dates table when you register.

How much does the course cost?

Fees start from £2,250 per delegate, depending on the city. Fees include tuition and course materials.

Do participants receive a certificate?

Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.

Can this course be delivered in-house for our team?

Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.

Course information last updated 14 November 2026.

Database and Information Management for Administrators

Course overview

Introduction

Course Objectives

Target Audience

Training Methodology

Target Competencies

Course outline

Dates and fees

Frequently asked questions

More Administration and Secretarial courses

Achieving Administrative Excellence

Administrative Performance Review and Office Audit

Advanced Excel for Administrative Professionals

Training a team?