This introduction to Microsoft Access provides the perfect foundation for developing expertise. Even though it is a beginner’s course, delegates will build two fully functioning relational databases. Chester Tugwell, your course tutor, started his Microsoft Access training career back in the late 1990s and over the years he has fine-tuned his content and delivery to culminate in this excellent course.
Chester has designed this course to be as hands-on as possible. It is project-based and takes you through the steps involved in building an Access relational database from the ground up.
Topics Covered in the Course
Relational Database Theory – what is a relational database and how does it compare to the way data is stored in Excel, for example?
Tables – designing tables to store data. Setting data types and field properties.
Importing Data – importing data into your Access database stored in Excel or as text files.
Creating Relationships Between Tables – understanding primary and foreign keys and creating relationships between tables.
Design Forms – that look great and function well.
Select Queries – understand how to set AND/OR criteria, use comparison operators and wildcards.
Design Reports – that look professional.
Create a Front-End for your Database – create a navigation form with command buttons that open your forms and reports. Set database options that control what appears/doesn’t appear to your users when they open the database.
The course was created using Access 365 (2019) but will work for earlier versions.