Single courses in Microsoft Access may be taken at universities, community colleges and technical colleges, as well as through private organizations. Courses like these are designed to make using Microsoft Access easier and more accessible, and are therefore practical for people using Access in administrative or secretarial positions. Topics covered in courses about Access will include the following:
- Database templates
- Form commands
- Data importing
- Table creation
- Mail merging
- Running sums
List of Courses
Microsoft Access Essentials
Introductory Microsoft Access classes offer a tour of the software and introduce new users to the features and advantages of Microsoft Access. Students explore the program and learn core skills, such as finding and using database templates, creating tables and modifying forms and reports. Beginning Microsoft Access classes require no previous experience, but students should have basic computer knowledge and familiarity with other Microsoft programs.
In intermediate Microsoft Access classes, such as database development, students learn more advanced skills, such as how to add fields to a table, assign data types and format table views. Tasks such as customizing forms, importing data and grouping data are introduced and students are given the chance to become comfortable with these new skills. Other topics covered in intermediate Microsoft Access classes may include mail merge and switchboard forms. Prior completion of an introductory Microsoft Access class is recommended.
Microsoft Access Advanced Skills
Advanced Microsoft Access classes teach students the more powerful aspects of Microsoft Access, including pivot tables and charts, crosstab queries and macros. Students practice adding form command buttons, adding report sections and applying advanced query wizards. Advanced Microsoft Access classes also teach students to create calculated controls and running sums. A solid grasp of basic Microsoft Access skills is required and introductory and intermediate Microsoft Access classes are recommended prerequisites.