RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Access DB
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Components
«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
Create Access Database from Scratch - Exercise
Create a blank Access database
Objective:
Create the database for your course project.
Exercise Scoring
This exercise is worth 5 points. The exercise is auto-scored, which means that all you have to do to receive credit for it is click the Submit button below.
Instructions
Create a new database:
Open Access. Choose the Blank Database option on the initial dialog box and click OK.
If Access is already open, click the Open button on the toolbar, press Ctrl-N or choose File>>New from the menu.
Click the Database icon on the General tab and then click OK.
You see the File New Database dialog box. Name the database: Consulting.
Save it in the My Documents or Personal folder.
Click Create. Access will automatically add the .mdb extension to the file name you provide.
Close Access.