North Greenville University CSCI-1305 Intro to Information Technology Access Skill Enchancement Document 2-3 In an Access database, queries are the means of manipulating the data to display in a form or a report. Queries can sort, calculate, group, filter, join tables, update data, delete data, and more. The power of a query is amazing. The database query language is SQL (Structured Query Language). Getting Started Open the Access Enhancement Document “Skill 2” Save the document to your computer Observe the existing tables in the Navigation Pane Enable Content if necessary Open the Relationship Window On the Database Tools Ribbon, Relationships Group, click the Relationships Button Observe that there are no current relationships existing In a relational database (Access), the data in one table can be related to the data in other tables. In general, tables can be related in one of three different ways: one-to-one, one-to-many or many-to-many. The relationship is used to cross reference information between tables. Add a Table to the Relationship Window If necessary, click the Show Table Button to open the Show Table dialog box In the Show Table dialog box, select Customer Orders, click Add In the Show Table dialog box, select Customers, click Add Click Close Resize a Field List In the Customers table, position the mouse over the bottom border and drag to show all fields Create a Relationship between two tables In the Customer Orders Table drag CustomerID and place over CustomerID in the Customers Table Check Enforce Referential Integrity Click Create Table relationships must obey standards of referential integrity, a set of rules that control how you can delete or modify data between related tables. Referential integrity in table relationships keeps users from accidentally deleting or changing related data. You can apply referential integrity when: the common field is the primary key; the related fields have the primary table’s same format; or both tables belong to the same database.
North Greenville University CSCI-1305 Intro to Information Technology Access Skill Enchancement Document 2-3 In an Access database, queries are the means of manipulating the data to display in a form or a report. Queries can sort, calculate, group, filter, join tables, update data, delete data, and more. The power of a query is amazing. The database query language is SQL (Structured Query Language). Getting Started Open the Access “Skill Enhancement Document 2” Save the document to your computer Observe the existing tables in the Navigation Pane Enable Content if necessary Open the Relationship Window On the Database Tools Ribbon, Relationships Group, click the Relationships Button Observe that there are no current relationships existing In a relational database (Access), the data in one table can be related to the data in other tables. In general, tables can be related in one of three different ways: one-to-one, one-to-many or many-to-many. The relationship is used to cross reference information between tables. Add a Table to the Relationship Window If necessary, click the Show Table Button to open the Show Table dialog box In the Show Table dialog box, select Customer Orders, click Add In the Show Table dialog box, select Customers, click Add Click Close Resize a Field List In the Customers table, position the mouse over the bottom border and drag to show all fields Create a Relationship between two tables In the Customer Orders Table drag CustomerID and place over CustomerID in the Customers Table Check Enforce Referential Integrity Click Create Table relationships must obey standards of referential integrity, a set of rules that control how you can delete or modify data between related tables. Referential integrity in table relationships keeps users from accidentally deleting or changing related data. You can apply referential integrity when: the common field is the primary table’s primary key; the related fields have the same format; or both tables belong to the same database.
access-skill-enhancement-document-2.docx