This course includes:

• Introduction to MS Access Database
• Create a table with the different field types
• Importance of good Database Design
• Data Modelling – Primary Keys, Indexes, Relationships
• Select Queries
• Using Boolean logic with Select Queries
• Parameter Queries
• Calculated Query fields
• Access Built In functions e.g Now(), Trim(), Mid()
• Query Properties
• Total Queries
• Top N Queries
• Multiple table queries
• Query Joins
• Cross Tab Queries
• Understanding Forms
• Creating bound Forms
• Creating unbound Forms
• Creating and linking Subforms
• Adding form controls using wizards
• Understanding Reports
• Creating Reports
• Creating Calculations and Summaries in Reports
• Displaying Query parameters in Report Headings
• Creating Mailing Label Reports
• Importing Data from Excel and normalizing it for Access using Action Queries

Contact datasort and we will email you a more detailed course outline and answer any queries you may have. All enquiries are welcome without obligation.