-
-
Key concepts and terms
-
-
-
Start a new database from a blank template
-
-
-
Build the first table and set data types
-
-
-
Build tables with the Table Designer
-
-
-
Use the Calculated data type to combine fields
-
If you're new to Access, start here. This course explains key concepts and terms, the first steps in database design, and how to build tables.
Inside this course:
Key concepts and terms (4:35)
The basics of table design and what makes a database relational.Start a new database from a blank template (4:09)
How to create a new database file, and the types of databases you can create.Build the first table and set data types (4:20)
How to create a table and set the correct data types for each field.Build tables with the Table Designer (4:17)
Create a table in Table Design view.Use the Calculated data type to combine fields (1:51)
Use the Calculated data type to combine first and last names.Course summary A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.