Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.
Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility such as time reporting or recording a sale. But virtually everyone is affected in some way by the need to manage data.
- identify the components of the Microsoft Access 2010 environment.
- identify the components of a database.
- organize data in tables.
- view data in tables.
- query a database.
- design forms.
- generate reports.
- streamline data entry and maintain data integrity.
- join tables to retrieve data from unrelated tables.
- create flexible queries to display specified records,
allow for user-determined query criteria, and modify data using queries.
- improve forms.
- customize reports to organize the displayed
information and produce specific print layouts.
- share data between Access and other applications.
- How to get started
- Get knowledge of working with Procedures and Functions
- Understanding Objects
- Learn how to Using Expressions, Vaiables, and Intrinsic Functions
- Controlling Program Execution
- Working with Recordsets
- Debugging Code
- How to handling Errors
Appropriate introductory and advanced courses plus several weeks of practice.
No programming experience is required.
Adv. Access Training Duration
Regular classroom based training: 12 Weeks, 60 minutes of theory & practical session per day.