Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.
Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.
This intensive course is designed to give delegates an understanding of some of the major features and functions within Microsoft Access.
database terminology • relational databases • opening an existing database file • creating a new database file • the database window
the table window • adding/deleting a record • searching for specific records • copying information • editing data in a field • sorting records • resizing and moving columns and rows • freezing and hiding columns
Creating a Database Table
creating a table • the Primary key • data types for fields in a table • adding a field to an existing table • input masks • data validation • field properties
Setting Relationships between Tables
types of relationships • creating the relationships • enforcing referential integrity
creating a form with the wizard • entering/editing information • adding/removing controls • changing a controls appearance • editing the form layout • creating a combo box
creating a single/multiple table query • adding criteria to select records
creating a Report with the wizard • previewing and printing a report • creating a grouped and totals report • changing the appearance of a report
Delegates must be experienced with using a mouse and working in the Windows environment.
Private course · tailored · 1 to 1 (all instructor led)
A comprehensive course manual provides support throughout the course and upon your return to the office.
Not found the course you are looking for?