Database management in Microsoft Access

The course is designed for beginners who want to learn the most important database management skills, concepts, database design and basic use of Microsoft Access database management software.

The course is available for all software versions (2010, 2013, 2016, 2019, O365)

Basic relational database management skills

• data, information, redundancy traffic
• Why are databases necessary?
• the concept of a database
• concept and types of relationships
• concept of tables, records, fields, keys
• types of data types, data conversions
• steps in database design
• data normalisation, normal forms

Microsoft Access management

• Starting MS Access, navigation window management
• Microsoft Office Fluent user interface
• Collecting data

Data tables

• creating and managing data tables
• Field definitions and types
• new data types (use of multi-value fields, attachment field for files)
• general and display properties of fields
• creating a calculated field
• use of data macros
• improved data sheet view (object clusters, minidata)
• index concepts, creation, management
• concepts and types of keys, key creation
• table properties
• adding, modifying, deleting records
• table filters

Basics of creating multi-table databases

• creating relationships between tables
• relationship types
• using link tables

Basics of queries

• query types (simple, cross-table, parametric)
• data sorting
• defining conditions
• creating fields to perform calculations
• using basic functions
• query properties

Table management queries

• table builder query
• delete query
• update query

Create simple Access reports

• Using the report wizard
• Modify reports created with the wizard
• Using layout view

The Computer Management and Windows course. Previous MS Excel knowledge and experience recommended.