Forms: Forms are used to view data one record at a time (rather than in table view), and also as a data entry tool. Reports: Access reports you to present your data in an effective printed format. Reports can include all your data, selected parts of your data or summary data. I)TABLES: Each object in an access database has at least two views. For tables this includes: Datasheet view: displays the records contained in the table Design view: displays the properties and design of the table. These features control the type of data the table can contain, and how that data is displayed. In datasheet view, a displays as a series of columns (fields) and rows (records). In datasheet view the user can find records, sort them, filter, edit,delete and enter new records. An important thing to note about working in datasheet view is that a record being entered or edited is saved automatically, as soon as the user moves to another record. There is only one undo available in undo is not available after the deletion of a record. datasheet view,and Datasheet view: Features of the tables datasheet toolbar 1. Switch from datasheet view to design view (and back) 2. Save 3. /Print Preview 4. Spell Check 5. Cut/Copy/Paste 6. Undo 7. Sort A-Z and Z-A 8. Filter by selection/ by form/ Apply filter 9. Find 10. Next record 11. Delete Record 12. Create a new object (such as a form) based on this one Design View of a Table 1.In design, the pane lists the name of each field (column) in the table 2.Next to the name, the designer must identify the type of data that will be contained in that field. 3.A description area is also available. The designer can include notes about any field which may help others using the database. 4.Each field has its own properties sheet. The designer can set constraints here that control what the user can put in the database. Creating a table in design view 1. In the database window, be sure you are on the tables tab
Forms: Forms are used to view data one record at a time (rather than in table view), and also as a data entry tool. Reports: Access reports you to present your data in an effective printed format. Reports can include all your data, selected parts of your data or summary data. I)TABLES: Each object in an access database has at least two views. For tables this includes: Datasheet view: displays the records contained in the table Design view: displays the properties and design of the table. These features control the type of data the table can contain, and how that data is displayed. In datasheet view, a displays as a series of columns (fields) and rows (records). In datasheet view the user can find records, sort them, filter, edit,delete and enter new records. An important thing to note about working in datasheet view is that a record being entered or edited is saved automatically, as soon as the user moves to another record. There is only one undo available in datasheet view,and undo is not available after the deletion of a record. Datasheet view: Features of the tables datasheet toolbar 1. Switch from datasheet view to design view (and back) 2. Save 3. /Print Preview 4. Spell Check 5. Cut/Copy/Paste 6. Undo 7. Sort A-Z and Z-A 8. Filter by selection/ by form/ Apply filter 9. Find 10. Next record 11. Delete Record 12. Create a new object (such as a form) based on this one Design View of a Table 1.In design, the pane lists the name of each field (column) in the table 2.Next to the name, the designer must identify the type of data that will be contained in that field. 3.A description area is also available. The designer can include notes about any field which may help others using the database. 4.Each field has its own properties sheet. The designer can set constraints here that control what the user can put in the database. Creating a table in design view 1. In the database window, be sure you are on the tables tab
COMPUTERS-APPLICATIONS-IN-MANAGEMENT-1.docx