Microsoft Access Basic & Intermediate

Duration

2 days

Lesson 1: Database Essentials

• Start Access in Windows 10
• Open an Existing Database
• Use the Navigation Pane
• Use Object Tabs
• Change Views
• Use the Ribbon
• Use the Backstage View
• Review Database Fields
• Review and Modify Data Types for Fields
• Define Database Tables (Relational Database)

Lesson 2: Creating Database Tables

• Use a Template to Create a Database
• Create a Blank Database
• Create a Table Using the Application Parts Gallery and Quick Start
• Create a Table from Another Table
• Save a Table

Lesson 3: Working with Tables and Database Records

• Use the Keyboard to Navigate among Records
• Use Navigation Buttons
• Enter, Edit, and Delete Records
• Define a Primary Key
• Define and Modify a Multifield Primary Key
• Find and Replace Data
• Attach and Detach Documents
• Sort Data within a Table
• Filtering Data within a Table
• 10.Remove a Filter
• 11.Freeze/Unfreeze and Hide/Unhide Fields
• 12.Define Table Relationships
• 13.Modify Table Relationships
• 14.Print Table Relationships

Lesson 4: Modifying Tables and Fields

• Modify Table Properties
• Rename a Table
• Delete a Table
• Set a Field Property in Datasheet View and Design View
• Define Input Masks for Fields
• Allow Zero Length
• Set Data Validation Rules
• Enter Captions
• Create Fields
• Delete a Field
• Create a Multivalued Lookup Field

Lesson 5: Creating Forms

• Create a Simple Form and Delete a Form
• Create a Form in Design View
• Create a Form in Layout View
• Use the Form Wizard
• Apply a Theme
• Sort Data within a Form
• Filter Data with Common Filters
• Use Filter by Form

Lesson 6: Creating Reports

• Create and Delete a Report
• Use the Report Wizard
• Create a Report in Design View
• Apply a Theme
• Group and Sort Data within a Report
• Filter Data within a Report
• Find Data within a Report

Lesson 7: Creating and Modifying Queries

• Create a Simple Query
• Create a Find Duplicates Query
• Create a Query from Multiple Tables
• Find Unmatched Records
• Add a Table to a Query
• Add Criteria to a Query
• Sort Data within a Query
• Filter Data within a Query

Lesson 8: Using Controls in Reports and Forms

• Add Unbound Controls
• Add a Bound Control to a Report
• Add a Calculated Control
• Use the Control Wizard
• Use the Control Wizard to Add Button Controls
• Define Control Tab Order
• Format Controls on a Report
• Format Controls on a Form
• Create Conditional Formatting
• Arrange Control Layout
• Add, Move, and Remove a Control from a Layout
• Arrange and Anchor Controls within a Layout
• Arrange Control Alignment, Size, and Position
• Adjust Page Margins and Change Page Orientation for Forms and Reports

Lesson 9: Advanced Tables

• Create a Custom Table in Design View
• Insert and Delete Rows in Design View
• Use the Table Analyzer
• Insert a Total Row

Lesson 10: Advanced Forms

• Create a Multi-Item Form
• Create a Split Form
• Create a Subform
• Use Application Parts to Create Blank Forms
• Create a Navigation Form

Lesson 11: Advanced Reports

• Use the Report Wizard
• Use the Group, Sort, and Total Pane
• Change Grouping Options
• Create Aggregate Fields
• Create a Subform on a Report
• Create the Print Layout
• Use the Label Wizard

Programme scope, delivery arrangements and suitability are confirmed during enquiry.