Course outlines may be downloaded for many of the courses.

If you would like additional outlines please do not hesitate to contact us.

Access Intro Our 2 day Introduction to MS Access course is suitable for complete beginners to Microsoft Access. Prerequisites A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Access is required. Benefits At the end of this course you will have a good working knowledge of MS Access. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports. After completing this course you will be prepared to attend the Advanced MS Access training course.   Course Content Views Available Within Access Table     Query    Report Form Switch Between Design View and Datasheet View/ Form View/ Preview/ Run Create New Database File Why Create a File First Object Naming Rules Database Tables – Create Field Names Data Types - corresponding field properties and how they differ according to the data type selected Primary Key Fields Format Caption Required Input Mask Validation rule Indexing Create lookups to standardise data entry Database Tables – Manipulate Records Sort Records Delete Records & Fields Use Find & Find And Replace Rename Fields Use The Filter/ Sort Facility  (By Selection, By Form, Advanced Filter/ Sort) Define Relationships Establish Relationships (One-Many, One-One) Enforce Referential Integrity Cascade Update/ Delete Related Fields Forms Why To Use The Form To Input Data Create With And Without The Wizard Form Types -  MultiTable, Columnar, Justified, SubForms Move Labels And Fields Around The Form (Together And As Individual Items) Align Objects, Snap To Grid Adjust “Fineness” Of Grid Adjust The Form Size Select And Move/ Resize Multiple Objects Set Background Fill, Text Colour Sections Of A Form Toolbox (Combo Box, Command Buttons, Drawing Tools, Pointer) Introduce Command Buttons Queries Select Parameter CrossTab Summary Incorporate Calculated Fields Reports Create Reports Using The Wizard Display Specific Records Sort Records By Specified Fields Apply Page Header/Footer Specify Layout Of The Report Specify Grouping Levels Calculated Fields Create Parameter Report Create User Interface How To Create A Database That Will Allow Non-Access Users To Enter/ View Data & Run Reports Create Splash Screen Use Of The Autoexec Macro & StartUp Command mullantechnology.com specialise in customised systems that support our clients’ business requirements and objectives – creating both desktop & web based database applications. We know that the best way to provide a database is to create a database solution around the way you work. The result is a user friendly system streamlined to fit your particular business processes, to a degree that an off-the-shelf product could never match. Click here to visit our mullantechnology.com website and view sample databases & details of the technology we can offer to meet your requirements Access_Intro