This chapter is sub divided into two parts and this is the first part. If you have already read this part, click to read part two – Table Operations and Relationships/Join.
In this part of the chapter, I will explain explicitly, table – one of the objects of a database, its field properties and data types. At the end of this chapter, I will give some practical exercises. Please endeavor to practise those exercises as it will help you to have a deep comprehension of table, its field properties and data types.

In the previous chapter of this tutorial, I taught on introduction to MS-Access, a Database Administration System, some new features of MS-Access 2016, how to download MS-Access 2016 and other versions, how to load MS-Access into memory and how to create a blank desktop database, etc.Click to read Part1: Introduction to MS-Access.

You can download the PDF e-book file of this chapter for free and study at your convenient time. The e-book contain both parts of this chapter properly written. Click to download the e-book: Objects of a Database - Table Operations and Relationships.

CHAPTER CONTENTS
• OBJECTS OF A DATABASE
• TABLE
• FOUR PRINCIPLES FOR BUILDING A STRONG FOUNDATION FOR YOUR DATABASE
• IMPORTING DATA FROM AND LINKING TO DATA IN ANOTHER DATABASE OR OTHER SOURCES
• METHOD OF CREATING AND VIEWING A TABLE
Datasheet View
Table Design view
• INPUT DESIGN
Combo Box
List Box
Logical Yes or No
• FIELD PROPERTIES
Default Value
Validation Rule
Validation Text
Input Mask
Required

• DATA TYPE
OBJECTS OF A DATABASE
These are the tools used in preparing data which determines the pattern or format of database you are creating. They form the basis for the major operations on a database. They include:

• Tables store the data in the database and are analogous to the foundation of the database. It is critically important that the tables be designed properly; they provide the foundation for building the remainder of the database.

• Queries enable you to extract data from your database tables and allow us to answer questions we have about the data. Queries may combine data from multiple tables and manipulate data output through the use of expressions, formulas, and functions.

• Forms are based on tables or queries, and they are used for entering data into the database in a user-friendly manner. They are also used for displaying data to the end user and can be used to create a menu system for the database.

• Reports use data from a table or query and format the output in a professional-looking manner. Reports provide you with the ability to summarize, sort, group, and display the data in many different ways suited to the needs of the end user. Often, the purpose of a report is to provide a printed output of some data in your database.

• Macros are small programs that you build into Microsoft Access; they perform some advanced operations, making the database more user-friendly and/or functional.

For this chapter, I will explain explicitly, table which is the first and most important object of a database, some of its operations and table relationship.
Read more here http://microsofttut..com.ng/2016/07/objects-of-database-table-field.html