Office.com
Install Office
Sign in

Sign in to Office.com

Start working in the cloud

Microsoft account
Microsoft account

Sign in with the account you use for SkyDrive, Xbox LIVE, Outlook.com, or other Microsoft services.

Organizational account
Organizational account

Sign in with the account provided by your work or school to use with Office 365 or other Microsoft services.

Learn More

United States
Submit Feedback
Skip to main content
  • HOME
  • MY OFFICE
  • PRODUCTS
  • SUPPORT
  • IMAGES
  • TEMPLATES
  • STORE
  •  
Search all of Office.com
 
Page 21 of 24PREVNEXT

Connect a form to a database

Overview
Show/Hide lesson sections
Make the data connection
 
Connect to the Access database
 
 
Select tables
 
 
Verify key, or connecting, fields
 
 
Omit fields that you don't want
 
 
The resulting form
 
 
The data source in detail
 
 
Prepare for the practice: Install Northwind Sample Database
 
 
Practice
 
 
Test yourself
 
Show/Hide lesson sections
Add controls and format the form
 
Add form controls
 
 
Format the form sections
 
 
How the form functions
 
 
Practice
 
 
Test yourself
 
Show/Hide lesson sections
Submit data
 
Choices for submitting data
 
 
Other options for submitting
 
 
Submission successful
 
 
Practice
 
 
Test yourself
 

Feedback
Quick reference card

 

Message after successfully submitting data

This is the message that any user will be happy to see.

The picture shows an example of the message that appears when the user clicks the Submit button, and the submission has worked.

Page 21 of 24PREVNEXT
Microsoft
Site DirectoryContact UsSubmit FeedbackLegalTrademarksPrivacy and CookiesAccessibility
© 2013 Microsoft Corporation. All rights reserved.