Microsoft Access 2013 / 2010: Level 3
Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
- Producing Advanced forms
- Working with field/record level data validation
- Automating tasks using macros
- Distributing and securing database
- Creating a switchboard
Prerequisites
- Microsoft Access 2013 / 2010: Level 2 or equivalent experience
Outline
- Lesson 1: Implementing Advanced Form Design
- Topic A: Add Controls to Forms
- Topic B: Create Subforms
- Topic C: Organize Information with Tab Pages
- Topic D: Enhance Navigation of Forms
- Topic E: Apply Conditional Formatting
- Lesson 2: Using Data Validation
- Topic A: Field and Record Validation
- Topic B: Form Validation
- Lesson 3: Using Macros to Improve User Interface Design
- Topic A: Create a Macro
- Topic B: Restrict Records Using a Condition
- Topic C: Validate Data Using a Macro
- Topic D: Automate Data Entry Using a Macro
- Topic E: Convert a Macro to VBA
- Lesson 4: Using Advanced Database Management
- Topic A: Link Tables to External Data Sources
- Topic B: Manage a Database
- Topic C: Determine Object Dependency
- Topic D: Document a Database
- Topic E: Analyze the Performance of a Database
- Lesson 5: Distributing and Securing a Database
- Topic A: Splitting a Database for Multiple User Access
- Topic B: Implement Security
- Topic C: Set Passwords
- Topic D: Convert an Access Database to an ACCDE File
- Topic E: Package a Database with a Digital Signature
- Lesson 6: Managing Switchboards
- Topic A: Create a Database Switchboard
- Topic B: Modify a Database Switchboard
- Topic C: Set Startup Options