Microsoft Access - Queries

Hours: 8 / Access Length: 3 Weeks / Delivery: Monthly, Mentor Supported
Retail Price: $210.00

Course Overview:

Master the art of queries! Students will create Queries of their data using the Query Wizard and by hand. Students will create queries to update data, delete data and view data. Students will create queries that will combine data from multiple tables. Students will need a copy of Access. A 30-day trial is available.

Course Outline:

• Students will design a query using the Query by Example form.
• Students will create queries that combine data from multiple tables.
• Students will create queries that update the data in a table, create a new table, append data to a table and delete data from a table.
• Students will create cross-tab queries and parameter queries.

All necessary materials are included.

System Requirements:

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is denoted in the above course outline.