Normalised database from a broken spreadsheet
Deliverable: A real flat sheet with repeated data, redesigned into normalised tables with keys and relationships, imported and verified so no records are lost in the move.
Course
MS Access
Database work for the office — designing tables that hold up, querying them properly, and building forms and reports colleagues can use without breaking anything.
- Duration: 6 weeks
- Classroom · Online live
- Level: beginner to advanced
What you will be able to do
- Design normalised tables with correct keys and relationships
- Write select, parameter, update and aggregate queries
- Join related tables and understand what each join type returns
- Build forms that validate input before it reaches a table
- Produce grouped, formatted reports fit to print or send
- Recognise when a problem has outgrown Access and needs a real server
Who this course is for
- Comfortable with Windows and basic Excel
- Office, admin and MIS staff whose spreadsheets have grown unmanageable
- Anyone who needs to store related records rather than a flat list
- No prior database experience required
Syllabus
6 modules · 6 weeks
Module 1. Why a database, not a spreadsheet
- What goes wrong when a sheet holds related records
- Tables, records, fields and data types
- Primary keys and why every table needs one
- Creating a database and importing existing data
Module 2. Designing tables that hold up
- Normalisation to third normal form, taught with a real messy sheet
- One-to-many and many-to-many relationships
- Foreign keys and referential integrity
- Validation rules, input masks and lookups
Module 3. Queries
- Select queries, criteria and sorting
- Inner, left and right joins and what each returns
- Calculated fields and expressions
- Totals, grouping and parameter queries
Module 4. Action queries and data maintenance
- Update, append and delete queries, and how to test one safely
- Make-table queries and archiving
- Finding duplicates and unmatched records
- Backups and compact-and-repair
Module 5. Forms
- Form layouts and bound controls
- Subforms for related records
- Combo boxes driven by lookup tables
- Validation and useful error messages
Module 6. Reports and sharing
- Grouping, sorting and totals in a report
- Layout for print and for PDF
- Splitting front end from back end for shared use
- Exporting to Excel and linking to external data
Tools and technologies you will use
- Microsoft Access
- Access query designer and SQL view
- Forms and report designer
- Microsoft Excel
Projects you will build
Data entry front end
Deliverable: A form with a subform for related records, lookup-driven combo boxes and validation that refuses incomplete entries with a message a colleague can act on.
Grouped management report
Deliverable: A report grouped and totalled at two levels, formatted to print cleanly and export to PDF, driven by a parameter query the user supplies at run time.
Where this course can take you
- MIS Executive
- Data Entry Operator
- Office Administrator
- Junior Database Assistant
Duration, modes and fees
- Duration
- 6 weeks
- Delivery modes
- Classroom · Online live
- Fees
- Share your details for the current fee
- Fees vary by batch and delivery mode. Ask about the combined fee if you take this alongside Advanced Excel.
Placement assistance
Every student gets placement assistance — that is what 100% placement assistance means. It is support for all, not a job for all. We do not promise a specific salary, a specific number of interviews, or placement at any named company, and you should be wary of anyone who does.
What is included
- A place in the monthly placement drive, held every third Saturday
- The readiness programme every second Saturday — mock interviews and preparation
- CV review against the specific roles you are targeting
- Portfolio review, so your project work is presented the way a reviewer will read it
- Access to the vacancy pool employers send directly to the Samyak network
- Guidance on which roles realistically fit your background and which do not
- A place in the next drive, with coaching, if you are not selected in this one
What is not included
- Any guarantee of a job, an interview, or a particular salary
- Placement at a named or partner company
- Applying to jobs on your behalf
- Support before you have completed the course and its project work
- Visa, relocation or overseas placement assistance
The spreadsheet that stopped coping
Almost everyone arrives with the same file: one sheet, thousands of rows, and the customer’s name and address retyped on every single line.
It works until the customer moves. Then it is in there four hundred times, three hundred and eighty of them get updated, and no report agrees with any other report again. That is not carelessness — it is what happens when related data is forced into a flat grid.
Access stores each fact once and links to it. The first two modules are about making that move properly, using a real messy sheet rather than a tidy example.
Design first, because the rest follows from it
Most Access databases that become unusable were badly designed on day one and patched afterwards.
So normalisation comes before queries, forms or reports, and it is taught with an actual spreadsheet rather than abstractly. Get the tables right and the queries are straightforward, the forms almost design themselves, and a later migration to a proper server is a manageable job. Get them wrong and everything downstream is a workaround.
Forms are for other people
You can enter data straight into a table. Nobody else should.
The forms module exists because the person typing is usually not the person who built the database, and a well-made form is what stops a typo becoming a permanent record. Validation, lookups and error messages that say what is actually wrong are the difference between a database that stays clean and one that needs a rescue in six months.
When to stop using Access
There is a real ceiling — file size, concurrent users, performance under load — and the last module gives you the actual numbers rather than a vague warning.
Knowing where that line is makes you more useful, not less. Recommending a departmental Access database where it genuinely fits, and recognising when the job needs MySQL or SQL Server instead, is a judgement most offices are short of.
Questions
MS Access — frequently asked questions
When should I use Access instead of Excel?
When your data has relationships — customers who have many orders, students who have many marks — and a spreadsheet is forcing you to repeat the same values on every row. That repetition is where errors come from. Access stores each fact once and links to it, which is the whole reason the tool exists.
Is MS Access still used in offices?
Widely, in small and mid-sized organisations, for exactly the jobs it suits — a departmental database that a few people share and nobody wants to buy a server for. It is not the right tool for a web application or a large multi-user system, and the last module is honest about where that line falls.
Do I need Access to learn SQL?
No, but they help each other. Access has an SQL view behind every query, so you can build something visually and then read the SQL it generated, which is a gentle way in. If your goal is a data or developer role, take the SQL course as well — it targets the databases those roles actually use.
What if my database grows too big?
Then you migrate, and the course covers how to see it coming — file size limits, concurrent user limits and performance under load are all discussed with the numbers. A well-normalised Access database moves to MySQL or SQL Server far more easily than a badly designed one, which is another reason the design module comes early.
Enquire about MS Access
Three details is all we need. A course advisor will call you back.
Related courses
- SQL and Databases
SQL taught against a database big enough that a bad query is noticeably slow, because toy datasets hide performance entirely and performance is half of what the job tests.
- Advanced Excel
The Excel that offices actually run on — lookup logic, PivotTables, Power Query pipelines, dashboards and enough VBA to automate the work you repeat every month.
- Advanced Excel VBA and Macros
Excel automation taught as programming rather than as macro recording, so the tools you build keep working when the data changes and somebody else opens the file.
- MS Office
The four applications every Indian office runs on, taught around the tasks you will actually be judged on rather than as a tour of every menu.
Next step
Talk to a course advisor
Tell us what you want to learn and we will help you pick the right course, batch and mode.