Access Quickstart course
– Databases
Build tables, queries, work forms, reports and macros for automation.
The Challenge
MS Office programs are very widespread, and nowadays it is important to know how to use them.
The MS Access QuickStart course is centred on rapidly transferring knowledge with practical application. This way you will learn the necessary concepts to get your desired results.
In addition, you will see alternative methods to achieve the same results and will be presented with best practices, leaving it up to you which method you choose.
Who should attend?
The following profiles will benefit from this course:
- Employees
- Analysts
- Data Entry Operators
- Data Processing Operators
- Accountants and financial officers
- Reporting managers
- Managers, project managers
What do participants get?
By the end of this course, you will:
- Use the Fluent interface with ease;
- Understand the concept of referential integrity and its application;
- Create a database, enter and manipulate data;
- Master usage scenarios for MS Access functionalities;
- Realize queries and reports;
- Increase execution speed for standard tasks;
- Be able to increase productivity in the workplace.
Trainers
Cristian Stirbescu
Microsoft Certified Senior Trainer
Microsoft certified trainer since 2012. Frequently recognized as one of the best trainers in the industry. Interacts openly with learners through a fresh approach to course delivery.
Access Quickstart course agenda
The topics are delivered in an interactive format, with frequently used scenarios covering the following areas:
Chapter 1 – Introduction to Access
- Introduction to databases
- Database Window interface
- Access Features
- Database objects
- Entering and displaying data
- Securing content
Chapter 2 – Creating a Database
- Data Types
- Choosing the Data Type
- Creating a database based on a template
- Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
- Setting properties for fields in Design View
- Setting the primary key
- Constraint types, field level and record level; referential integrity, update cascades and delete cascades
- Entering values in a table
- Formatting in the data sheet
- Defining relationships between tables
- Visualizing records in related tables
Chapter 3 – Querying Data
- Searching for information in a table
- Filtering data
- Types of queries
- Making selection queries
- Using the Wizard to create queries
- Simple Query Wizard
- Crosstab Query Wizard
- Find Unmatched Query Wizard
- Find Duplicates Query Wizard
- Creating a Query by your own forces
- Using Filter Criteria
- Establishing links in a query
- Data selection and modification techniques
- Select Query
- Inner Joins
- Outer Joins
- Left Joins
Chapter 4 – Creating Forms
- How a form works
- Creating a form using Form Wizard
- Creating a shape without using Form Wizard
Chapter 5 – Creating reports
- Introduction – what is a report
- Creating a report
- Creating a report using the Wizard
- Creating a report without the Report Wizard
Chapter 6 – Optimizing your work
- Indexes
- Exporting Data
- Import Data
Registration
We offer price options for individual participation and for groups.
For groups of more than 10 participants variable discount is included for courses dedicated to your organization.
PrIce per participant
1-9 participants
For individual participation or groups of up to 9 participants
price per group
10-15 participants
Fixed price for groups of 10 to 15 participants
*All prices are VAT Exclusive
Customized training
Dedicated sessions
Dedicated sessions are available for a minimum of 8 participants.
Looking for something different?
Is this option not quite what you’re seeking? Give us a sign and we’ll help with a personalised solution.
Registration
Do you have a group of at least 8 colleagues interested in this topic and would you like to organize a dedicated session for your company?
Let’s get in touch!
Send us an email at training@axioma-solutions.co.uk
Are you looking for something different?
If you are considering an Excel course for beginners, take a look here at the Excel QuickStart course.If this isn’t exactly what you’re after, let us know, and we’ll develop a tailored solution for you. Access our contact information here.
Copyright Information
MS Access is a registered trademark of Microsoft Corporation