Access database Course, Lesson 8a1: Housekeeping in Access
1 -day course: Data Analysis with MS Access Queries, Private 1-to-1.
This MS Access Course focusses on creative queries, which is used to find data subsets from major data sets, finding insights for report.
In this course one would learn and explore various how to create queries. You would learn about MS Access queries, constructing where clauses, aggregation, joins and more.
Book the MS Access Intermediate Course course: https://pcworkshopslondon.co.uk/ms-ac...
Our style is personalised, teaching 1-1. This ensures your to gain maximise the value the day.
Who Should Attend:
People who need to do in-depth data analysis, using MS Access.
MS Access Intermediate Course Agenda:
https://pcworkshopslondon.co.uk/ms-ac...
Session 1: Database Concepts
Tables, Referential Integrity, Table Relationships
Session 2: MS Access Queries
Select Queries, selecting columns and using where clauses
Multiple table queries, joining tables using query design
In null, is not null, Wildcards, Totals
Session 3: MS Access Queries
Expression queries.
Action queries: Make Table Queries to create new queries from existing query or tables,
Queries to insert new records, Append queries, Update queries, Delete queries.
Session 4: MS Access Importing Data
Importing Data, Exporting Data, Linking Data
Session 5: MS Access Forms
Linking Data Creating Forms
Creating forms, Form wizards
Creating a Navigation Form
Session 6: MS Access Reprts
Brief overview of Creating and viewing MS Access reports
Book the MS Access Intemediate course: https://pcworkshopslondon.co.uk/ms-ac...
WHAT IS INCLUDED IN THE MS ACCESS INTERMEDIATE COURSES:
MS Access Intermediate Course Certificate on completion
MS Access Intermediate Course notes
Practical MS Access Intermediate Course exercises, MS Access Intermediate Code Samples/ MS Access Intermediate Course Revision work
After the course, 1 free session for questions online MS Access Intermediate Course via Gotomeeting.com.
Max group size, online and in classroom, on this MS Access Intermediate Course is 4.