Analysis of level 2 Access test sites for the Level exam: databases and tables

6.1 data access page view test site 1 page view is a way to view the generated data access page style. When you open a data access page in the design view of Test Site 2, you must modify the data access page. Click the name of the data access page to be opened, and then select the "design" button to open the design view of the data access page. "Design

6.1 data access page view test site 1 page view is a way to view the generated data access page style. When you open a data access page in the design view of Test Site 2, you must modify the data access page. Click the name of the data access page to be opened, and then select the "design" button to open the design view of the data access page. "Design

6.1 data access page view
Test site 1 Page View
The page view is a way to view the generated data access page style.
Test site 2 Design view
To open a data access page in a design view, you must modify the data access page. Click the name of the data access page to be opened, and then select the "design" button to open the design view of the data access page.
The "design" view is a visual integrated interface for creating and designing a data access page. Under this interface, you can modify the data access page.
6.2 create a data access page
Test site 3 automatically creates a data access page
"Automatically create data access page" to create a data access page that contains all fields in the basic table, query, or view (except the fields storing images) and records.
(L) In the "Database" window, click "page" under "object ".
(2) Click "new" in the toolbar of the "Database" window.
(3) In the "Create data access page" dialog box, click the "automatically create data page: vertical bar" button. On the completed data access page, each field appears in the form of a tag on the left side on a separate row.
(4) Select a table, query, or view that contains the data required for the page to be created.
(5) Click OK.
If the result page differs from the page you need, you can modify the page in the design view.
Test Site 4 Use the Wizard to create a data access page
(1) In the "Database" window, click "page" under "object ".
(2) Click "new" in the toolbar of the "Database" window.
(3) In the "Create data access page" dialog box, click the "data page wizard" button.
(4) Select the name of the data table, query, or view required to create a data access page.
(5) Click OK.
(6) follow the instructions in the Wizard dialog box.
If the result page differs from the page you need, you can modify the page in the design view.

6.3 edit the data access page
Add tags to test site 5
You can create a separate tag (that is, a tag that is not attached to another control) through the following process ). To create a tag attached to a control, you only need to create the control. Access automatically attaches the tag to the control when it is created.
(L) Open the data access page in the design view on the data access page.
(2) Click the "tag" button in the lower box.
(3) On the data access page, click the location of the tag to be placed, and type the corresponding text on the tag.
Test site 6 Add command button
You can create your own command button or use the Wizard to allow Access to create the required command button. You can use the Wizard to accelerate the process of creating command buttons because the wizard completes all basic tasks for the user. When you use the wizard, Access prompts you to enter the required information and create a command button Based on your answers.
You can use the "command Button wizard" to create more than 30 command buttons of different types. For example, you can create a command button to find records, print records, or apply form filtering.
The wizard is unavailable when the data access page is a separate data access page or the data access page is directed to a database that is not currently open. If the data access page is not bound to a table or query, the "command Button wizard" is unavailable. If the Wizard is unavailable, you must create a command button.
Add scroll text to test site 7
1. Create a scroll text control to display data on the data access page.
(1) Open the data access page in the design view.
(2) Click "scroll text" in the toolbox.
(3) Click "Field List" in the toolbar to display the field list.
(4) drag the selected field from the field list to the data access page. Place the upper left corner of the icon to the desired position in the upper left corner of the scroll text control.
2. Create a scroll text control on the data access page.
(1) Open the data access page in the design view.
(2) Click "scroll text" in the toolbox.
(3) Click the place in the upper left corner of the scroll text control on the data access page. Access creates a control of the default size. To create a scroll text control of a specific size, click the data access page and drag and drop the control until the required size is obtained.
(4) Select the default text tree in the scroll text control and enter the information to display.
Topic used in test site 8
A topic is the unity of design elements and color schemes for project symbols, fonts, horizontal lines, background images, and other data access page elements. The topic helps you easily create data access pages with professional design.
When a topic is applied to a data access page, the following elements on the data access page are customized: body and title styles, background colors or graphics, table border colors, horizontal lines, project symbols, hyperlink colors, and controls.
You can use the "topic" command in the "format" menu to apply a topic, apply a different topic, or delete a topic for the first time. By selecting a topic from the list of available topics, and then viewing the display of elements on the sample data access page in the "theme sample" box, you can preview the topic before applying it. Before applying the theme in the "theme" dialog box, you can set some options to apply brighter colors to text and graphics, and change a specific theme image to an active image; apply background to the data access page. Only when you view data Access pages in a Web browser can the theme image be active, while the theme image is always static in Access.
Test site 9 Add an Office workbook
An Office Workbook is similar to a Microsoft Excel worksheet. You can enter raw data, add formulas, and perform workbook operations in an Office workbook.
In the Access database, you can add an Office workbook to the data Access page. After adding an Office workbook to the data Access page, you can use the page view of the data access page or the Internet Explorer browser to view and analyze relevant data.

