Introduction to Microsoft Access Training IMAT001
- Course Code : IMAT001
- Duration : 4 Day
- Price : 2,472 GBP
- Level: Foundation
- Language: English
Course Content
This hands-on course provides experience with the features and 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. The course covers developing and supporting robust Access systems, manipulating data, performing queries, developing forms, and designing sophisticated data analysis reports. You’ll also gain skills to create and integrate macros, modify forms and reports, and link to SharePoint and SQL Server data systems.
Delivery Method
After-course instructor coaching benefit.
Learning Tree end-of-course exam included.
After-course computing sandbox included.
Have questions about this course?
Goals
In this SharePoint course, you will learn to:
Develop and support robust applications to query data, create forms, and design reports.
Build applications with Form, Table, Report, and Query wizards.
Create and integrate macros into your applications.
Implement advanced Access reporting features.
Migrate to a server for multiuser accessibility.
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
Defining the requirements
Eliciting user needs and wants
Consolidating a design into a system specification
Designing the data model
Creating an Access database system
Selecting the best Access design style
Access tables, fields, indexes
Assigning proper field types
Table relationships
Modifying field functionality with properties
Customizing Forms with the Layout View
Embedding forms
Importing existing tables
Protecting data using layered validation
Picking controls in Layout and Design Views
Querying Relational Data
Query types and elements
Defining queries
Choosing fields in the Design View
Select, Action, and Parameter queries
Developing queries
Query wizards
Expressions in queries
Refining data output with sorting and filtering
Creating calculated fields
Access Reports for Data Analysis
Implementing Report wizards
Generating quick reports
Enhancing presentation with conditional formatting
Exploiting formulas and expressions in reports
Sorting out groups and totals
Modifying standard report formats
Adjusting report controls
Changing group order and effects
Formulating values in expressions
Publishing to PDF and XPS formats
ask Automation with Macros
Designing effective macros
Point-and-click
Embedded macros
Macro style guidelines
Running a macro from events
Picking macro actions and arguments
Event-driven programming
Linking forms and reports
Associating macros with controls
Managing security through the Trust Center
Designing a custom Navigation Pane
Access as a Multiuser Front-End
Data separation in Access
Creating a non-data ACCDB
Strategically placing your data
Handling multiuser conflicts
Linking to external data sources
The ODBC connectivity standard
Utilizing SQL Server data within Access
Publishing to the cloud
