OnSite Computers - Microsoft Access

Microsoft Access - Level 3

Course Length: 6 hours (9 a.m. - 4:00 p.m.)
Prerequisites: Microsoft Access Level 1 & 2

Course Overview
In the Using Microsoft Office Access Level 3 course, the student will learn how to create more advanced queries, reports, and forms. This course will also cover how to automate database tasks with macros and how to build a user interface for a database application. The student will learn about database security and maintenance features as well as how to build a data access web page.

Queries Create and run a crosstab query Create and run action queries Base a query on another query Create a subquery Create expressions in queries Create a top values query	Reports Create a column-formatted report Create a subreport within a report Create and insert a chart on a report
Forms Create a multi-page form with tabs Create and edit a pivot form Create a dialog box with an option group and command buttons	Macros Create a conditional macro Attach a macro to a form control
Build a User Interface Create a switchboard form with buttons Create custom menus and toolbars Set startup options	Data Access Pages Create and modify a data access page Apply a theme to a data access page
Database Security	Database Maintenance Compact and repair a database Convert a database to another version

Back to Class Schedule

	1012C Wilson Point Road Middle River, Md. 21220 410-574-2234	Your only phone call for all of your computer needs!

Home		Computer News

YES! We Can Fix It!	We Cater to Computer Cowards! Let us clean your windows and empty your trash	No Need to Fear! OnSite is Here!