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.
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.