Who Should Attend:
- IT Professionals who provide tech support
- Business Users with database requirements
Course Objectives
- An overview of the features available in Microsoft Access 2010®
- Learn how to use an Access 2010® database
- Learn how to create databases and simple tables
- Learn how to build data-entry forms
- Learn how to display data and produce reports.
What will you gain?
By the end of this course you will be able to:
- Gain proficiency in the basic features of Microsoft Access and use it effectively to organise information
- Manage your data by creating simple databases and relational databases
- Construct simple and complex tables
- Create queries to filter and sort data, and join data from different tables
- Design and format the look and appearance of forms
- Get the know-how to create and present reports based on the data entered
- Acquaint yourself with the various printing options available in Access and use them to print different objects.
Course Content
- Work in Access 2010
- Understand database concepts
- Explore tables
- Explore forms
- Explore queries
- Explore reports
- Preview and print Access objects
- Create databases from templates
- Create databases and tables manually
- Manipulate table columns and rows
- Refine table structure
- Create relationships between tables
- Create forms by using the Form tool
- Change the look of forms
- Change the arrangement of forms
- Sort information in tables
- Filter information in tables
- Filter information by using forms
- Locate information that matches multiple criteria.
0.0
0 total
5
4
3
2
1