Microsoft Access and Database
Classes
Databases are used to store, link, manage
and manipulate information. With Microsoft Access, now anyone can create
simple or complex databases to manage and analyze data, such as customer
lists, inventory, sales, mailing lists and much more.
| Microsoft
Access: Introduction to Databases |
| Description: For first time users or beginners, this course teaches the basics of creating a database using Access. Databases are used to manage complex lists of information that are inter-related. Topics include: overview and examples of databases; core Access and Office skills (screen overview and navigation, undo, Help, menus, toolbars); Access overview and screens; creating and editing tables; entering and modifying data; queries; table design; forms; reports; printing. |
Learn things like: Creating a database to store customer or inventory lists; creating forms to allow easy data entry and minimize errors; analyzing and reporting on data. |
| Prerequisites: “Introduction to Computers” or equivalent skill level |
| Microsoft
Access: Intermediate Databases |
| Description: For users that have mastered Access basics, this course teaches more advanced database skills. Topics include: advanced table design; advanced queries; customizing reports and forms; introduction to macros; database maintenance. |
Learn things like: Customizing data entry forms and reports for your needs; automating tasks; creating custom analysis of your data. |
| Prerequisites: “Microsoft Access: Introduction” or equivalent skill level |
| Microsoft
Access: Advanced Databases |
| Description: For experienced Access users, this course teaches the most advanced database building skills. Topics include: advanced relationships and hyperlinks; query joins and expressions; crosstab queries; advanced forms and reports; advanced macros; switchboards; data validation. |
Learn things like: Create relationships between your data tables for more advanced capabilities; creating a menu to allow users to easily navigate a database. |
| Prerequisites: “Microsoft Access: Intermediate” or equivalent skill level |
Practical
Computer Training
516.808.1778
