With Access, you can easily create databases in a Windows environment.
You create neat forms to add, delete and update different records.
You can create relationships between tables to filter and find the information you are interested in.
The course is aimed at those who want to work with data in Access.
The course requires no direct prior knowledge, but familiarity with the Office package is preferred.
Introduction
– What is a database?
– Program window
– Navigation window
Tables
– Create a table
– Field properties
– Primary key
– Edit data
– Change table design
– Change datasheet design
– Save database
– Import and export
– Lookup wizard
– Relationships and referential integrity
Questions and Filters
– Create filters
– Create selection questions
– Selection conditions
– Sort records
– Calculations in questions
– Parameter questions
Forms
– Creating forms
– Quick forms
– Forms with subforms
– Linked forms
– Editing forms
Reports
– Create report
– Report design
– Calculations in reports
– Preview
The course comes with version 2016 as standard.
Course Overview
20 450 kr
3 days
Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to find a suitable opportunity.
Customized Courses
The course can be adapted from several perspectives:
In interaction with the course leader, we ensure that the course meets your needs.
Skicka intresseanmälan för utbildningen
Send an expression of interest for the training