Microcomputer Applications Technician Certification

---

Why Choose Us

Employment Objective

Program Description

A program that generally prepares individuals to perform basic data and text entry using standard and customized software products. Includes instruction in keyboarding skills, personal computer and work station operation, reading draft texts and raw data forms, audio and tape dictation, and various interactive software programs used for tasks such as word processing, spreadsheets, databases, and others.

Income Expectation

$82,475/yr

The average salary for a CISCO Certified Employee is $82,475 in New York City. Salary estimates are provided by Microsoft.

Microcomputer Applications Technician Program Objective

• Create and manage a database
• Build Tables
• Create Queries
• Create Forms
• Create Reports
• Manage the Outlook environment for productivity
• Manage messages
• Manage schedules
• Manage contacts and groups

Microcomputer Applications Technician Program Outline

Create and manage a database

Create and modify databases

• Create a blank desktop database, create a database from a template, create a database by using Import objects or data from other sources, delete database objects

Manage relationships and keys

• Create and modify relationships, set the primary key, enforce referential integrity, set foreign keys, view relationships

Navigate through a database

• Navigate specific records, create and modify a navigation form, set a form as the startup option, display objects in the Navigation Pane, change views of objects

Protect and maintain databases

• Compact a database, repair a database, back up a database, split a database, encrypt a database with a password, recover data from backup

Print and export data

• Print reports, print records, save a database as a template, export objects to alternative formats

Build Tables

Create tables

• Create a table, import data into tables, create linked tables from external sources, import tables from other databases, create a table from a template with application parts

Manage tables

• Hide fields in tables, add total rows, add table descriptions, rename tables

Manage records in tables

• Update records, add records, delete records, append records from external data, find and replace data, sort records, filter records

Create and modify fields

• Add fields to tables, add validation rules to fields, change field captions, change field sizes, change field data types, configure fields to auto-increment, set default values, using input masks, delete fields

Create Queries

Create a query

• Run a query, create a crosstab query, create a parameter query, create an action query, create a multi-table query, save a query

Modify a query

• Rename a query, add fields, remove fields, hide fields, sort data within queries, format fields within queries

Create calculated fields and grouping within queries

• Add calculated fields, set filtering criteria, group and summarize data, group data by using comparison operators, group data by using arithmetic and logical operators

Create Forms

Create a form

• Create a form, create a form from a template with application parts, save a form

Configure form controls

• Move form controls, add form controls, modify data sources, remove form controls, set form control properties, manage labels, add sub-forms

Format a form

• Modify tab order, configure Print settings, sort records by form field, apply a theme, control form positioning, insert backgrounds, insert headers and footers, insert images

Create Reports

Create a report

• Create a report based on the query or table, create a report in Design view, create a report by using a wizard

Configure report controls

• Group and sort fields, modify data sources, add report controls, add and modify labels

Format a report

• Format a report into multiple columns, add calculated fields, control report positioning, format report elements, change report orientation, insert header and footer information, insert images, apply a theme

Manage the Outlook environment for productivity

Customize settings

• Customize reply messages, change text formats for all outgoing messages, customize the Navigation Pane, configure reviews, manage multiple accounts, add an account

Print and save information

• Print message, calendar, contact, or task information; save message attachments; preview attachments; save messages in alternate formats; export messages to a data file

Perform search operations in Outlook

• Create new search folders; search for items in messages, tasks, contacts, or calendars; search by using advanced find; search by folder

Manage messages

Configure mail settings

• Set fonts for new messages and responses; create, assign, and modify signatures; create and manage rules; create automatic replies; create messages by using Quick Parts; configure Junk Email and Clutter settings

Create messages

• Create a message; add or remove message attachments; add cc and bcc to messages; add tracking and voting options; forward and reply to messages; request a delivery or read receipt; redirect replies; flag outgoing messages for follow up, importance, and sensitivity; recall a message

Format a message

• Format text, insert hyperlinks, apply themes and styles, insert messages, add a signature to specific messages

Organize and manage messages

• Sort messages, move messages between folders, add new local folders, apply categories, clean up messages, mark a message as read or unread, flag received messages, ignore messages, sort messages by conversation, delete messages, automate repetitive tasks by using Quick Steps, configure basic Auto Archive settings, delegate access

Manage schedules

Create and manage calendars

• Create and add calendars, adjust viewing details for calendars, modify calendar time zones, delete calendars, set calendar work times, manage multiple calendars, manage calendar groups, display multiple calendars, share calendars

Create appointments, meetings, and events

• Create calendar items, create recurring calendar items, cancel calendar items, create calendar items from messages, set calendar item times, set up meetings by using the scheduling assistant, set free or busy status for calendar items, schedule resources, set up meeting location by using Room Finder

Organize and manage appointments, meetings, and events

• Set calendar item importance, forward calendar items, configure reminders, add participants, respond to invitations, update individual or recurring calendar items, share meeting notes, categorize calendar items

Create and manage notes and tasks

• Create and manage tasks, create and organize notes

Manage contacts and groups

Create and manage contacts

• Create a new contact, delete contacts, import contacts from external sources, edit contact information, attach an image to a contact, add tags to contacts, share contacts, create and manage address books

Create and manage contact groups

• Create new contact groups, add contacts to existing contact groups, add notes to a contact group, update contacts within contact groups, delete contact groups, delete contact group members

Certification Exam

Microsoft Exam 77-730 Access 2016: Core Database Management, Manipulation, and Query Skills

Microsoft Exam 77-731 Outlook 2016: Core Communication, Collaboration and Email Skills

SCHEDULE DATES - 75 Hour Program