Microsoft Access Developer (Level 3) 2003 2007 2010 2013 2016 & 365
Training
In Newcastle Upon Tyne
Description
-
Type
Training
-
Level
Advanced
-
Location
Newcastle upon tyne
-
Duration
2 Days
-
Start date
Different dates available
Microsoft Access Developer (Level 3) comprises of 2 days training wherein participants will learn how to be able to produce a database which could be used by people with no Microsoft Access knowledge.
Important information
Documents
- Course content
Facilities
Location
Start date
Start date
About this course
To enable participants to produce a database.
This course is suitable for participants who are familiar with the topics covered in Microsoft Access Intermediate (Level 2) course.
Some experience in using/creating a database would be beneficial.
Certificate of participation can be obtained if required.
On receiving your request we will contact you to explain course content, including course dates and payment options.
Reviews
Subjects
- Microsoft Access
- Access
- Database
- Database training
- Menu System
- Database Utilities
- Macros
- Modules
- Dynamic Queries
- Database Splitter
Teachers and trainers (1)
Chris Edmondson
IT Trainer
Course programme
Microsoft Access Developer
1 Introduction
· Basic Concepts
· The Training Database Project.
2 Tables
· Normalising the Data
· Naming Conventions
· Relationships between Tables
3 Forms
· Using the Form Wizard
· Setting Form Properties
· Setting Control Properties
· Importing Microsoft Excel data
· Creating a Main Form/Sub Form
4 Creating a Menu System
· Designing a Menu Form
· Writing a Macro for the Menu
· Returning to the Menu
· The Startup dialog box
5 Database Utilities
· Compact and Repair
· Database Splitter
· Linked Table Manager
· Converting a Database
6 Security
· What is a Workgroup
· Users and Groups
· Permissions
· Activate the Logon Procedure
7 Queries and Reports
· Multi-Table Queries
· Using the Report Wizard
· Working in Design View
· Adding Reports to the Menu
8 Macros
· Basic Features
· The AutoExec Macro
· The AutoKeys Macro
9 Modules
· Some Definitions
· Creating a Function Procedure
10 Events
· When Events Occur
· Creating an Event Procedure
11 Expressions
· About Expressions
· Generating Custom Codes
12 Dynamic Queries
· Develop the Query
· Link to a Main Form/Sub Form
· Automate with simple VB code
13 Action Queries
· Make Table / Append / Update/ Delete Queries
14 Other Features
· Calculations in Queries
Microsoft Access Developer (Level 3) 2003 2007 2010 2013 2016 & 365