This hands-on Introduction to Microsoft Access course provides experience with the features & functionality of Access 2010. You will learn to design and develop database applications that enable you to organize and control the data in your work environment. With this Access training, you gain the skills to develop and support robust Access systems, manipulate data, perform queries, develop forms, and design sophisticated data analysis reports for professionally produced presentations. You gain the skills to create and integrate macros into your applications, quickly modify forms and reports with selective filtering, sorting and grouping, and link to SharePoint and SQL Server data systems.
Familiarity with the Windows graphical environment
This course is based on Access 2010 and 2013, but is applicable to earlier versions of Access
Introduction to Microsoft Access Training Delivery Methods
After-course instructor coaching benefit
4thdacad end-of-course exam included
After-course computing sandbox included
Introduction to Microsoft Access Training Course Benefits
Develop and support robust applications to query data, create forms, and design reportsBuild applications with Form, Table, Report, and Query wizardsCreate and integrate macros into your applicationsImplement advanced Access reporting featuresMigrate to a server for multiuser accessibility
Introduction to Access Course Outline
Microsoft Access Overview
Discovering the interface
Quick data functions in reports
Categorizing with command groups
Changing the view to discover contextual tabs
Overview of database concepts
Databases and their contents
Flat file and relational databases
Conforming Access to RDBMS standards
The fundamentals of database design
Tables, records and fields
Implementing database normalization
Ordering schemes
Indexes
Setting composite primary keys
Building a Relational Database with Access
Querying Relational Data
Access Reports for Data Analysis
Task Automation with Macros
Access as a Multiuser Front-End
العربية