More Related Content
Similar to MS Office Access Tutorial
MS Office Access Tutorial
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12. TabsHome: Views, Clipboard,Fonts, Rich Text, Records, Sort & Filter, FindCreate: Tables, Forms, Reports, OtherExternal Data: Import, Export, Collect Data, SharePoint ListsDatabase Tools: Macro, Show/Hide, Analyze, Move Data, Database Tools
- 13. Customize the AccessEnvironment
- 14.
- 15. Database Terms TableAtable is a collection of information arranged in rows and columns. Information about an item is displayed in a row. Columns contain the same type of information for each item. The table has a header row that tells you what data is contained in the columns.
- 16. RecordsetA recordset isa table that displays groups of records from a base table or as a query result. FormA form is a graphical interface that is used to display and edit data. Forms can be developed from a table or a query. Forms can include calculations, graphics and objects.
- 17. QueryQueries select recordsfrom one or more tables in a database so they can be viewed, analyzed, and sorted on a common datasheet.A query can also perform calculations and display the results. The resulting collection of records, called a dynaset (short for dynamic subset), is saved as a database object and can therefore be easily used in the future.ReportA report is an output of data arranged in the order you specify. Reports can perform calculations and display the results. Reports can be used to print data.
- 18. Run a QueryTorun a query: Click the arrow to open the navigation pane
- 19. Double-click onthe query name Form
- 20.
- 21. Create a NewDatabase
- 22.
- 23.
- 24. Create a TableDatasheet View
- 25.
- 26. Adding New FieldsAddNew Field column
- 27. New Field ButtonDesignView button
- 28.
- 29.
- 30.
- 31. Add a Descriptionto a Table
- 32. KeysThe primary keyis a unique identifier for a record. The primary key cannot be the same for two records. This field can never be blank.
- 33. Composite KeyA compositekey is a primary key that is comprised of two or more fields. It can also be called a compound or concatenated key. Foreign KeyA foreign key is a field or combination of fields that are related to the primary key of another table.
- 34. Table RelationshipsTable relationshipsare the associations of data between tables. By defining table relationships, you can pull records from related tables based on matching fields.
- 35. One-to-One RelationshipA one-to-onerelationship is between two tables where the primary key in one table and the foreign key in another table are the same. For each record in the first table, there is a single matching record in the second table.
- 36. One-to-Many RelationshipA one-to-manyrelationship occurs between two tables where the primary key in one table can be duplicated many times in another table
- 37.
- 40. Print a TableRelationship
- 41. Managing Data AddRecords to a Table
- 42.
- 43.
- 44.
- 45.
- 46.
- 48.
- 49.
- 51.
- 52.
- 53.
- 54. Calculated Fields Acalculated field is a field that gets its information from the calculations performed on other fields. You can build calculated fields in the Query screen by using the addition (+), subtraction (-), multiplication (*) and division (/) operators.
- 55.
- 56. Choose the tablesthat you wish to build the calculation fromDouble-click the field that you want to include in the calculationClick the operator that you wish to include in the calculationClick the second field you wish to include in the calculationClick OK
- 58. Prepared byAl HudaInternational Welfare Foundationwww.alhudainstitute.cawww.farhathashmi.comwww.alhudapk.comSourcesMicrosoft CorporationFlorida Gulf Coast University