[1] [2] [3] [4] [5] Next page

2.2 create a table
Test Site 4 Access Data Type

Common Data Types of Access include: access data types such as text, remarks, numbers, date/time, currency, automatic number, YES/NO, OLE object, hyperlink, and query wizard are shown in Table 2-1.
Data Type usage size
"Text" text or combination of text and numbers, such as addresses, can also be numbers that do not need to be calculated, for example, the phone number, part number, or zip code can contain a maximum of 255 characters. Microsoft Access only saves the characters entered in the field, rather than empty characters in unused positions in the text field. Set the "field size" attribute to control the maximum number of characters that can be entered.
"Remarks" long text and numbers, such as remarks or descriptions up to 64000 characters
"Number" refers to the number data that can be used for arithmetic computation, except for the computation of currencies (using the currency type ). Set the "field size" attribute to define a specific number type of 1, 2, 4 or 8 bytes. The 16-character section is only used for Synchronous replication ID (GUID)
The "date/time" Date and time are 8 bytes.
Currency value. The currency data type can be used to avoid rounding During calculation. Accurate to 15 digits at the bottom left of the decimal point and 4 digits at the right of the decimal point, 8 bytes
The unique sequence (increment by 1 each time) or random number of 4 bytes that is automatically inserted when a record is added. 16 bytes are only used for Synchronous replication ID (GUID)
The "yes/no" field only contains one of the two values, such as "yes/no", "True/false", and "On/Off ".
"OLE object" is an object created using the OLE protocol in other programs (such as M-icrosoft Word documents, Microsoft Excel workbooks, images, sounds, or other binary data ), these objects can be linked or embedded in Microsoft Access tables. You must use the BIND object box in the form or report to display a maximum of 1 GB of OLE objects (limited by disk space)
"HYPERLINK" stores the hyperlink field. The hyperlink can be a UNC path or URL with a maximum of 64000 characters
The "view wizard" allows you to use a combo box to select fields from other tables or from values in the Value List. Select this option in the Data Type list to define the boot wizard with the same length as the primary key field, and this field is also a "check" field; usually 4 bytes

Note: "Number", "date/time", "currency", and "yes/no" Data Types provide pre-defined display formats. You can select the desired format from the available formats of each data type to set the "format" attribute. You can also create custom display formats for all data types, except for the "OLE object" data types.

Previous Page [1] [2] [3] [4] [5] Next page

Test site 5 Create Table Structure

There are three ways to create a table structure. One is to directly enter the field name at the field name in the "data table" view; the other is to use the "design" view; the third is to create a table structure through "Inter-Table import.
1. Use the "data table" View
(1) If the "Database" window has not been switched, you can press the [Fl1] key to switch from another window to the Database window.
(2) Click "table" under "object", and then click "new" on the toolbar of the "Database" window.
(3) double-click "data table View" to display an empty data table.
(4) Rename each column to be used: double-click the column name and type the column name. The naming method must comply with the Access object naming rules, and then press Enter.
(5) you can insert a new column at any time: Click the column on which you want to insert a new column to the right, and then click the "column" command in the "insert" menu. Follow the instructions in Step 4 to rename the column name.
(6) input data in the data table.
Input each type of data into the corresponding column (in Access, each column is called a field ). For example, if you are entering a name, enter the name in the Name field, and enter the surname in another different field. If you enter a date, time, or number, enter a consistent format, so that Access can create an appropriate data type and display format for the field. When saving the data table, any blank fields are deleted.
(7) after entering the data to all columns to be used, click "save" on the toolbar to save the data table.
(8) under warranty