#1 2020-09-13 22:29:34

GarryOMear
Member
From: Italy, Montecchio Precalcino
Registered: 2020-09-12
Posts: 4

Designing SQL Server Tables for Access

|.
Microsoft Access Onsite  Training Course s   2019-08-26T15:05:07-05:00          Microsoft Access On-site Training Courses.

We’re now offering Microsoft Access On-site Training for Introductory

Intermediate, and Advanced levels.
As experts in the field, we’ve had a demand for this service and have done some trial runs with a handful of  companies .
Privacy.

What is Microsoft Access and why
Microsoft Access is a database tool to manage

store, retrieve, analyze and report information.
It can streamline businesses processes and help you do more with  your business  with the same amount of employees.

Microsoft Access training from IT Impact

Inc.
puts you in the driver’s seat to take control and discover  the power  of your data.
The course will help you manage  your data base as efficiently as possible.
What does each course include.
What better way to know the ins and outs of your  Access database  than to learn from the pros.
Juan Soto.

A recognized Microsoft Access MVP and President of IT Impact

is available for on-site Access training at your company for any number for employees and users.
Each course level runs for three days and includes techniques for optimization with  SQL Server .

Sample MS Access On-site Training Syllabus
Here you can see our sample syllabus for on-site MS Access Training: Introductory

Intermediate & Advanced courses.
Depending on your needs and user level, we can adjust and customize each syllabus to fit your company’s needs and leverage MS Access to your best  advantage .
Introductory Class.
Design tips for  SQL Server  tables  What is the ONE field type every table should have?.
Where NOT to add a new field in a table.
Linking to  SQL Server  Databases using DSNs  How to create DSNs.
How to refresh DSN links after changes to a table in SQL Server.
Tips and tricks to filtering data in the data grid.
(Hint: Use the force, I mean the right-click).

Creating native tables in Access

do’s and don’ts.
Creating Forms using the wizard  Adding objects to your forms using wizards: List boxes, combos and command buttons.
Adding subforms.
Reports  Creating reports using the wizard.
Adding groups.
Adding subtotals.
Adding Filters.
Adding subreports.
Queries  Know the answer before asking the question.
Using the query wizard.
Creating left, right and outer joins.
Creating group by queries.
Creating calculated columns.

Importing data into Access  Excel imports

CSV imports.
Cleaning data using queries.
Adding data from imports into other tables (Insert Queries).
Creating import specifications and saving them.
Linking vs.
importing Excel data.
Intermediate Class.
Designing SQL Server Tables for Access.
Adding indexes to tables.
Creating views in SQL Server  Do’s and don’ts for using views in Access  You can’t edit data using views in Access, or can you?.
To delete or not delete?.
Forms  Adding controls and programming command objects.
Launching forms with where clauses.
Advanced combos and list controls.
Reports  Launching reports with where clauses.
Sub reports.
Queries  Creating a house of cards (using multiple queries together).
SQL mode vs.
QBE or in other words, doing it the hard vs.
easy way.
Why we don’t bother with hybrid queries, unless you need a coffee break.
Importing data from Excel.
Creating a program to clean imported data.
Exporting to other formats.
Querying SQL Server data from Excel (yes, no need for Access).
Advanced Class.
TSQL Primer.
Query Optimisation.
Creating SQL Server procedures – use table variables or temp tables, that is the question.

Invoking SQL Server Procedures using Access pass through queries

Changing Access queries SQL on the fly with code.

Server Processing vs Doing it in Access

Form object model  Controls Collection.
Iterating through controls.
TableDefs Collection.
Form recordsets  Using the bookmark property.
Using queries in your code with recordsets – the easy way.
TempVars.
Proper coding conventions.
Functions vs Subroutines  ByVal or ref?.

Creating a menu system in Access

Invoking forms from other forms  Reading data from one form to another.
Advanced Importing Techniques.
Excel Querying.
Total Costs: $5,640 + expenses                                                                                                                                                                                                                                                   Powered by  • We are a Microsoft Access Development Company with Headquarters in Chicago, Illinois, USA.
We have clients in Miami and Orlando - Florida, Dallas - Texas, Puerto Rico, New York.
Large client base in Houston - Texas, San Francisco and Los Angeles - California, Washington, Denver - Colorado.
FREE CONSULT.
Privacy.

Offline

Board footer

Powered by FluxBB