Create databases and simple tables - Microsoft Access 2013 - page 89

Key points
▪ Access 2013 includes templates to help you create web apps and desktop databases,
and application parts to help you add related tables and other database objects.
▪ Rather than storing all information in one table, create different tables for each type
of information, such as customers, orders, and suppliers.
▪ In Datasheet view, you can create a simple table structure by entering data and
naming fields. You can also set the data type and certain properties.
▪ Manipulating or hiding columns and rows has no effect on the underlying data.
▪ In Design view, you can modify the structure of any table, whether you created it
manually or as part of a template.
▪ Data types and properties determine what data can be entered in a field, and how the
data will look on the screen. Caution: changing some properties might affect the data.
▪ By creating a relationship between the primary key field of one table and the foreign
key field of another, you can combine information from both tables.

2