Microsoft Access
is used by small businesses and within departments of large organisations to
create customized systems for storing, processing and reporting information.
Microsoft Access enables a relatively quick development because all
tables, queries, forms, and reports are stored in the one database.
From Novice to expert, Microsoft Access allows system development to
be within the reach of the user.
Our training Allows you to capitalise on this
extremely useful and mostly under utilized resource. Our standard
Advanced
course is outlined below but we can discuss bespoke courses and also
collaborative development of any database you wish to create.
Microsoft Access
Advanced Training Course
|
Querying with SQL
SQL and Access
Writing SQL statements
Attaching SQL queries to controls
Advanced queries
Creating crosstab queries
Creating parameter queries
Using action queries
Macros
Creating, running, and
modifying macros
Attaching macros to the events of database objects
Advanced Macros
Creating macros to
provide user interaction
Creating macros that require user input
Creating the AutoKeys and AutoExec macros
Creating macros for data transfer
|
Importing, exporting, and linking objects
Importing objects
Exporting objects
Interacting with the XML documents
Linking Access objects
Working with Windows SharePoint Services
Database management
Optimizing resources
Replicating and synchronizing databases
Security fundamentals
Protecting databases
Encrypting and decrypting databases
User-level security |
|
 |
