Microsoft Access 2010 for Beginners
Microsoft Office Access is a relational database management system that enables everyday office-based IT users to interface with the complex Microsoft Jet Database Engine. Microsoft Office Access is extremely versatile and has the ability to link directly to data stored in other applications and databases. Microsoft Access is part of the Microsoft Office suite of software applications and has become one of the leading database software applications in the UK. Participants in Adept Training & Consultancy's Microsoft Office training courses will all receive the following training benefits: • Microsoft Certified Training Courseware • Certificate of Attendance • Professional and Qualified Trainers • Small Class Sizes • Excellent IT Infrastructure • Post Course Support • Buffet Lunch After completing this course, students will know how to: • Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature. • Plan and create a database; use Datasheet view and Design view; and create tables and work in tables. • Modify a table's design; use the attachment data type; find and replace data; sort, filter, and delete records. • Set field properties, create input masks, and set validation rules. • Create queries, and sort and filter the results; modify queries; and perform operations in queries. • Create, modify, and work with forms; and use them to sort and filter records. • Create reports by using the Report button, the Report Wizard, Design view, Layout view, and queries; modify and print reports.