Events.com apps

Microsoft Access Level 1 (Fundamentals)

Microsoft Access Level 1 (Fundamentals)
Image from coursehorse.com
Event ended

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.
Still have questions?
Ask the community
.

Views - 26/11/2019 Last update
art
Training Connection
915 Wilshire Blvd Ste 1800, Los Angeles, 90017, California, US
Create an event
Create events for free. They will be immediately recommended to interested users.
Nearby hotels and apartments
915 Wilshire Blvd Ste 1800, Los Angeles, 90017, California, US
Discover more events in Los Angeles
Discover now
Discover more events in Los Angeles
Discover now
Training Connection
915 Wilshire Blvd Ste 1800, Los Angeles, 90017, California, US
Create an event
Create events for free. They will be immediately recommended to interested users.
  1. Los Angeles
  2. Microsoft Access Level 1 (Fundamentals)
 
 
 
 
Your changes have been saved.