Types of Relationships in Access
There are three types of relationships:
A row in table A can have only one matching row in table B, and vice versa.
A row in table A can have many matching rows in table B, but a row in table B can have only one matching row in table A.
A row in table A can have many matching rows in table B, and vice versa. This is achieved through the use of a third table (commonly called a junction table) that contains lookup data for both tables.
Types of Data in Access
Short text: Text or Numbers not used in calculations such as name, postal code, phone number fewer than 255 characters
Long Text: Lengthy text greater than 255 characters ( comments or notes)
Number: Numeric data that can be used in calculations, such as quanities.
Large Number: Provides additional analytical capability and deepens the integration experience when users are importing or linking to bigInt data
Date/Time: Dates and times
Currency: Monetary Values-best applied to fractional values such as those representing money
AutoNumber: Sequential Intergers controlled by Access
Yes/No: Yes or No or Null (neither yes nor no)
Ole Object: OLE-Object Linking and Embedding: objects such as excel spreadsheet or word document
Hyperlink: Web and email addresses or links to local files
Attachment: Files such as .jpg images, spreadsheets, and documents
Calculated: results of a calculation based on other fields in the table
MS Access - Create Relationships
Steps on Creating relationships in access TutorialsPoint
How to Create a Relationship in Access
To create a relationship in Access 2013 or 2016
Tables and Relationships
Creating tables in Access
To create a table in access open up the access aplication, Click Blank database so a new database opens up on the screen. A blank table will appear on the database.
To fill in the table first you must click where it says click to add on the table. A drop down menu will appear. This is where you will choose what type of data will be in the new field for the table. Click on the type of data such as Short text.
Once you've selected a data type, the field header will be highlighted along with the text Field1. Replace Field1 with the name you want for the field.
In the box where it says ID change the title as well to what you want it to be based on the data collected. Manually Fill in all other information into the table. Once this is complete save database by clicking the save button in the quick access toolbar.
Add a new Table to the database by clicking on create tab under the ribbon then to Table. A new table is added. Complete the table the same way as above.
You can also create a new table using the design view. To change the view click home > View then design view.
Importing Data Into a Table
There are several ways data can be imported into a table:
Step 1: To start, prepare the data to be imported into Access. for instance store in an excel file.
You can then type a name for the import steps. Once you’re done, click on the Save Import button:
Your Excel file should now be imported into Access.
Relationships
In a relational database (Access), the data in one table is 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.