Microsoft Access Level 1 (Fundamentals)

This hands-on beginners course is suitable for Access 2010/2013/2016 users.

Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run. 

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.

What's Included

• Certificate of Course Completion
• Hardcopy of Training Manual
• FREE Class Repeat

Course Outline

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

Database Design

• 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

Tables

• 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

Queries

• Creating basic queries
• Select queries
• Action queries
• Adding data sources to a query
• Selecting query fields
• Query criteria
• Adding mutiple 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

Forms

• 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

Reports

• 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

Note:

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

All classes are currently live and online. Trainees have the option to repeat their training in-person (for FREE) after CV-19.