Successful candidates for this exam have the equivalent of six months to one year of hands-on experience using Microsoft Office Access 2007 and might have experience using previous versions of Microsoft Access. They are ...Successful candidates for this exam have the equivalent of six months to one year of hands-on experience using Microsoft Office Access 2007 and might have experience using previous versions of Microsoft Access. They are especially effective and efficient at structuring databases, creating and formatting database elements, entering and modifying data, creating and modifying queries, presenting and sharing data, and managing and maintaining the overall database. These candidates are the Office Access 2007 gurus within their organizations.Show MoreCourse Prerequisites:
Computer Literacy Add to CartRequest a Quote
Instructor-Led Training (ILT)
Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.
Course Price (ILT) R996.27
* incl. VAT
Duration 1 Day
Upcoming dates for MOS: Microsoft Office Access 2007
Hang on... we're fetching some dates from the Course Schedule.
Structuring a Database
• Define data needs and types.
• Define and print table relationships.
• Add, set, change, or remove primary keys.
• Split databases.
Creating and Formatting Database Elements
• Create databases.
• Create tables.
• Modify tables.
• Create fields and modify field properties.
• Create forms.
• Create reports.
• Modify the design of reports and forms.
Entering and Modifying Data
• Enter, edit, and delete records.
• Navigate among records.
• Find and replace data.
• Attach documents to and detach from records.
• Import data.
Creating and Modifying Queries
• Create queries.
• Modify queries.
Presenting and Sharing Data
• Sort data.
• Filter data.
• Create and modify charts.
• Export data.
• Save database objects as other file types.
• Print database objects.