- Houston , Texas, USA.
- Info@mbstrainingcenter.com
Access 2016 Essentials
This course is part of Intellectual Development (Microsoft Office)
Instructors: Tammy McAllister
150,434 already enrolled
12 modules
Learn the fundamentals.
30 -40 hours to complete
Spread over 2 to 3 weeks
Flexible schedule
Learn at your own pace
★★★★☆ 4.8
(4,274 reviews)
About the Course
Learners will gain a fundamental understanding of this database application’s environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.
Course Objectives:
- Create and modify databases
- Manage relationships and keys
- Navigate through a database
- Protect and maintain databases
- Print and export data
- Create and manage tables
- Manage records in tables
- Create and modify fields
- Create a query
- Modify a query
- Create calculated fields and grouping within queries
- Course Objectives
- Create and Modify Databases
- Create a Blank Desktop Database
- Create a Database from a Template
- Create a Database by Using Import Objects or Data From Other Sources
- Delete Database Objects
- Manage Relationships and Keys
- Set the Primary Key
- View Relationships
- Create and Modify Relationships
- Set Foreign Keys
- Enforce Referential Integrity
- Navigate Through a Database
- Display Objects in the Navigation Pane
- Navigate Specific Records
- Create and Modify a Navigation Form
- Set a Form as the Startup Option
- Change Views of Objects
- Protect and Maintain Databases
- Compact and Repair a Database
- Back Up a Database
- Recover Data from Backup
- Split a Database
- Encrypt a Database with a Password
- Print and Export Data
- Print Reports
- Print Records
- Save a Database as a Template
- Export Objects to Alternative Formats
- Review Questions
- Create Tables
- Create a Table
- Import Data into Tables
- Create Linked Tables From External Sources
- Import Tables from Other Databases
- Create a Table from a Template with Application Parts
- Manage Tables
- Hide Fields in Tables
- Add Total Rows
- Rename Tables
- Add Table Descriptions
- Manage Records in Tables
- Update Records
- Add Records
- Delete Records
- Append Records from External Data
- Find and Replace Data
- Sort Records
- Filter Records
- Create and Modify Fields
- Add Fields to Tables
- Add Validation Rules to Fields
- Change Field Captions
- Change Field Sizes
- Change Field Data Types
- Configure Fields to Auto Increment
- Set Default Values
- Using Input Masks
- Delete Fields
- Review Questions
- Create a Query
- Run a Query
- Create a Crosstab Query
- Add Parameters to a Query
- Create an Action Query
- Create a Multi-Table Query
- Save a Query
- Modify a Query
- Rename a Query
- Add Fields
- Remove Fields
- Hide Fields
- Sort Data Within Queries
- Format Fields Within Queries
- Create Calculated Fields and Grouping Within Queries
- Add Calculated Fields
- Set Filtering Criteria
- Use Comparison Operators
- Use Arithmetic Operators
- Use Logical Operators
- Group and Summarize Data
- Review Questions
- Create a Form
- Create a Form
- Change Form View
- Create a Form from a Template with Application Parts
- Save a Form
- Configure Form Controls
- Move Form Controls
- Add Form Controls
- Remove Form Controls
- Set Form Control Properties
- Modify Data Sources
- Manage Labels
- Add Sub-Forms
- Format a Form
- Modify Tab Order
- Configure Print Settings
- Sort Records by Form Field
- Apply a Theme
- Control Form Positioning
- Insert Backgrounds
- Insert Headers and Footers
- Insert Images
- Review Questions
- Create a Report
- Create a Report Based on the Query or Table
- Create a Report by Using a Wizard
- Create a Report in Design View
- Configure Report Controls
- Add Report Controls
- Add and Modify Labels
- Modify Data Sources
- Add Calculated Fields
- Group and Sort Fields
- Format a Report
- Format a Report into Multiple Columns
- Change Report Orientation
- Control Report Positioning
- Format Report Elements
- Insert Header and Footer Information
- Insert Images
- Apply a Theme
- Review Questions
- Words from the Wise
- Lessons Learned
Offered by
MBS Traing Center
Where Visionaries Grow and Succeed.
Recommended if you're interested in Finance
Business Development
Entrepreneurship Workshop
Develop essential skills to start, manage, and grow a successful business.
(4.7)
★★★★★ 4.7/5
- Free Webinar
- Include Certificate
Personal Growth
Social Development
Enhance interpersonal skills and build stronger professional relationships.
(4.7)
★★★★★ 4.7/5
- Free Webinar
- Include Certificate
Business Excellence
Professional Development
Master leadership, project management, and workplace efficiency techniques.
(4.7)
★★★★★ 4.7/5
- Free Webinar
- Include Certificate
Career Advancement
Intellectual Development
Critical thinking, organizational skills, and decision-making abilities.
(4.7)
★★★★★ 4.7/5
- Free Webinar
- Include Certificate
Why people choose MBS Traing Center for their career
The Entrepreneurship Workshop was an eye-opener for me. I gained practical insights into business planning and market analysis, which I was able to apply immediately to my startup. Highly recommended!
I took the Career Advancement course, and it transformed how I approach leadership and communication in my role. The interactive activities and real-world case studies were incredibly valuable.
I’ve attended multiple workshops, but the Business Excellence course stood out. The hands-on exercises and expert insights gave me a deeper understanding of how to improve my business operations.
Previous
Next
Everything You Need to Know About the Course
Yes! Upon successful completion of the course, you will receive a certificate that demonstrates your mastery of key entrepreneurial skills and knowledge.
The course typically takes 30-40 hours to complete, depending on your pace. The program is spread over 12 modules and can be completed in 3 weeks at 3 hours per week. You can also take the course at your own pace with flexible scheduling.
Yes, this course is designed for aspiring entrepreneurs, small business owners, and professionals transitioning into self-employment. It covers the fundamentals, as well as advanced strategies, to help you at any stage of your entrepreneurial journey.
In this workshop, you will learn how to start, manage, and grow a successful business. Topics include business planning, market analysis, employee management, securing financing, marketing strategies, and business growth techniques.
Yes! Upon successful completion of the course, you will receive a certificate that demonstrates your mastery of key entrepreneurial skills and knowledge.
There are no specific prerequisites. Whether you're new to entrepreneurship or already running a business, this workshop will provide valuable insights and practical tools.
Yes, you will have access to the course materials and resources even after completion, so you can refer back to them as needed.
To enroll, simply visit the course registration page, fill out the form, and select your preferred payment option. You will receive immediate access to the course materials upon enrollment.
We offer a 30-day money-back guarantee. If you are not satisfied with the course within the first 30 days, you can request a full refund.
Yes! The course is designed with flexibility in mind. You can complete the modules at your own pace and choose a schedule that works for you.
