Microsoft Access Introduction

Course Content

• Databases Explained
• What Is A Relational Database
• Components of Access Databases
• Getting Help
• Structuring & Designing A Database
• Creating Tables & Setting Data Types
• Setting Field Properties in Tables
• Primary & Foreign Keys
• Data Entry & AutoCorrect
• Modifying a Table Design
• Setting Up Relationships
• Using the Lookup Wizard
• Formatting Data in Tables
• Searching, Sorting & Filtering Data
• Creating & Using Select Queries
• Using Criteria in Queries
• Summarising Data with Queries
• Designing Data Entry Forms
• Using AutoForms & the Form Wizard
• Creating & Using Main Forms & Sub Forms
• The Form Design Work Surface & Toolbox Toolbar
• Modifying Forms
• Using AutoReports & the Report Wizard
• Modifying Report Design
• Generating Mailing Labels
• Printing in Access