Databases Essay

333 WordsAug 16, 20152 Pages
DATABASES How do I get data from another file? 1. Click File / Get external data 2. Click Browse / ok 3. Find the data file and click on it How do I create a report? 1. Open the file with the data 2. Click Create / Report 3. Type a report name (depending on what the information is about) 4. Click ok You will see the new report name on a tab and the report will appear as below: How do I delete a report? 1. Click on the tab you wish to delete 2. Click Edit/ Delete Report 3. You will be asked if you are sure and click yes How do I create a report containing only certain information? You have to create a Query and then put it into a report Create a Query 1. Click Create / Query Wizard 2. Type in the Query Name 3. Keep Table 1 as the selected table 4. Click Next 5. Click on the field you wish to include in the query 6. Click >> 7. Click on another field you wish to include in the query 8. Click >> and so on until all the fields have been moved across 9. Finally click next 10. Field Column – Click on drop down menu and select the field 11. Click on the next drop down menu and select the field 12. Continue until all the fields are selected 13. Click on Show to ensure those fields appear in the Query 14. Criteria Column – type in the criteria (i.e. = or > or <) 15. Click Finish 16. Query Tab has now been added Put into a Report 1. Click Create Report 2. Type in a name for the Report 3. Select the table using the drop down menu 4. Click ok How to create a new record? (another line in the database) 1. Click Create / New Record How to create a new field? (another column to add more information) 1. Click Create / New Record

More about Databases Essay

Open Document