Microsoft Access Training Course
Training Duration
16 Training Hours
Course Overview
Microsoft Access Training enables the participant to use this relational database application to enter, store, and retrieve data for referencing and creating reports. This Microsoft Office Suite application can handle large amount of data. The training delivers the knowledge and skills to input data into forms and tables, retrieve results through queries, and present data in the form of reports. The graphical interface facilitates the user to import or link data stored in different databases and application.
The candidates undergoing the training inculcate the following skills:
- Understand database management concepts
- Explore tables, forms, queries, reports
- Build a database either manually or from templates
- Define table structure and build relationship among tables
- Create and customize easy-to-use data entry forms
- Write queries to extract, filter, manipulate, and delete data from tables either through wizard or manually
- Design basic to advanced reports to summarize data in effective ways
- Restrict data in terms of data, its type, format, and validation rules
- Working with Access tables, relationships, keys and constraints
- Import data from other databases and documents
- Create and design Access database solutions
- Maintain security by assigning password to the database
- Split database and protect it for distribution
Other than Microsoft Access Training Course , there is Microsoft Excel Advance ( MOS Excel Expert ) Training Course and Microsoft Word Training Course are also the most popular courses under the Computer and IT domain.
Target Audience
- The course is intended for the students and professionals who want to build or enhance their skillset in organizing data using Microsoft Access.
Course Contents
Detailed Course TopicsBy going through this training, the candidates will exhibit the following capabilities:
- Working in Access
- Understanding Database Concepts
- Exploring Tables
- Exploring Forms
- Exploring Queries
- Exploring Reports
- Previewing and Printing Access Objects
- Creating Databases from Templates
- Creating Databases and Tables Manually
- Manipulating Table Columns and Rows
- Refining Table Structure
- Creating Relationships Between Tables
- Creating Forms by Using the Form Tool
- Changing the Look of Forms
- Changing the Arrangement of Forms
- Sorting Information in Tables
- Filtering Information in Tables
- Filtering Information by Using Forms
- Locating Information That Matches Multiple Criteria
- Creating Reports by Using a Wizard
- Modifying Report Design
- Previewing and Printing Reports
- Restricting the Type of Data
- Restricting the Amount of Data
- Restricting the Format of Data
- Restricting Data by Using Validation Rules
- Restricting Data to Values in Lists
- Restricting Data to Values in Other Tables
- Modifying Forms Created by Using a Wizard
- Adding Controls
- Adding Subforms
- Using E-Mail Forms to Collect Data
- Creating Queries by Using a Wizard
- Creating Queries Manually
- Using Queries to Summarize Data
- Using Queries to Perform Calculations
- Using Queries to Update Records
- Using Queries to Delete Records
- Creating Reports Manually
- Modifying Report Content
- Adding Subreports
- Importing Information
- Exporting Information
- Copying to and from Other Office Programs
- Creating Navigation Forms
- Creating Custom Categories
- Controlling Which Features Are Available
- Assigning Passwords to Databases
- Splitting Databases
- Securing Databases for Distribution
- Preventing Database Problems
- Changing Default Program Options
- Customizing the Ribbon
- Customizing the Quick Access Toolbar