Product Description
Our Microsoft Access On-site Training Courses can be delivered anywhere in the United Kingdom or Ireland and can be customized to suit our clients specific requirements.
Our Introduction to Access course assumes no prior knowledge of the program and gives a thorough grounding in how Access works and the function of each of its key environments.
Introduction to Databases
database concepts, database layout, launching access. , the access menu system, dialog boxes, getting help, creating a new database, closing a database (vs exit access) , opening a database
Tables
Database Design. , Creating Tables Using the Table Wizard, Creating Tables In The Datasheet View, Creating Tables in the Design View, Data Types, Field Properties, Data Display Format Vs Input Mask, The Input Mask , Data Entry Problems, Moving and Copying Records
Working with Tables
Pasting Records, Sorting the Table, Deleting a Table, Table Layout Changes, Find, Replace, Wildcards
Queries
The Simple Query Wizard , The Design View, Modifying the Query, Using Basic Criteria, Additional Criteria, ParameterS, Multiple Object Queries, Custom Calculations in a Query, Calculating Fields continued, Grouping Fields
Introduction to Reports
Reports, The Report Wizard