Formation MS Office Access - Creating and managing tables in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.
325.-/d
ID : 646
Goal : This training is intended for users needing to create a database structure with MS Access for queries, reports, macros, etc.
Audience : Users needing to create a database with MS access.
Prerequisites : Very good knowledge of MS Windows environment. Users will take the most from this training by following preceeding training "Database Modelisation", in order to get the appropriate knowledge to link tables correctly.
Goals :
Introduction
Refresh about database concept (CDM)
MS Access environment presentation
Leszinsky/Reddick and Camel Taxonomy
Creation of a physical relational database
Importing or link data from MS Excel or Outlook (with SharePoint Portal Server and SQL Server upon request)
Tables creation and fields definition
Field types and properties (data types, format, input template form, index, error management, basic formulas, value if error, etc.)
Basic or combined index creation
Basic or combined, foreign and primary keys creation
Links creation with the Lookup Wizard
Lookup fields options and management
Links creation in Relational View
Use and utility of referential integrity and options
Training Conclusion
Pedagogical method : The training is based on a single practical exercise.
Suggested duration for presentiel training (days) : 2
Suggested duration for on-line training (days) : 2.4
Daily price in face-to-face : 325 CHF
Daily price in remote : 156 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 1625 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).
Tags : access training, MS access, database, table, tables, links, training, primary key, foreign key, one to many, one to one, cross reference, index, multiple index.