Microsoft Access
Design basics
This course is for new and existing users of Access who wish to acquire the basic skills required to design a relational database. Â It includes entering and extracting data using forms, queries and reports.
Objectives
What is a database?
Database terminology
Opening & closing an existing database
Database objects & views
Â
Table Design
Design considerations
Defining field names
Establishing data types
Setting a primary key
Setting field properties
Â
Creating relationships
Creating, editing & deleting table relationships
Understanding referential integrity
Â
Queries
Using the query wizard
Creating & saving queries
Editing & deleting queries
Running a query
Sorting a query
Â
Forms
Using form wizards
Creating a form without a wizard
Saving a form
Forms sections
Adding form controls
Editing control properties
Editing form properties
Â
Reports
Using report wizards
Creating a report without a wizard
Saving a report
Report sections
Adding & modifying report controls
Sorting & grouping report data
Adding statistical fields
Â
No previous knowledge of Access is required however delegates should be able to use a computer.
Prerequisities
Content
© PrimeraTraining 2020
Professionally insured through PolicyBee
We are GDPR compliant. For information on how we handle personal data, and your associated rights, please view our Privacy & Data Protection Notice.