Database Training with Microsoft Access

SkillsFuture Course - Database Training with Microsoft Access

Learn how to build databases to store and retrieve your data more efficiently with Access 2016. The trainer will  show you how to use the powerful program to wrangle your data and create your first table, and highlights smart strategies to edit and modify fields and records.

The course also shows you how to build queries and action queries, create and design forms, use macros, integrate Access with the rest of the Office 2016 suite, and maintain your databases over time.

Topics include:

• Creating a new database
• Creating tables and new data types
• Importing and entering data
• Setting up relationships and primary keys
• Adding validation rules
• Sorting and filtering table data
• Building queries
• Designing forms
• Creating reports
• Attaching macros to buttons and tables
• Working with Excel and Outlook data
• Maintaining an Access database

Module 1. Getting Started

• Key database concepts
• Launching Access and the backstage screen
• Creating the database file
• Understanding the Trust Center
• Digging into Ribbon tabs
• Using the Navigation pane
• Using the Tell Me feature
• Using the Quick Access Toolbar
• Signing in to a Microsoft account
• Making backups
• Accessing Access help

Module 2. Creating Tables

• Understanding table structure and relationships
• Creating a table and setting data types
• Entering data
• Understanding primary and foreign keys
• Importing tables

Module 3. Setting Field Properties

• Establishing relationships and maintaining referential integrity
• Editing table structure in Design view
• Controlling input with masks
• Setting the default value
• Establishing validation rules
• Creating lookup fields
• Setting additional field properties

Module 4. Organizing Records

• Formatting columns
• Sorting table data
• Filtering table data
• Searching and replacing values

Module 5. Using Queries

• Understanding queries
• Creating queries with the Simple Query Wizard
• Building queries in Design view
• Establishing constraints with criteria
• Specifying criteria with wildcards
• Leveraging multiple criteria with AND and OR statements
• Filtering with mathematical comparisons
• Creating flexible queries with parameter requests
• Building expressions
• Obtaining summary statistics

Module 6. Working with Specialty Queries

• Using update queries
• Using make table queries
• Finding unmatched records
• Using delete queries
• Using append queries
• Creating a union query in SQL view
• Getting a different look with crosstab queries

Module 7. Creating Forms

• Understanding the role of forms
• Generating forms from tables
• Adjusting form elements in Layout view
• Using the Form Wizard

Module 8. Designing Forms

• Creating forms in Design view
• Exploring the form property sheet
• Setting data sources
• Adding components with form controls
• Understanding input boxes
• Record navigation
• Adding buttons
• Assigning a tab order
• Checking out the More Forms options
• Creating a navigation form

Module 9. Creating Reports

• Introducing reports
• Using the Report Wizard
• Creating a report in Design view
• Editing a report in Layout view
• Grouping and sorting records
• Creating calculated totals
• Applying conditional formatting rules
• Creating labels
• Adjusting print settings

Module 10. Working with Macros

• Creating macros
• Embedding macros into buttons
• Attaching data macros to tables
• Launching macros at startup

Module 11. Integrating Access with Office Suite

• Exporting tables to Excel
• Emailing with macros
• Linking to data in an Outlook database
• Setting up labels and mail merge documents in Word

Module 12. Maintaining the Database

• Organizing the Navigation pane with custom groups
• Compacting and repairing the database
• Examining database object dependencies
• Documenting your work
• Printing the blueprint of your database with the Database Documenter
• Splitting a database into front and back ends
• Protecting the database with a password
• Creating custom Ribbon tabs
• Setting startup options and custom icons

Sundari has more than 10 years of experience in Software Training and Development. She initiated her career as a Trainer and worked in various companies, developing and nurturing client relationships. She is passionate about training and to impart her knowledge to others and always eager to learn more.

Area of expertise:

• Data Warehousing - SAP BI 7.0
• Reporting Tools - BEx Query Designer, BEx Analyzer, Web Analyzer, Web Application Designer, BEx Report Designer and Dash Boards
• Language - Visual C++ (6.0), C#(.Net), C, C++, Java and also in SAP ABAP/4, SD, FI
• Operating Systems - Windows10, 7, 2000.NT, 98, XP, MS-DOS, Unix
• Databases - Oracle 9i/8i, SQL Server and MS-Access
• GUI - Visual Basic 6.0, Power Builder 5.0, Developer 2000 
• Java-script, HTML5, CS6, Dreamweaver, MS-Office.

She is currently pursuing Masters in Business (ERP Systems) in Victoria University, Australia. She has completed her Bachelors in Computer Science in Bharathiar University, India and Professional Diploma in SAP Business Intelligence in Victoria University, Australia - Lithan Hall Academy, Singapore. She is certified in SAP BI 7.0 (TBW45_70) and Oracle 9i PL/SQL Developer from Oracle Corp U.S. Also certified in ACTA (Advanced Certificate in training and assessment) from WDA Singapore.

Follow us on FB and subscribe to our newsletter to get updated on our Monthly Promotional Offers.