Basic Access 2013, 2016 snd 2019 Training Courses
DMW’s Basic Introductory Microsoft Access course is for anyone who is new to database creation or who is self-taught and wants to fill in gaps in their basic skills.
The success of your database depends on careful planning of its structure before you hit the keyboard and on understanding how to create this structure in Microsoft Access 2013, 2016 or 2019.
Taking some training before you start is a wise move if you are to avoid getting off on the wrong foot. Nothing worse for a database developer than, after a couple of months of your users inputting records, to come to realise you’ve messed up on the tables!
Course content is adjusted to suit the sorts of databases you intend to create. These are topicss that are core to most courses:
Why use a database Why a database and not some other program, like a spreadsheet.
Terminology Understand database terminology—Access uses the vocabulary of the database developer and therefore you need a grasp of the jargon.
Planning How to plan for a successful database—there are rules for storing data in a database that need to be followed.
Database objects Components of a relational database: the engine room that manages the data; the user interface that hides the technicalities from the user; the reporting function for outputting information.
Access database Examining how Access works as a RDBMS (relational database management system).
New database How to start a new database in Access.
Tables Understanding tables, fields and record.
Tables Working with more than one table.
Table creation How to create an Access data table.
Fields Data types; properties; primary keys; indexing; validation.
Relationships Types of relational links between tables; how to create links.
Queries Their importance in a database and where and when to use them.
Query design Creating single- and multi-table queries.
Sorting Using queries to sort data.
Filtering by query Using queries to list records that match your criteria; use of wildcards in criteria.
Calculations Using queries to perform calculations on your data.
Forms Their role in a database. When to use them.
Form design Creating a form using a Wizard; modifying the appearance and behaviour of a form.
Reports Their part in a database.
Report design Creating a report using a Wizard; modifying the appearance of a report.
Conclusion Reflection on what you have learnt and how you might apply Access to your database.
Two days on-site, normally between 9:30am and 4:30pm on each day.
The usual pattern is database design and table creation on the first morning with queries in the afternoon; forms and reports on the second day.
Some clients like a gap between the two days so that they can reflect on what they learn about setting up their database before moving on to find out about designing user interface screens and reports for printing.
Competence in the use of the mouse, keyboard and windows, and ribbons. Awareness of basic computer principles like files, folders and filing.
Some thought given to why you might want to use a database in the first place.