1 / 25

Overview

Overview. Importing text files Creating Forms Creating Reports. Importing files. You can create or populate a table in Access by importing data from External files (including text file, Excel file or files from other database applications e.g. SQL database files.)

katoka
Download Presentation

Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview • Importing text files • Creating Forms • Creating Reports

  2. Importing files • You can create or populate a table in Access by importing data from External files (including text file, Excel file or files from other database applications e.g. SQL database files.) • For importing a text file, Click on the “External Data” tab and click on text file. • An importing dialog box appears which helps you through the importing process . Click on the “browse” button and navigate to the location of the text file that you wish to import and click on OK.

  3. Importing a Text File Click on browse to navigate the location of the file you are importing

  4. Select the file from your Computer Click Open to Import the file

  5. Importing a Text File The Text file is Imported as a new table

  6. Importing a Text File Delimiter is Comma in the Text file

  7. Importing a Text File Make sure this box is checked, else even Fields become Records in the Table

  8. Importing a Text File Click Next

  9. Importing a Text File You can choose your own Primary key

  10. Importing a Text File You can rename the table here

  11. Importing a Text File Click close since we do not want to save the importing steps

  12. Importing a Text File A normal Text file has been converted into a regular Table in Access by Importing it.

  13. Creating Forms • Like Datasheet view, Forms can be used to manipulate records in a table. • To create a Simple form, click on the “create” tab and select the table for which you want to create form and click on the “Form” button. • Click on the save button and specify a name for your form.

  14. Creating Forms

  15. Form views • Two views for modifying the form: • Form view: This view is used to change records in the table, e.g. add/delete/modify • Layout view: To change the layout of the form, e.g. add/delete/change labels and fields.

  16. Layout View of Form You can go to the Next record

  17. Saving the Form

  18. Creating a Report

  19. Layout View of the Report

  20. Layout View of Report (Contd..) You can delete only in Layout View

  21. Views of Report By default the View of report is ‘Layout’

  22. Report view

  23. Saving the Report

  24. Practice these steps until your comfortable with all the concepts.Thank You Contributed to and created by the CS200B TAs

More Related