ACCESS DATABASE
See below as an example of what we offer in bespoke Microsoft Access Database training. As a general rule one day is normally enough to get to an intermediate level, or more if you have some knowledge already.
If you need to store customer or product information you need look no further than Microsoft Access Database. Learn in one day how to design and create a database and find selected contacts or products using a range of specified query criteria.
Access training can help you design a database, to use or troubleshoot an existing one, find information on a particular product or customer, create forms and reports, mail merge or print using only the records of your choice.
Tell me what you need, what level, or mix and match levels - I will prepare a day's training just for you.
Beginners
- Introduction to Microsoft Access 2000, 2003, 2007, 2010, 2013, 2016
- Crossover from another version of Access
- Starting an Access database
- Creating a table in design view and setting data types
- Table Properties
- Importing Excel data
- Setting and using a primary key
- Entering data
- Creating and using a form using the wizard
- Creating and using Select Queries in Design view
- Creating and using a report using the wizard
Intermediate
- More on Table Properties
- Input Masks and Validation rules
- Lookup Wizards - creating drop down lists in your table
- Setting one to one and one to many relationships
- Setting filters
- More on Select Query criteria
- Duplicate and Delete Queries
- Using Parameters in your queries
- Customising your form - adding extra fields, backgrounds, colours
- Editing your report and adding new data
- Switchboard manager and startup
Advanced
- Cross-tab and other queries
- Calculation queries
- Function queries
- Creating, editing and running Macros
- Custom forms
- More on forms and subforms- properties, options, buttons
- More on reports - properties, options, buttons
- Advanced Relationships - joins
- Lookups and hyperlinks
- Setting Protection and security
- Password control forms and reports
- Introduction to the Visual Basic Editor
- Enhance your database with some basic VBA
- Finding and using Visual Basic in your database
Click here to see the training rates. Please ask for a detailed Access Database Course Content Sheet to select what you would like to learn.
If you are unsure of your requirements please contact me
