Access Training for New Users
Course
Online
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
2 Days
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
This access course is suited for users who already have a good working knowledge of Access, during your access course you feel confident to be able to design and build relational databases that incorporate macro automation, manipulate data and have the skills to work with and run advanced queries coupled with the knowledge of being able to produce advanced forms and create reports
As many versions of Access are available when enquiring about this access course please let us know which version of Microsoft Access you are using, we are able to train on all versions – 2003 / 2007 / 2010 In addition we are able to provide 10 laptops with 2007/10 access preloaded to make setting up a training course much easier, we only charge a delivery and collection fee for their use.
Facilities
Location
Start date
Start date
About this course
The current outline for the access training for advanced users course enables you to:
Have a complete understanding of the higher functions of Access
Learn to automate functions by creating simple and then very advanced macros
Understand advanced querying
Add SQL statements in your queries
Work with objects
Understand the fundamentals of database management
Protect valuable data sources
Reviews
Subjects
- Access
- Database
- SQL
- Database training
- PivotTable
- Modify
- Working
- Advanced
- Forms
- Designing
- Automating
Course programme
During this access training course, you learn about:
PivotTables and PivotCharts
- Create a PivotTable
- Modify a PivotTable
- Working with a PivotChart
- Designing a form based on joined tables
- Automating data entry
- Grouped control
- How to improve the user interface
- Designing subforms
- Create and run macros
- Attach macros to events of database objects
- Create macros to provide user interaction
- Create macros requiring user decision
- Use AutoKeys and AutoExec macros
- How to identify different clauses in an SQL statement
- Writing SQL statements
- Attach an SQL statement to database objects
- Work with hyperlink fields
- Work with data access pages
- Work with database utilities to optimise resources
- Secure data by database replication
- Protect databases
Access Training for New Users