Microsoft Access 2010: Level 3
This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
In this course, you will work with relational database structure, relationships, efficiency, integrity, and customization.
- Design a relational database.
- Join tables to retrieve data from unrelated tables.
- Organize a database for efficiency, performance, and to maintain data integrity.
- Share data between Access and other applications.
- Customize reports to organize the displayed information and produce specific print layouts
Lesson 1: Advanced Form Design
Topic A: Adding Controls to Forms
Topic B: Creating Subforms
Topic C: Organizing Information with Tab Pages
Topic D: Displaying a Summary of Data in a Form
Topic E: Applying Conditional Formatting
Lesson 2: Data Validation
Topic A: Field and Record Validation
Topic B: Form Validation
Lesson 3: Using Macros to Improve User Interface Design
Topic A: Creating a Macro
Topic B: Restricting Records Using a Condition
Topic C: Validating Data Using a Macro
Topic D: Automating Data Entry Using a Macro
Topic E: Converting a Macro to VBA
Lesson 5: Distributing and Securing a Database
Topic A: Preparing a Database for Multiple User Access
Topic B: Implementing Security
Topic C: Setting Passwords
Topic D: Converting an Access Database to an ACCDE File
Topic E: Packaging a Database with a Digital Signature
Lesson 6: Managing Switchboards
Topic A: Creating a Database Switchboard
Topic B: Modifying a Database Switchboard
Topic C: Setting Startup Options
To ensure your success in your course you should have experience working with Microsoft Access 2010, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:
Microsoft® Office Access® 2010: Level 1
Microsoft® Office Access® 2010: Level 2