Microsoft Access Project

This project was perhaps the most time consuming and troubling. It was really hard to do. I got confused in a lot of parts. But I really liked learning the part where you can import data in pretty much any format in to the database. You can share data between Access and Excel in many ways. You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into an Access database, or simply load an Access datasheet into Excel using the Analyze it with Excel command. This topic explains in detail how to exchange data between Access and Excel by importing, exporting, or linking to data. I really liked the part where you had to create tables. I enjoyed that a lot and really learned a lot of new stuff. When you create a database, you store your data in tables — subject-based lists that contain rows and columns. For instance, you can create a Contacts table to store a list of names, addresses, and telephone numbers, or a Products table to store information about products. Because other database objects (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.) depend so heavily on tables, you should always start your design of a database by creating all of its tables and then creating any other objects. Before you create tables, carefully consider your requirements and determine all the tables that you need.