This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it.
Learn and explore various query techniques from where clauses, to aggregation, joins and more.
This private style tuition helps to maximise the value you get from the day.
Who Should Attend:
People who need to do in-depth data analysis.
Microsoft Access 2010 and later.
Tables
Referential Integrity
Table Relationships
Select Queries, selecting columns and using where clauses
Multiple table queries, joining tables using query design
In null, is not null
Wildcards
Totals
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.
Importing Data
Exporting Data
Linking Data
Linking Data Creating Forms
Creating forms, Form wizards
Creating a Navigation Form
Brief overview of Creating and viewing MS Access reports
Try a 30 minutes webinar free. Choose you own topic from our course list.
