Microsoft Access Fundamentals

This class is suitable for trainees new to Microsoft Access. After this class you will have a very good working knowledge of Microsoft Access, including how to design and build an efficient relational database, construct data fields and tables, run queries, design forms and build reports.

• Training is hands-on and all classes are taught by experienced database developers.
• Suitable for Access 2016, 2019 & 365 users.

Database Fundamentals

• Understanding general database terms
• Database management systems
• Table Overview
• Data types
• Table metadata
• Queries and SQL
• SQL Statements
• Relational databases
• Flat file databases
• NoSQL databases
• Advantages of relational databases
• Access interface and objects
• New databases
• Existing databases
• The navigation Pane
• Access objects: Tables, Queries, Forms and Reports

• Fundamentals of efficient design
• Modeling
• The logical model
• The physical model
• Normal forms
• Creating and Modifying databases
• Choosing data types: Numeric, String, Other
• Constraints
• Changing table structure
• Changing data types
• Adding and deleting fields
• Relationships and Keys

• Creating a simple table
• Creating tables in Design View
• Creating fields
• Creating fields in Datasheet view
• Creating fields in Table Design view
• Setting a Primary Field
• Data Validation using Field Properties
• Setting validation rules
• Setting table-level validation
• Relationships and keys
• The importance of primary keys and indexes
• Deciding whether you need unique indexes
• Creating relationships

• Creating basic queries
• Select queries
• Action queries
• Adding data sources to a query
• Selecting query fields
• Query criteria
• Adding multiple criteria conditions
• Parameter queries
• Total queries
• Cross tab queries
• Append queries
• Update queries
• Delete queries
• Modifying queries
• Sorting query results
• Query field formatting
• Using calculated fields
• Creating calculated Yes/No fields
• Calculated text fields

• Creating simple forms
• Basic form design options
• Bound and unbound form controls
• Using the Form Wizard
• Form Design
• Displaying form properties
• Form sections
• Form controls
• Adding bound controls to a form
• Adding controls form the field list
• Types of controls
• Test box and label controls
• List controls
• Adding a command button
• Changing the layout of controls

• Creating Reports
• Report basics
• Setting up data sources
• Filtering and ordering reports
• Automatic report generators
• Using the Report Wizard
• Report Controls
• Calculated fields
• Grouping and summarizing
• Formatting Reports
• Report Page Setup options
• Images and other objects
• Themes