Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Access 2010 : Creating Databases Using Database Templates, Creating a New Table in Design View

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
11/7/2012 3:54:55 PM

1. Creating Databases Using Database Templates

The Microsoft Access product team has one primary goal: to make it as easy as possible for you to create powerful and useful databases that help you get your work done quickly. You must have a great database program to meet that goal, but it also helps if the developers draw on the rest of the Microsoft community to design databases you can use without modification (for tasks such as tracking your contacts, sales, or workouts) or to use as the basis for your own custom databases. You can find those preexisting databases, called templates, installed on your computer and also on the Office.com Web site.

1.1. Create a Database from a Template

  1. If necessary, click the File tab and then choose Close Database to close any open database.

  2. Click a Template Category.

  3. Click the desired template.

  4. Type a name for your database.

  5. Click Create.


Note:

You can select the folder where you want to save your database file by clicking the folder icon next to the File Name box in Backstage view.


1.2. Find Database Templates Online

  1. If necessary, click the File tab and then click Close Database to close any open database.

  2. Click an Office.com template category.

  3. Click the desired template.

  4. Type a name for your database.

  5. Click Create.


Note:

You can search for templates on the Office.com Web site by typing one or more keywords in the Search Office.com For Templates box and clicking the Start Searching button.

2. Creating a New Table in Design View

After you plan your database, you can start creating tables to store your data. One good way to define your table’s structure is to start out in Design view. When you look at a table in Design view, you can define the name of a field, select the type of data to go into that field (numerical values, currency values, text, dates, phone numbers, and so on), and write a description for that field. Field descriptions are one of the most overlooked parts of database design. It’s easy to overlook them or see them as unnecessary, but the reality is that you might forget what sort of data is supposed to go into a field. You could also leave the company and force someone else to figure out what a particular field should contain. If you’ve ever been handed someone else’s database, you probably encountered a field you weren’t sure about. Please make everyone’s job easier by adding a description!

2.1. Create a Table in Design View

  1. Click the Create tab.

  2. In the Tables group, click Table Design.

  3. Type a name for the first field and press Tab.

  4. Click the Data Type down arrow.

  5. Select a data type.

  6. Type a description for the field.

  7. Press Tab and repeat steps 4 through 7 to add fields.

  8. Click the Save button.

  9. Type a name for the table.

  10. Click OK.

  11. When asked whether you want Access 2010 to assign a primary key to your table, follow one of these steps:

    • Click Yes to have Access 2010 assign a primary key.

    • Click No to have Access 2010 create the table without a primary key.

    • Click Cancel to continue without saving your table.

  12. Click the Close box for the table.


Note:

Creating a database table that doesn’t include a primary key field makes it difficult to get data out of your table by using queries and in relationships with other tables. You should always have a primary key field in every table you create.

Other -----------------
- Microsoft PowerPoint 2010 : Building a Presentation Outline - Working with Outline Contents
- Microsoft PowerPoint 2010 : Building a Presentation Outline - Adding Text in the Outline Tab
- Microsoft PowerPoint 2010 : Understanding the Relationship of the Outline to Slides, Working with the Outline
- The Process of Troubleshooting Network Problems (part 5)
- The Process of Troubleshooting Network Problems (part 4) - How to Troubleshoot Joining or Logging on to a Domain
- The Process of Troubleshooting Network Problems (part 3) - How to Troubleshoot Name Resolution Problems, How to Troubleshoot Performance Problems and Intermittent Connectivity Issues
- The Process of Troubleshooting Network Problems (part 2) - How to Troubleshoot Application Connectivity Problems
- The Process of Troubleshooting Network Problems (part 1) - How to Troubleshoot Network Connectivity Problems
- Microsoft Excel 2010 : Analyzing Data by Using Descriptive Statistics
- Microsoft Excel 2010 : Finding Optimal Solutions by Using Solver
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer