Convenient one, two or three day onsite or online courses.
Flexible scheduling to suit your timing requirements.
Choose the topics you need to get your job done.
Microsoft Access – Introductory
Topic 1: Overview of Microsoft Access 2013, 2010 & 2007
• Database Concepts, terms & conventions
• Basics concept & objects in Access 2013, 2010, 2007
• Initial Access database planning and design
Topic 2: Microsoft Access tables – the basic building blocks
• A typical Access table (records & fields)
• Creating a table with the wizard
• Creating a table in design view
• Adding the Access Primary key (this is used to keep unique records)
Topic 3: Working with Microsoft Access tables
• Modifying table fields in Design view
• Searching for records
• Applying filters & sorts to records
Topic 4: Creating Select Queries to extract select information
• Adding an Access Select Query for specific fields
• Adding criteria to a Select Query see only some records
• Expression (formulas in queries) to add calculations
• Having multiple tables in a query
• Select, Make Table, Append, Delete & Crosstab Queries
Topic 5: Creating Forms for easy data entry
• Creating a new form using the Form Wizard
• Using the form to modify data
• Switch to the Form Design view
• Using a form to locate information
• Creating Multiple-Table Forms
Topic 6: Creating Access Reports for Data Output
• Creating reports with the Report Wizard
• Adding calculations (SUM, COUNT etc.) to reports
• Editing the report header & footer
Topic 7: Maintaining, Repairing & Compacting a Database
• Creating an Access database from a template
• Managing a database and its objects
• Database maintenance options
Microsoft Access – Advanced
Topic1: Principles of Database Table Design
• Why Normalize Data
• Normalizing Data for First, Second and Third Normal Forms
Topic 2: Table Relationships in a Relational Database
• Creating Table relationships (one to many, one to one etc)
• Primary keys and foreign keys
• Using the Access Tools to see table relationships
• Referential Integrity with table relationships
Topic 3: Access Table Design Techniques
• Formatting fields
• Applying Data Validation
• Adding an Index
• Input masks & default values
Topic 4: Advanced Select Queries
• Calculated Fields in Access Queries
• Creating Multiple-Table Queries
• Creating Parameter queries
Topic 5: Form Design Customization
• Customizing the form layout (to enhance usage)
• Adding Calculations to a form
• Adding Combo Boxes for form navigation
• Adding labels etc.
Topic 6: Exporting Access Data to Excel, PDFs etc
• Export data to Excel and using Pivot tables
• Import data from Excel
Topic 7: Customizing Advanced Reports
• Customizing a Report Created by the Report Wizard
• Summary Options in reports
• Creating grouping in Access reports