Microsoft Access 2010 Training enables the participant to use this relational database application to enter, store, and retrieve data for referencing and creating reports. This Microsoft 2010 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
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.
Prerequisites
While there is no formal prerequisite for this training, however candidates with basic computer knowledge can undergo this training.