XL7: How to Return to Microsoft Excel After Using Access Form

MORE INFORMATION

To create a sample list

1. Open a new Microsoft Excel workbook.
2. Create a sample list in Sheet1:
   
   

      A1: NAME     B1: CITY     C1: AMOUNT
      A2: Bob      B2: Dallas   C2: 10
      A3: Sue      B3: Miami    C3: 9
      A4: Mary     B4: Buffalo  C4: 8

3. Save your workbook. You must do this before you create a form.

To create a form using a Microsoft Access wizard

1. Select cell A1.
2. On the Data menu, click Access Form.
   
   If the Access Form command does not appear on the Data menu, make sure the AccessLinks add-in is installed.
3. In the Create Microsoft Access Form dialog box, choose New Database and then click OK.
4. In the Form Wizard, double-click each of the fields listed in the Available Fields box, and then click Next.
5. Choose the Columnar layout type and then click Next.
6. Choose any of the Style types and then click Next.

To return to Microsoft Excel

1. On the File Menu, click Close. This will close your form.
2. On the File Menu, click Exit.