MICROSOFT ACCESS

Course: MicroSoft Access

(3 days)

Prerequisites: None.

Course Content

Getting to know Access means getting to know database objects; tables, forms, queries, and reports. You'll learn about:

• Tables the building blocks of databases, and you'll want to understand them early and thoroughly.
• Forms make data entry easier and more reliable
• Reports let you show off your data, on screen or on paper
• Plus Queries
• Understand Relational Databases and more…

Course Outline

• Overview of Access
• Creating Tables
• Working with Tables
• Using Select Queries
• Creating and Using Forms
• Creating and Using Reports
• Creating and Maintaining a Database
• Principles of Table Design
• Principles of Table Relationships
• Table Design Techniques
• Designing Select Queries
• Customizing Form Designs
• Working with Data Access Pages
• Customizing Reports
• Structuring Existing Data
• Writing Advanced Queries
• Simplifying Tasks with Macros
• Adding Interaction and Automation with Macros
• Making Forms More Effective
• Making Reports More Effective
• Maintaining an Access Database
• Making Your Data Available on the Web
• Developing a Data Access page in Design View
• Integrating Access into Your Business
• Automating a Business Process with VBA
• Creating a Switchboard and Setting the Startup Options
• Distributing and Securing the Database