Your training in and use of Microsoft® Office /Access 2007 has provided you with a solid foundation in the basic skills for working in Microsoft® Office Access 2007. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database
- Modify the design and field properties of a table to streamline data entry and maintain data integrity.
- Enhance the capabilities of a form.
- Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
- Customize reports to organize the displayed information and produce specific print layouts.
- Share data across different applications
- Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
- Write advanced queries to analyze and summarize data.
- Create and revise Access macros.
- Maintain your database using tools provided by Access
- Controlling Data Entry
- Joining Tables
- Creating Flexible Queries
- Improving Forms
- Customizing Reports
- Sharing Data Across Applications
- Structuring Existing Data
- Writing Advanced Queries
- Simplifying Tasks with Macros
- Making Effective Use of Forms
- Making Reports More Effective
- Maintaining an /Access Database
Who can benefit
- Personnel responsible for maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications.
- Lectures, tutorial exercises, animations using computer based learning programs.
- To ensure the successful completion of Microsoft Office Access 2007: the completion of the Basic Access
We_They is the largest single-source business and telecom training solutions provider in the Middle East. For 30 years we have been providing training consultancy and human capital development services to telecoms, government agencies, oil & gas companies, financial institutions and organizations across all industries and business sectors.
We provide training and development programs ranging from cutting-edge technology courses in 3G, WiMAX, VoIP or IPTV, to career-changing leadership masterclasses, strategy workshops and business management seminars.
Based in the UAE and operating a 1.2 Million square feet training facility in Dubai, our partner network spans two continents and delivers world class training solutions to customers in over 28 countries in GCC and MENA regions.
We help organisations to:
- Develop effective leaders, managers and team members
- Discover and overcome competency gaps
- Measure and improve performance
- Build teams and improve communication
- Recruit and retain talent
- Build a knowledge culture
- Create an organisation-wide competency framework
- Stay competitive by using cutting-edge technology