RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Access DB
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Data Manipulation
«Prev
Next»
Access Database
Database Features
Open Access Database
MS Access Window
Access Help System
Access Database Window
Access Interface Conclusion
MS Access Database
What is Database
What is Relational Database
Design Relational Database
How Data is stored
Access Database Objects
Database Analysis
Create Access Database
Steps For Creating Database
Design Tables Conclusion
Creating Access Table
Creating Access Tables
Access Datasheet
Edit Access Datasheet
MS Access Functions
Importing Data
Import Access Table
Building Modifying Forms
Table Manipulation
Table Design View
Field Data Types
Changing DataType
Use InputMask To Limit Data
Selecting Table Fields
Adding Deleting Fields
Creating Hyperlinks In Access Table
Edit Table Design By Moving Field
Understanding Primary Key
Access Table Manipulation Conclusion
Adding and Deleting fields - Exercise
Adding fields in Design view
Objective
Use Design view to add two fields to the database.
You will receive 2 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the OK, I’m Done button.
Overview
In this exercise I’d like you to add two fields to the Projects table. Both fields are Yes/No fields – one is called Completed, and one is called Paid.
Instructions
Open the Projects table.
Use the Design view to add the two fields, since you are also defining the data type. You can add them anywhere in the table, but it takes sense to add them after the other fields. The first field is Completed, the second is Paid.
Once you have created the fields (in Design view), add data to them in Datasheet view. This gives you a chance to practice with unfamiliar Yes/No data. In the Projects table the first five projects are complete, and you have received payment for the first three.